Structure of the BOOKS table

-Which of the following methods is not used in an INSERT statement to enable the use of a DEFAULT sequence value defined for a column?
A) Use the DEFAULT keyword
B) Do not include the column
C) Use NEXTVAL to call the value
D) All of the above

Question

Structure of the BOOKS table
  ​
-Which of the following methods is not used in an INSERT statement to enable the use of a DEFAULT sequence value defined for a column?​
A) ​Use the DEFAULT keyword 
B) ​Do not include the column 
C) ​Use NEXTVAL to call the value 
D) ​All of the above

Quizplus · Accepted Answer

Using NEXTVAL to call the sequence value is not a method to enable the use of a DEFAULT sequence value in an INSERT statement. NEXTVAL is used to manually fetch the next value from a sequence, not to trigger a default value.

Structure of the BOOKS Table