[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.

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 :: Virtusa

Post Your Answer Here:     

No Discussion on this question yet!