yes, a table may have more than 1 primary keys but, of them we only choose

Can a table have two primary keys?

Question Posted / ashwin kumar

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

Answer Posted / ashwin kumar

yes, a table may have more than 1 primary keys but, of them
we only choose 1 column as identifiable column called
primary key. The other columns are called surrogate keys or
candidate key.

Is This Answer Correct ?

25 Yes

43 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we use the cursor's to create the collection in PL/SQL?

1093

What is flag in sql?

1099

Why do we use cursors?

1044

What are the advantages of stored procedure?

1040

Can we create clustered index without primary key?

1000

How do I run a sql trace?

1003

can a stored procedure call itself or recursive stored procedure? : Sql dba

1086

How does one use sql*loader to load images, sound clips and documents? : aql loader

1234

What are literals in sql server?

1259

What is serial sql?

1041

How many types of cursors supported in pl/sql?

1258

How do I partition a table in sql?

1208

Does a join table need a primary key?

1000

define sql insert statement ? : Sql dba

1080

How do you update sql?

1038