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

Verified
Correct Answer:
Verified
Q12: By default,the lowest value that can be
Q14: When a sequence is created for internal
Q20: A(n)_ can be used to quickly locate
Q50: When a positive value is assigned to
Q52: The keyword _ must be used in
Q71: Which of the following SQL statements will
Q73: The START WITH clause is used to
Q99: The INCREMENT BY setting for a sequence
Q109: The <u>USER_SEQ </u>data dictionary view can be
Q119: The <u>GENERATE</u> option can be used to