Which two statements are true in this scenario?

Exhibit: View the Exhibit to see the data in the emp table. You created a PRIMARY KEY
constraint on the empno column of the emp table, and the constraint is not deferred. Which
two statements are true in this scenario? (Choose two.)

Exhibit: View the Exhibit to see the data in the emp table. You created a PRIMARY KEY
constraint on the empno column of the emp table, and the constraint is not deferred. Which
two statements are true in this scenario? (Choose two.)

A.
A NOT NULL constraint would be enforced on the empno column.

B.
A bitmap unique index would be created on the empno column.

C.
A CHECK constraint would be enforced on the empno column.

D.
A unique index on the empno column would be created.

E.
No index would be created or used in this case.

Explanation:



Leave a Reply 3

Your email address will not be published. Required fields are marked *


M

M

Exhibit is missing!

M2

M2

The exhibit is not needed to answer this question.

Đồng Nai

Đồng Nai

Primary key => implicit creation of unique index and not null constaint.