54. 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 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.
Answer: CD
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718839/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
