Oracle
1Z0-061 · Question #319
Study the following exhibit: Assuming that the sequence SEQ1 was created with the option ORDER and INCREMENT BY set to 1, what value will be returned by the final SELECT statement? (Choose the best…
The correct answer is D. It will depend on whether any other sessions are selecting from the sequence while the. See the full explanation below for the reasoning.
Question
Study the following exhibit:
Assuming that the sequence SEQ1 was created with the option ORDER and INCREMENT BY set to 1, what value will be returned by the final SELECT statement? (Choose the best answer.)
Exhibit
Options
- A2
- B3
- C4
- DIt will depend on whether any other sessions are selecting from the sequence while the
How the community answered
(20 responses)- A5% (1)
- B5% (1)
- C10% (2)
- D80% (16)
Community Discussion
No community discussion yet for this question.