Structure of the CUSTOMERS table

-Which of the following commands can be used to create a sequence for the CUSTOMERS table?
A) CREATE SEQUENCE customers_customer#;
B) CREATE SEQUENCE customers_customer# START WITH 2000 MAXVALUE 999;
C) CREATE SEQUENCE customers_customer# INCREMENT BY -1 NOCACHE|CACHE;
D) all of the above

Question

Structure of the CUSTOMERS table
 
-Which of the following commands can be used to create a sequence for the CUSTOMERS table?
A) CREATE SEQUENCE customers_customer#; 
B) CREATE SEQUENCE customers_customer# START WITH 2000 MAXVALUE 999; 
C) CREATE SEQUENCE customers_customer# INCREMENT BY -1 NOCACHE|CACHE; 
D) all of the above

Quizplus · Accepted Answer

The Answer of Structure of the CUSTOMERS table
 
-Which of the following commands can be used to create a sequence for the CUSTOMERS table?
A) CREATE SEQUENCE customers_customer#; 
B) CREATE SEQUENCE customers_customer# START WITH 2000 MAXVALUE 999; 
C) CREATE SEQUENCE customers_customer# INCREMENT BY -1 NOCACHE|CACHE; 
D) all of the above

Structure of the CUSTOMERS Table