A sequence is referenced in SQL statements with the NEXTVAL and CURRVA – McqOptions

MCQOPTIONS

1.	A sequence is referenced in SQL statements with the NEXTVAL and CURRVAL pseudocolumns, what can be used in the following places?1) VALUES clause of INSERT statements2) The SELECT list of a SELECT statement3) The SET clause of an UPDATE statement
A.	CURRVAL
B.	NEXTVAL
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

No Comment Found

Related MCQs

To drop a private synonym in another user's schema, you must have which system privilege?
Which is a database objects from which multiple users can generate unique integers?
Which view Shows all columns in all tables and views accessible to the user that are modifiable in the UPDATABLE_COLUMNS VIEWS?
What are the following guidelines used for?1) Be sure the sequence cache can hold all the sequences used concurrently by your applications2) Increase the number of values for each sequence held in the sequence cache
Which privilege from the following is used to create a private synonym in another user's schema?
You cannot use an ALTER VIEW statement to change the definition of a view but you can replace views in which of the following ways?
What is / are the rules for updatable join views in which rule any INSERT, UPDATE, or DELETE operation on a join view can modify only one underlying base table at a time?
A sequence is referenced in SQL statements with the NEXTVAL and CURRVAL pseudocolumns, what can be used in the following places?1) VALUES clause of INSERT statements2) The SELECT list of a SELECT statement3) The SET clause of an UPDATE statement
What is a Sequence with each new sequence number that is generated by a reference to the sequence pseudocolumn called?