本文讨论了在单实例Oracle数据库中序列的管理，包括ALTER SEQUENCE增加MAXVALUE限制的正确用法，以及序列异常关闭后的状态。错误地认为DELETE能删除序列，实际上应使用DROP SEQUENCE，而异常关闭数据库会导致未使用的序列号丢失。
一、原题
二、题目翻译
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 is 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.
答案：CD
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 is 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.
答案：CD
二、题目翻译
最低0.47元/天 解锁文章
1450
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
