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;
Examine this list of requirements for a sequence:1. Name: EMP_SEQ2. First value returned: 13. Duplicates are never permi
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am