Oracle
1Z0-071 · Question #424
Examine this list of requirements for a sequence: 1. Name: EMP_SEQ 2. First value returned: 1 3. Duplicates are never permitted. 4. Provide values to be inserted into the EMPLOYEES.EMPLOYEE_ID…
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #424. The question stem and answer options stay visible for context.
Question
Examine this list of requirements for a sequence: 1. Name: EMP_SEQ 2. First value returned: 1 3. Duplicates are never permitted. 4. Provide values to be inserted into the EMPLOYEES.EMPLOYEE_ID column. 5. Reduce the chances of gaps in the values. Which two statements will satisfy these requirements? (Choose two.)
Options
- ACREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CYCLE;
- BCREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CACHE;
- CCREATE SEQUENCE emp_seq;
- DCREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 NOCACHE;
- ECREATE SEQUENCE emp_seq NOCACHE;
- FCREATE SEQUENCE emp_seq START WITH 1 CACHE;
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.