1.Which of the following objects can be dropped using the DROP statement?
-
A. Tables
-
B. Databases
-
C. Views
-
D. All of the above
All of the above
All of the above
2.Can a dropped table be recovered using ROLLBACK?
-
A. Yes
-
B. No
-
C. Only in MySQL
-
D. Only if it’s temporarily dropped
No
No
3.Which is the correct syntax to drop a database?
-
A. DROP TABLE database_name;
-
B. DELETE FROM database_name;
-
C. DROP DATABASE database_name;
-
D. REMOVE DATABASE database_name;
DROP DATABASE database_name;
DROP DATABASE database_name;
4.What is the difference between DROP and TRUNCATE?
-
A. DROP deletes rows only
-
B. TRUNCATE removes the table completely
-
C. DROP removes both data and structure; TRUNCATE removes only data
-
D. Both are identical
DROP removes both data and structure; TRUNCATE removes only data
DROP removes both data and structure; TRUNCATE removes only data
5.What happens to indexes when a table is dropped?
-
A. They are converted to temporary indexes
-
B. They are preserved
-
C. They are dropped along with the table
-
D. They are moved to another schema
They are dropped along with the table
They are dropped along with the table