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

Question

Options

• AIt removes all the rows as well as the structure of the table
• BIt removes all the rows in the table and deleted rows cannot be rolled back
• CIt removes all the rows in the table and deleted rows can be rolled back
• DIt would not remove the rows if the table has a primary key

• A
  17% (11)
• B
  8% (5)
• C
  71% (47)
• D
  5% (3)

No community discussion yet for this question.