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.
No index would be created or used in this case.

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

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

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

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



Leave a Reply 2

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


zzzZZZzzzZZzzz

zzzZZZzzzZZzzz

Exhibit not showing

jean

jean

Constraint not deferred.
PK created.