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:错误,当数据库非正常关闭后,已经缓存的序列会丢失
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:错误,当数据库非正常关闭后,已经缓存的序列会丢失