Advertisements
Advertisements
Question
How will you add two columns coll and col2(composite key) as primary key to a relation?
Options
Alter table table_name add primary_key co11, co12;
Alter table table_name add primary key( co11, co12);
Add primary key(co11, co12) alter table table_name;
Alter table table_name add primary_key(co11, co12);
MCQ
Solution
Alter table table_name add primary key( co11, co12);
shaalaa.com
SQL for Data Definition
Is there an error in this question or solution?
