ActualTests.com
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
Answer: C,D
QUESTION NO: 4
The SQL statements executed in a user session as follows:
Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a
command in the session? (Choose two.)
A. The rollback generates an error
B. No SQL statements are rolled back
C. Only the DELETE statements are rolled back
D. Only the seconds DELETE statement is rolled back
E. Both the DELETE statements and the UPDATE statement are rolled back
Answer: A,B
QUESTION NO: 5
Which three statements/commands would cause a transaction to end? (Choose three.)
A. COMMIT
B. SELECT
C. CREATE
Oracle 1z0-051: Practice Exam
"Pass Any Exam. Any Time." - www.actualtests.com 4
