Evaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seq1S – McqOptions

MCQOPTIONS

1.	Evaluate the following CREATE SEQUENCE statement:CREATE SEQUENCE seq1START WITH 100INCREMENT BY 10MAXVALUE 200CYCLENOCACHE;The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:SELECT seq1.nextval FROM dual;What is displayed by the SELECT statement?
A.	1
B.	10
C.	100
D.	An error
Answer» B. 10

Discussion

No Comment Found

Related MCQs

In timestamp ordering protocol, suppose that the transaction Ti issues read(Q) and TS(Ti)
In timestamp ordering protocol, suppose that the transaction Ti issues write(Q) and TS(Ti)
The type of constraints that specifies the uniqueness of data stored in the database are considered as
The property of DBMS which ensures the execution of all the operations in transaction or none of the operation is executed is classified as
The control feature in database management system which ensures the accuracy of data updated by multiple users is classified as
The property of DBMS which ensures whether the hundreds of applications are executed, each transaction must be executed in isolation is classified as
In crabbing protocol the the lock obtained on the root node is in _________ mode.
Instead of locking index leaf nodes in a two-phase manner, some index concurrency-control schemes use ___________ on individual key values, allowing other key values to be inserted or deleted from the same leaf.
The extent of the database resource that is included with each lock is called the level of
Evaluate the CREATE TABLE statement:CREATE TABLE products(product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15));Which statement is true regarding the PROD_ID_PK constraint?