Computer Science
Which of the following is not a DDL command ?
- UPDATE
- TRUNCATE
- ALTER
- None of these
DDL & DML
2 Likes
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.
Answered By
2 Likes
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.