Quiz for Types of SQL Commands

Q1: Which category does the SELECT statement belong to?

A. DDL B. DML C. DQL D. TCL

Q2: Which type of SQL command is used to modify existing records?

A. DDL B. DML C. DCL D. TCL

Q3: What type of SQL command is GRANT?

A. DDL B. DCL C. DML D. TCL

Q4: Which command falls under TCL?

A. SELECT B. INSERT C. COMMIT D. DROP

Q5: Which command is used to create a new table?

A. CREATE B. INSERT C. UPDATE D. ROLLBACK

Q6: Which of the following is not a DDL command?

A. ALTER B. DROP C. TRUNCATE D. SELECT

Q7: Which SQL command is used to permanently save transactions?

A. ROLLBACK B. COMMIT C. SAVEPOINT D. GRANT

Q8: Which of these is a DML command?

A. INSERT B. GRANT C. COMMIT D. TRUNCATE

Q9: What does DDL stand for?

A. Data Description Language B. Data Definition Language C. Data Deletion Language D. Data Deployment Language

Q10: Which command is used to remove all records from a table?

A. DELETE B. DROP C. TRUNCATE D. REMOVE

Q11: Which command is used to revoke user access?

A. GRANT B. REVOKE C. DENY D. BLOCK

Q12: The ROLLBACK command is part of which SQL category?

A. DML B. DDL C. TCL D. DCL

Q13: Which is used to change structure of a table?

A. ALTER B. UPDATE C. INSERT D. SELECT

Q14: Which SQL command is used to add a constraint?

A. INSERT B. ALTER C. DELETE D. GRANT

Q15: What does DML stand for?

A. Data Modeling Language B. Data Manipulation Language C. Database Management Language D. Data Method Language

Q16: Which command is used to remove a table completely?

A. DELETE B. DROP C. TRUNCATE D. CLEAR

Q17: Which SQL command saves work done in the database?

A. COMMIT B. ROLLBACK C. DELETE D. SAVEPOINT

Q18: SAVEPOINT is a part of which SQL command type?

A. DDL B. DML C. TCL D. DCL

Q19: What is the purpose of the GRANT command?

A. Modify tables B. Control access C. Insert data D. Query data

Q20: Which command is used to restore the database to a previous state?

A. ROLLBACK B. COMMIT C. DELETE D. GRANT