PL/SQL :: Basic Concepts - Discussion
Home > PL/SQL > Basic Concepts > MCQs Questions Discussion
27 / 41
Choose the correct option.
Which two statements are true about sequences created in a single instance database? (Choose two.)
AThe numbers generated by a sequence can be used only for one table
BCURRVAL is used to refer to the last sequence number that has been generated
CWhen the MAXVALUE limit for a sequence for reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement
DWhen 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
EBoth B & C
Answer: Option (Login/Signup)
Show Explanation
Asked In ::
No Discussion on this question yet!