Oracle

1Z0-061 · Question #320

A UNIQUE constraint on a column requires an index. Which of the following scenarios is correct? (Choose one or more correct answers.)

The correct answer is A. If a UNIQUE index already exists on the column, it will be used. B. If a NONUNIQUE index already exists it will be used. See the full explanation below for the reasoning.

Question

A UNIQUE constraint on a column requires an index. Which of the following scenarios is correct? (Choose one or more correct answers.)

Options

AIf a UNIQUE index already exists on the column, it will be used.
BIf a NONUNIQUE index already exists it will be used.
CIf a NONUNIQUE index already exists on the column, a UNIQUE index will be created implicitly.
DIf any index exists on the column, there will be an error as Oracle attempts to create another

How the community answered

(20 responses)

A
75% (15)
C
20% (4)
D
5% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-061 Practice