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.



Leave a Reply 1

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