Database Fundamentals — Question 25

You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column.
You execute the following statement:

DELETE FROM Student -
What is the result?

Answer options

• A. All rows in the table will be deleted.
• B. All rows containing a NULL value in the FirstName column will be deleted.
• C. You will receive an error message.
• D. All rows and the table definition will be deleted.

Correct answer: A

Explanation

The correct answer is A because the DELETE statement without a WHERE clause removes all rows from the table. Options B, C, and D are incorrect because B suggests selective deletion, C implies a syntax or execution error which won't occur, and D incorrectly states that the table definition will also be deleted.