OCP-1Z0-051 第45题 SEQUENCE(序列)的注意事项

最新推荐文章于 2019-08-27 17:29:14 发布

原创

最新推荐文章于 2019-08-27 17:29:14 发布 · 5.4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#OCP-1Z0-051 #sequence #ALTER SEQUENCE #DROP #序列

本文讨论了在单实例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

二、题目翻译