OCP-1Z0-051-题目解析-第45题

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. 


Answer: CD

A：序列器产生的数字只能用在一个表上（错误，可以用在多个表上）
B：DELETE <sequencename> 将会从数据库中移除一个序列器（错误，正确的是DROP SEQUENCE <sequencename>）
C：CURRVAL是序列器产生的最新的一个值 （正确）
D：当一个序列器的MaxValue限制到了，你可以通过alter sequence 增加Maxvalue limit。（正确）
E：当数据库异常的宕机了，已经缓存的序列号会在数据库重新启动后仍然可用（错误，当数据量异常宕机，内存中的数据会丢失，已经缓存的序列号也会丢失。）