Can a table have two primary keys?

Answer Posted / damini

No.A table can have only one primary key .if it is having
more than one primary key then we say it as composite
primary key...A composite primarykey is a primary key of 2
or more columns together..A composite primary key is
different from 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 the difference between union and union all command?

555


How do you pronounce sql?

550


What is self-join and what is the requirement of self-join?

634


What is primary key and foreign key with example?

496


What is the use of desc in sql?

496






Can we rename a column in the output of sql query?

543


How do I make sql search faster?

558


What is minus?

547


What is pragma in sql?

622


How is data stored on a disk?

541


Why do we use procedures in pl sql?

518


Can we use rowid as primary key?

546


Does a primary key have to be a number?

522


Show the two pl/sql cursor exceptions.

614


Is natural join same as inner join?

507