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

最新推荐文章于 2019-08-24 01:21:04 发布

今年我18

最新推荐文章于 2019-08-24 01:21:04 发布

阅读量2.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.youkuaiyun.com/dwj19830118/article/details/50739519

1z0-051 专栏收录该内容

175 篇文章

订阅专栏

本文解析了Oracle数据库中序列的功能特点，澄清了一些常见的误解，并详细解释了CURRVAL和NEXTVAL的作用，以及如何调整序列的最大值。

45.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:错误，都可以使用
B:错误，应该使用drop删除
C:正确
D:正确
E:错误，当数据库非正常关闭后，已经缓存的序列会丢失