Multiple choice technology databases

Which of the following is a valid statement for Sequences

  1. IDENTIFIED BY

  2. USING TEMPORARY TABLESPACE

  3. MAXVALUE

  4. ON DELETE CASCADE

  5. CURRVAL

  6. NEXTVAL
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

MAXVALUE is a valid sequence parameter. Other options are invalid for sequences: IDENTIFIED BY (for users), USING TEMPORARY TABLESPACE (for users), ON DELETE CASCADE (for foreign keys), and while CURRVAL and NEXTVAL are sequence pseudocolumns, they are used in SQL statements not in sequence definition syntax.

Keep practicing — related questions