Examine this list of requirements for a sequence:1. Name: EMP_SEQ2. First value returned: 13. Duplicates are never permi
Posted: Sun Jun 11, 2023 3:54 pm
Examine this list of requirements for a sequence:1. Name: EMP_SEQ2. First value returned: 13. 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.)
A. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CYCLE;
B. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CACHE;
C. CREATE SEQUENCE emp_seq;
D. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 NOCACHE; E. CREATE SEQUENCE emp_seq NOCACHE; F. CREATE SEQUENCE emp_seq START WITH 1 CACHE;
A. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CYCLE;
B. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CACHE;
C. CREATE SEQUENCE emp_seq;
D. CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 NOCACHE; E. CREATE SEQUENCE emp_seq NOCACHE; F. CREATE SEQUENCE emp_seq START WITH 1 CACHE;