Which statement is true about the DELETE statement?

Evaluate the following DELETE statement:
DELETE FROM sales;
There are no other uncommitted transactions on the SALES table.
Which statement is true about the DELETE statement?

Evaluate the following DELETE statement:
DELETE FROM sales;
There are no other uncommitted transactions on the SALES table.
Which statement is true about the DELETE statement?

A.
It would not remove the rows if the table has a primary key.

B.
It removes all the rows as well as the structure of the table.

C.
It removes all the rows in the table and deleted rows can be rolled back.

D.
It removes all the rows in the table and deleted rows cannot be rolled back.



Leave a Reply 1

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