What is the result?

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?

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Sven

Sven

If you do a DELETE FROM without using a WHERE clause, the entire thing will be deleted.

Jain

Jain

A-All rows in the table will be deleted.