Microsoft Technology Associate Mta · Free Practice Question Easy
Question 6
You have a table named Student that contains 100 rows.
Some of the rows have a NULL marker in the FirstName column.
You execute the following statement:
DELETE FROM Student
What is the result?
-
A
All rows containing a NULL value in the FirstName column will be deleted.
-
B
You will receive an error message.
-
C
All rows and the table definition will be deleted.
-
D
All rows in the table will be deleted.
Reveal correct answer
Correct answer: D
Explanation
When using the DELETE command without a WHERE clause or criteria, all records from the table will be removed.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
