Which statement is true about the DELETE statement?

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

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

A.
It removes all the rows in the table and allows ROLLBACK

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

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

D.
It removes all the rows in the table and does not allow ROLLBACK



Leave a Reply 1

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