Exam 1z0-071 topic 1 question 33 discussion

Actual exam question from Oracle's 1z0-071

Question #: 33
Topic #: 1

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.)

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;

Show Suggested Answer

Suggested Answer: DE 🗳️

by karols32 at Sept. 19, 2022, 6:31 p.m.

Comments

Submit Cancel

dexdinh91

7 months ago

Selected Answer: DE

NO CACHE

upvoted 2 times

...

mikom80

10 months, 1 week ago

if there is cache option sequence get some numbers (for example 10). if oracle used some of this (less than 10) and restart instance occurs, then will be gap, because oracle will cache next 10 numbers.

upvoted 2 times

...

karols32

10 months, 3 weeks ago

How reduce the chances of gaps in the values by syntax?

upvoted 1 times

Viviana3184

7 months, 3 weeks ago

using NOCACHE