ocp 11g試題解析：1Z0-051-045題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp 11g試題解析：1Z0-051-045題，完整題庫請點擊這里聯系老師咨詢了解
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 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不正確，因為刪除序列的語句為DROP SEQUENCE sequencename
C正確，對，CURRVAL是最后的那個值
D正確，對當最大值達到極限時，可以通過ALTER SEQUENCE修改序列來增加最大值
E不正確，因為如果內存非正常關閉，緩存的數會丟失。
如果建立序列時不指定CACHE和NOCACHE，默認值為20，
即一次性從序列里取20個數放入內存，如果內存崩潰，則這20個數就會丟失，再取值時從第21個數開始取值，CACHE設置的最小值為2。
