Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 35 of 50

Marks: +1, -0

Which two statements are true about sequences created in a single instance Oracle database? (Choose two.)

When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.
DELETE would remove a sequence from the database.
The numbers generated by an explicitly defined sequence can only be used to insert data in one table.
CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.
When a database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.

Go to Question:

Prev Question

Next Question