Oracle
1Z0-082 · Question #68
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.
Manage Schema Objects
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
- AIf sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for
- 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
- DSequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
- ESequence ORD_SEQ is guaranteed not to generate duplicate numbers
How the community answered
(53 responses)- A6% (3)
- B79% (42)
- C11% (6)
- D4% (2)
Topics
#sequences#default column values#sequence privileges#NOCYCLE
Community Discussion
No community discussion yet for this question.