DELETE FROM sales;
And if there are no other uncommitted transactions on the
sales table. Which statement is true about the
It removes all the rows in the table and deleted rows cannot be rolled back
It removes all the rows as well as the structure of the table
It would not remove the rows if the table has a primary key
It removes all the rows in the table and deleted rows can be rolled back
of course, right answer lays between 1 and 4. I don't know whether the deleted data can be rolled back or not.
If any one knows, please help me. thanks.