A table named STATES was created as follows:

What will happen?

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

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

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

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.

Explanation: