Computer Science
Answer
UPDATE
Reason — Data Definition Language (DDL) statements are used to define, modify, and delete database objects such as tables, views, indexes, etc. The DDL commands are CREATE, ALTER, TRUNCATE, DROP etc. But the UPDATE command is Data Manipulation Language (DML) command, used to modify existing data in a table.
Related Questions
Which command defines its columns, integrity constraint in create table :
- Create table command
- Drop table command
- Alter table command
- All of these
Which command is used for removing a table and all its data from the database :
- Create table command
- Drop table command
- Alter table command
- All of these
Which of the following is not a legal constraint for a CREATE TABLE command ?
- Primary key
- Foreign key
- Unique
- Distinct
Fill in the blanks:
A database can be opened with _________ <database> command.