Multiple Choice
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
C) CREATE SEQUENCE customers_customer#
INCREMENT BY -1
NOCACHE|CACHE;
D) all of the above
Correct Answer:

Verified
Correct Answer:
Verified
Q118: The highest possible value for a descending
Q119: The <u>GENERATE</u> option can be used to
Q120: Which of the following is used to
Q121: An index is implicitly created when a
Q122: Using an identity column is particularly suited
Q124: The starting value for a sequence cannot
Q125: The <u>CYCLE</u> option prevents a sequence from
Q126: <u>Indexes</u> are usually created for frequently referenced
Q127: Which of the following keywords is used
Q128: The last value generated by a sequence