Multiple choice technology databases

Which of the following is not a DDL statement?

  1. CREATE

  2. DROP

  3. MODIFY

  4. ALTER

  5. GRANT

  6. REPLACE
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

DDL (Data Definition Language) statements define database structures - these include CREATE, ALTER, DROP, TRUNCATE, and RENAME. GRANT is a DCL (Data Control Language) statement used to give user permissions on database objects, not to define database structures. Since the question asks which is NOT a DDL statement, GRANT is the correct answer.

AI explanation

DDL (Data Definition Language) statements define or modify database structure — CREATE, DROP, ALTER, and MODIFY all fall in this category. GRANT belongs to DCL (Data Control Language), since it manages permissions/access rights rather than schema structure, which is why it's the odd one out.

Keep practicing — related questions