Can a table have two primary keys?

Answer Posted / chandu

We can create only one Primary kay in a table but it can
have multiple columns, of them we only choose 1 column as
identifiable column called primary key and the other columns
are called candidate key(s).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rownum in sql?

559


What is trigger in sql? Explain

538


Mention what is the function that is used to transfer a pl/sql table log to a database table?

486


what is a composite primary key ? : Sql dba

583


What is anonymous block in sql?

640






What are the different sql languages?

540


What is consistency?

715


How to rename a column in the output of sql query?

539


What is int identity in sql?

576


How can the performance of a trigger be improved?

590


What are crud methods?

551


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2007


Is pl sql a scripting language?

590


How do you exit in sql?

589


Can two tables have same primary key?

531