To create a PRIMARY KEY constraint on existing table “EMPLOYEE” on "EMPID" column and currently column does not contain any value , which is the correct SQL syntax from the following

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


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

Discussion Board
what is the difference between hear options 1,3,4

i think both as same

sandhya 02-14-2020 02:29 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement