Quiz for DROP

Q1: What happens when the DROP command is used on a table?

A. Only data is deleted B. The table structure is preserved C. Table is renamed D. The table and its data are permanently deleted

Q2: What does the DROP statement do in SQL?

A. Drops the database only B. Deletes rows from a table C. Deletes the structure and data of a database object D. Resets the table

Q3: Which SQL command permanently deletes a table from the database?

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

Q4: Which of the following can be dropped using DROP?

A. Tables B. Views C. Databases D. All of the above

Q5: What will happen if you drop a table that is referenced by a foreign key in another table?

A. It will drop the foreign key automatically B. It will generate an error C. It will drop both tables D. It will ignore the constraint

Q6: Which keyword is used to remove a database?

A. REMOVE DATABASE B. DELETE DATABASE C. DROP DATABASE D. CLEAR DATABASE

Q7: What is the result of DROP TABLE employees;

A. Deletes all rows from employees B. Deletes structure and rows C. Resets all data to NULL D. Updates all rows to blank

Q8: Which is NOT a valid use of DROP?

A. DROP INDEX B. DROP TABLE C. DROP USER D. DROP COLUMN

Q9: To delete a view permanently, which SQL statement is correct?

A. DROP VIEW view_name; B. DELETE view_name; C. REMOVE view view_name; D. TRUNCATE view_name;

Q10: Can DROP be rolled back if not committed?

A. Yes, always B. No, it is auto-committed C. Only if using transactions D. Depends on DBMS

Q11: What happens to dependent objects when a table is dropped?

A. They remain intact B. They are dropped automatically C. They throw an error D. They are converted to NULL

Q12: What is the output of DROP INDEX idx_name ON table_name?

A. Drops the table B. Drops the database C. Drops the specified index D. None of the above

Q13: Which clause is used to ensure object exists before drop?

A. IF DEFINED B. IF PRESENT C. IF EXISTS D. IF AVAILABLE

Q14: Which error is likely when dropping a table with foreign keys?

A. Syntax Error B. Reference Error C. Integrity Constraint Violation D. Row Not Found

Q15: DROP SCHEMA is used to:

A. Delete a user B. Delete all objects in a schema C. Truncate a table D. Delete all databases

Q16: Is DROP reversible without backup?

A. Yes B. No C. Only in MySQL D. Only on temporary tables

Q17: Which is safer for temporary removal of data?

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

Q18: To drop a constraint, which command is correct?

A. ALTER TABLE DROP CONSTRAINT constraint_name; B. DROP CONSTRAINT FROM table_name; C. REMOVE constraint_name; D. DELETE CONSTRAINT constraint_name;

Q19: What happens to indexes when a table is dropped?

A. They are preserved B. They are backed up C. They are dropped automatically D. They are converted to sequences

Q20: DROP TABLE IF EXISTS table_name; ensures what?

A. Always drops the table B. Drops if table exists C. Throws error if not exists D. Creates table if missing

Q21: How can you prevent accidental DROP of important tables?

A. Use TRUNCATE instead B. Set foreign keys C. Use RESTRICT option D. Use permissions and backups