Database Fundamentals — Question 20

This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALTER statement to add a new table in a database.
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. UPDATE
• C. INSERT
• D. CREATE

Correct answer: D

Explanation

The correct answer is D, as the CREATE statement is the appropriate SQL command for adding a new table to a database. The ALTER statement is used to modify existing tables, while UPDATE and INSERT are used for altering records within tables.