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

826cb95

2 months, 1 week ago

Selected Answer: DE

Reduce chances of gaps: so NOCACHE is preferred, since cached sequences can create gaps if the database shuts down before cache is used.

upvoted 1 times

...

dexdinh91

11 months, 2 weeks ago

Selected Answer: DE

NO CACHE

upvoted 2 times

...

mikom80

1 year, 2 months 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

1 year, 3 months ago

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

upvoted 1 times

Viviana3184

1 year ago

using NOCACHE

upvoted 1 times

...