You created an ORDERS table with the following description:

You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column. Which statement is true in this scenario?

Question

You created an ORDERS table with the following description:

You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column. Which statement is true in this scenario?

Accepted Answer

B. You can add the primary key constraint even if data exists, provided that there are no duplicate

Answer

A. You cannot add a primary key constraint if data exists in the column

Answer

C. The primary key constraint can be created only a the time of table creation

Answer

D. You cannot have two constraints on one column

You created an ORDERS table with the following description: You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID…

Question

Exhibit

Options

How the community answered

Community Discussion