Oracle
1Z0-071 · Question #424
1Z0-071 Question #424: Real Exam Question with Answer & Explanation
The correct answer is B. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CACHE; D. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 NOCACHE;. See the full explanation below for the reasoning.
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;
Community Discussion
No community discussion yet for this question.