For which two constraints does the Oracle Server implicitly create a unique index? (Choose two.)

The correct answer is B. PRIMARY KEY E. UNIQUE. Indexes are created automatically by Oracle to support integrity constraints that enforce uniqueness. The two types of integrity constraints that enforce uniqueness are PRIMARY KEY and UNIQUE constraints. When the primary key or UNIQUE constraint is declared, a unique index to…

Monitor and Troubleshoot a XenDesktop 7 Environment

Question

Options

ANOT NULL
BPRIMARY KEY
CFOREIGN KEY
DCHECK
EUNIQUE

How the community answered

(42 responses)

A
10% (4)
B
83% (35)
C
2% (1)
D
5% (2)

Explanation

Indexes are created automatically by Oracle to support integrity constraints that enforce uniqueness. The two types of integrity constraints that enforce uniqueness are PRIMARY KEY and UNIQUE constraints. When the primary key or UNIQUE constraint is declared, a unique index to support the column's uniqueness is also created, and all values in all columns that were defined as part of the primary key or UNIQUE constraint are placed into the index. Incorrect Answers A: Oracle will not implicitly create an unique index for the NOT NULL constraint. C: Oracle will not implicitly create an unique index for the FOREIGN KEY constraint. D: Oracle will not implicitly create an unique index for the FOREIGN KEY constraint.

Topics

#Oracle constraints#unique index#PRIMARY KEY constraint#UNIQUE constraint

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice