Practice mode DBMS and SQL

Which of the following SQL commands is a Data Definition Language (DDL) command?

Correct answer B. ALTER

Explanation

DDL commands define or change the structure of database objects: CREATE, ALTER, DROP and TRUNCATE. ALTER TABLE changes an existing table's definition, for example by adding a column. INSERT is DML because it changes data rows, GRANT is DCL because it controls privileges, and COMMIT is TCL because it ends a transaction. Knowing these four families is a frequent exam point.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.