COEPRO3 MIDTERM EXAMINATION

What is the purpose of the DROP command in MySQL?

• Delete specific data from a table
• Remove a column from a table
• Delete an entire database
• Remove an entire table from the database

What is the correct syntax for the DROP command to remove a table?

• DELETE TABLE table_name;
• REMOVE TABLE table_name;
• DROP TABLE table_name;
• ERASE TABLE table_name;

When using the DROP command, what happens to the table structure and data?

• The table structure is deleted, but data remains intact.
• The table data is deleted, but the table structure remains.
• Both the table structure and data are permanently deleted.
• An error occurs, and the DROP command fails.

What is the correct way to use the DROP command to remove multiple tables simultaneously?

• DROP TABLE table1, table2, ...;
• DROP MULTIPLE TABLES table1, table2, ...;
• DROP TABLES table1 AND table2;
• DROP ALL TABLES table1, table2, ...;

Which of the following is NOT a valid option for the DROP command in MySQL?

• DROP IF EXISTS
• DROP TABLE IF EXISTS
• DROP CHECK
• DROP TEMPORARY TABLE

What is the correct way to drop a database using the DROP command?

• DROP DATABASE database_name;
• DELETE DATABASE database_name;
• ERASE DATABASE database_name;
• REMOVE DATABASE database_name;

Which option is used with the DROP command to remove a view in MySQL?

• DROP VIEW
• REMOVE VIEW
• DELETE VIEW
• ERASE VIEW

What is the correct syntax to drop a column from a table using the ALTER TABLE command?

• ALTER TABLE table_name DROP COLUMN column_name;
• DROP COLUMN column_name FROM table_name;
• DROP COLUMN column_name ALTER TABLE table_name;
• DROP COLUMN table_name FROM column_name;

When using the DROP command with the EVENT keyword, what is dropped?

• An entire database
• A specific row from a table
• A stored procedure
• A scheduled event in the event scheduler

Which of the following is true about the DROP command's logging behavior in MySQL?

• The DROP command is logged in the binary log for replication.
• The DROP command is never logged to keep the log file small.
• The DROP command is logged only in the undo log.
• The logging behavior of the DROP command depends on the MySQL version.