Multiple Choice
Which of the following is a valid SQL statement when referencing a sequence?
A) INSERT INTO orderitems
VALUES (currval,1,811794939,1) ;
B) INSERT INTO orderitems
VALUES (currentval,1,811794939,1) ;
C) INSERT INTO orderitems
VALUES (nextvalue,1,811794939,1) ;
D) none of the above
Correct Answer:
Verified
Correct Answer:
Verified
Q98: A database index allows users and application
Q99: The INCREMENT BY setting for a sequence
Q100: By default,the START WITH clause has a
Q101: Which options are used in application cluster
Q102: Which of the following statements about NEXTVAL
Q104: A(n)_ synonym is used by others to
Q105: Which of the following commands is used
Q106: The _ pseudocolumn is used to generate
Q107: What are the benefits and disadvantages of
Q108: Who can remove a public synonym from