Can a table have two primary keys?

Answer Posted / suresh babu

No,The Table should have one primary key.But we can create
single primary key for combination of more columns,which is
called Composite Primary Key.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scalar data type in pl sql?

559


Can we use joins in subquery?

539


What is rename command in sql?

468


how to use regular expression in pattern match conditions? : Sql dba

530


which tcp/ip port does sql server run on? : Sql dba

519






What is the order of sql select?

575


Why do we create views in sql?

562


Differentiate between % rowtype and type record.

735


What is the requirement of self-join?

546


What are conditional predicates?

589


what is meant by urlencode and urldocode? : Sql dba

603


What is cartesian join in sql?

559


Which data dictionary views have the information on the triggers that are available in the database?

756


What are the ways on commenting in a pl/sql code?

513


What is difference between primary and secondary key?

519