Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 211

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.

Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times.

Column ORD_NO gets the next number from sequence and ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.

If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.

Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

Correct Answer: C, E

The ORD_NO column in the ORD_ITEMS table is set to get the next number from the sequence ORD_SEQ automatically whenever a row is inserted without an explicit value for ORD_NO, ensuring that all entries have a unique value unless explicitly specified otherwise. Meanwhile, any user inserting rows into the ORD_ITEMS table needs to have been granted access to the ORD_SEQ sequence to ensure they have the necessary permissions to generate the sequence value.

Discussion

ShrimathiOptions: AE

would be A,E. we can insert ord_no explicitly.

x33

A is wrong. in the sequence code there is cycle. it means once it has reach the maxvalue start all over from 1. i.e duplicate.

yaya32Options: CE

C for sure, then I am unsure D or E

zangadoOptions: CE

E is correct only if we assume that user doesn't insert ord_no explicitly. If he does than he doesn't need the select privilege on the sequence. In my oppinion only C is correct.

ogi33

• During table creation, the sequence must exist and you must have select privilege on it for it to be used as a column default. • The users performing inserts against the table must have select privilege on the sequence, as well as insert privilege on the table.

jm9999Options: CE

Cannot be A because of 'cycle' specification.