6.What must be ensured before dropping a table with foreign key dependencies?
-
A. Nothing — drop is automatic
-
B. Foreign key constraints must be dropped or disabled
-
C. The table must be truncated first
-
D. Rename the table before dropping
Foreign key constraints must be dropped or disabled
Foreign key constraints must be dropped or disabled
7.What happens to data after DROP TABLE employees;?
-
A. Data is moved to a recycle bin
-
B. Data can be recovered
-
C. Data and structure are permanently removed
-
D. Data is archived automatically
Data and structure are permanently removed
Data and structure are permanently removed
8.Which of the following is not a valid DROP command?
-
A. DROP INDEX index_name;
-
B. DROP VIEW view_name;
-
C. DROP COLUMN column_name;
-
D. DROP TABLE table_name;
DROP COLUMN column_name;
DROP COLUMN column_name;
9.What happens if you try to drop a table that doesn’t exist?
-
A. It silently skips
-
B. It throws an error
-
C. It creates the table
-
D. It deletes an empty placeholder
It throws an error
It throws an error
10.DROP TABLE command affects:
-
A. Only current session
-
B. Only selected rows
-
C. Entire table and metadata
-
D. Only indexes
Entire table and metadata
Entire table and metadata