Oracle
1Z0-071 · Question #324
Evaluate these commands which execute successfully: Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
The correct answer is B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers. See the full explanation below for the reasoning.
Question
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
Exhibit
Options
- ASequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times.
- BAny user inserting rows into table ORD_ITEMS must have been granted access to sequence
- CColumn ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted
- DIf sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for
- ESequence ORD_SEQ is guaranteed not to generate duplicate numbers.
How the community answered
(33 responses)- A6% (2)
- B70% (23)
- C18% (6)
- D6% (2)
Community Discussion
No community discussion yet for this question.