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?

Question

Options

• AIt removes all the rows in the table and allows ROLLBACK.
• BIt would not remove the rows if the table has a primary key.
• CIt removes all the rows as well as the structure of the table.
• DIt removes all the rows in the table and does not allow ROLLBACK.

• A
  81% (21)
• B
  4% (1)
• C
  4% (1)
• D
  12% (3)

No community discussion yet for this question.