DAY 17 - MySQL Commands: DDL, DML, TCL (2nd July 2024)

Which of the following is a DDL command in SQL?

• SELECT

• INSERT

• CREATE

• UPDATE

What does DML stand for in SQL?

• Data Modification Language

• Data Manipulation Language

• Data Management Language

• Data Mining Language

Which of the following commands is used to delete a table in

SQL?

• DELETE

• DROP

• REMOVE

• ERASE

Which command is used to insert new data into a table?

• ADD

• INSERT

• UPDATE

• APPEND

Which command is used to change the structure of a table?

• ALTER

• MODIFY

• CHANGE

• UPDATE

Which of the following commands is used to save all changes

made during the current transaction?

• SAVE

• APPLY

• COMMIT

• EXECUTE

Which command removes all rows from a table without

logging the individual row deletions?

• DELETE

• ERASE

• CLEAR

• TRUNCATE

Which command is used to undo transactions that have not

yet been saved to the database?

• UNDO

• REVERT

• ROLLBACK

• CANCEL

Which DML command is used to modify existing records in a

table?

• CHANGE

• UPDATE

• MODIFY

• ALTER

Which of the following commands is a TCL command?

• SELECT

• COMMIT

• DELETE

• CREATE