Oracle Certification Exam Question:
Download Questions PDF

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?
A. It would not remove the rows if the table has a primary key
B. It removes all the rows as well as the structure of the table
C. It removes all the rows in the table and deleted rows can be rolled back
D. It removes all the rows in the table and deleted rows cannot be rolled back

Answer:

C. It removes all the rows in the table and deleted rows can be rolled back

Download Oracle Certification Interview Questions And Answers PDF

Previous QuestionNext Question
What is row chaining and row migration?Explain Which two statements are true about sequences created in a single instance database? (Choose
two.)
A. The numbers generated by a sequence can be used only for one table
B. DELETE <sequencename> would remove a sequence from the database
C. CURRVAL is used to refer to the last sequence number that has been generated
D. When the MAXVALUE limit for a sequence for reached, you can increase the MAXVALUE limit
by using the ALTER SEQUENCE statement
E. When a database instance shuts down abnormally, the sequence numbers that have been
cached but not used would be available once again when the database instance is restarted