We can create only one Primary kay in a table but it can have multiple col

Can a table have two primary keys?

Question Posted / chandu

44 Answers
96826 Views
HCL, MetaCube, I also Faced
E-Mail Answers

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 crud diagram?

952

How many functions are there in sql?

1031

What is record type in pl sql?

998

How many sql are there?

1003

What is the use of %rowtype?

1041

How to prepare for oracle pl sql certification?

1069

what are null values? : Sql dba

959

What is sql in java?

1090

What is a pl/sql block?

1234

What are dml commands?

1022

Is keyword pl sql?

1010

What is pl sql quora?

1173

What are field types?

1008

How to revise and re-run the last sql command?

1163

How do you modify a column in sql?

1000