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?

Question

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?

Accepted Answer

A. All rows in the table will be deleted.

Answer

B. All rows containing a NULL value in the FirstName column will be deleted.

Answer

C. You will receive an error message.

Answer

D. All rows and the table definition will be deleted.

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?

Question

Options

How the community answered

Community Discussion