Which is the correct SQL syntax from the following to create a PRIMARY KEY constraint on existing table EMPLOYEE on " EMPID " column and currently column does not contain any value?

Question

TuteeHUB · Accepted Answer

Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key, (EMPID);

TuteeHUB · Answer

Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key, EMPID;

TuteeHUB · Answer

Update table EMPLOYEE Add Constraint PK - EMPID Primary Key (EMPID);

TuteeHUB · Answer

Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key (EMPID);

1.	Which is the correct SQL syntax from the following to create a PRIMARY KEY constraint on existing table EMPLOYEE on " EMPID " column and currently column does not contain any value?
A.	Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key, EMPID;
B.	Update table EMPLOYEE Add Constraint PK - EMPID Primary Key (EMPID);
C.	Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key (EMPID);
D.	Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key, (EMPID);
Answer» D. Alter table EMPLOYEE Add Constraint PK - EMPID Primary Key, (EMPID);

Which is the correct SQL syntax from the following to create a PRIMARY KEY constraint on existing table EMPLOYEE on " EMPID " column and currently column does not contain any value?

Discussion

No Comment Found

Related MCQs

Reply to Comment