Which two statements about sequences are true? (Choose two)

Question

Options

• AYou use a NEXTVAL pseudo column to look at the next possible value that would be generated
• BYou use a CURRVAL pseudo column to look at the current value just generated from a sequence,
• CYou use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually
• DYou use a CURRVAL pseudo column to generate a value from a sequence that would be used for
• EIf a sequence starting from a value 100 and incremented by 1 is used by more then one application,
• FYou use REUSE clause when creating a sequence to restart the sequence once it generates the

• A
  7% (4)
• B
  75% (42)
• D
  13% (7)
• E
  2% (1)
• F
  4% (2)

Explanation

You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence. Incorrect Answers A: You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence. D: You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence. E: This statement is not correct. There is no limitation like that in Oracle. F: You use CYCLE clause, not REUSE, when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

No community discussion yet for this question.