Answer Posted / subbu

Well the question is

Can a table have two primary keys?

Practically Yes.

But theoritically there will be only 1 primary key with
multiple foriegn keys which acts as a composite keys for the
original primary key. How ever in the create or alter
statements, we need to write primary key only once following
the column names either single or multiple.

By seeing the posts, I believe some of the guys has got
confused with the question & compared it with the SQL create
statements where in Primary Key is written only once & by
which concluding that a table cannot have multiple primary keys.

what are the performance and scalability characteristics of mysql? : Sql dba

997

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

1014

---

What is pragma in sql?

1082

---

What are sql functions? Describe the different types of sql functions?

1143

---

What is PL/SQL Records?

1191

---

Explain what is sql*plus?

1146

---

what is the command line end user interface - mysql? : Sql dba

982

---

What is dml statement?

957

---

What are the types of sql commands?

1103

---

how to install mysql? : Sql dba

1110

---

How to look at the current sql*plus system settings?

1150

---

What is server name sql?

1148

---

What does pl sql developer do?

932

---

What is basic structure of pl sql?

1072

---

What is the maximum number of rows in sql table?

1030

---