Evaluate The Following Create Sequence Statementp Pre Langsql #110

Evaluate the following CREATE SEQUENCE statement:</p> <pre><code class="language-sql">CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE;</code></pre> <p>The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:<br /> SELECT seq1.nextval FROM dual;<br /> What is displayed by the SELECT statement?

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Concurrency Control - Snapshot Isolation - Quiz No.1.

CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE;