Database Fundamentals — Question 18

This question requires that you evaluate the underlined text to determine if it is correct.
The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those tables.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

Answer options

• A. No change is needed
• B. DROP TABLE
• C. TRUNCATE TABLE
• D. ALTER TABLE

Correct answer: B

Explanation

The CREATE TABLE command is used to create new tables, not to remove them. The correct command for deleting table definitions along with all associated data and structures is DROP TABLE, which is why B is the right answer and the other options do not apply in this context.