nerdexam
Oracle

1Z0-082 · Question #68

1Z0-082 Question #68: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-082 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.

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

1Z0-082 question #68 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

Unlock 1Z0-082 to see the answer

You've previewed enough free 1Z0-082 questions. Unlock 1Z0-082 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-082 Practice