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
A