MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which is the correct DDL group
A
CREATE, DELETE, DROP
B
ALTER, DROP, INSERT
C
UPDATE, SELECT, DROP
D
CREATE, DROP, ALTER
Explanation: 

Detailed explanation-1: -List of DDL commands: CREATE: This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers). DROP: This command is used to delete objects from the database. ALTER: This is used to alter the structure of the database.

Detailed explanation-2: -CREATE is a DDL command used to create databases, tables, triggers and other database objects.

Detailed explanation-3: -ALTER SQL command is a DDL (Data Definition Language) statement. ALTER is used to update the structure of the table in the database (like add, delete, modify the attributes of the tables in the database).

There is 1 question to complete.
Previous
Next