Oracle Database 12c SQL 1z0-071 Question # 23 Topic 3 Discussion

Oracle Database 12c SQL 1z0-071 Question # 23 Topic 3 Discussion

1z0-071 Exam Topic 3 Question 23 Discussion:
Question #: 23
Topic #: 3

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?


A.

CREATE SEQUENCE emp_seq START WITH 1 INCRENENT BY 1 NOCACHE;


B.

CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CYCLE;


C.

CREATE SEQUENCE emp_seq NOCACHE;


D.

CREATE SEQUENCE emp_seq START WITH 1 CACHE;


E.

CREATE SEQUENCE emp_seq START WITH 1 INCREMENT BY 1 CACHE;


F.

CREATE SEQUENCE emp_seq;


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.