PrepAway - Latest Free Exam Questions & Answers

What will happen?

A table named STATES was created as follows: What will happen?

PrepAway - Latest Free Exam Questions & Answers

A.
A warning will be returned and the unique index INDX1 will become the index for the
primary key.

B.
The primary key will be successfully added and the unique index INDX1 will be dropped
and recreated as the primary key index.

C.
An error will be returned and the operation will fail.

D.
The primary key will be successfully added, the unique index INDX1 will be dropped, and
a new index will be created for the primary key.


Leave a Reply