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.

Are sql database names case sensitive?

934

---

Define implicit and explicit cursors.

1071

---

What can I use instead of union in sql?

902

---

what is row? : Sql dba

1162

---

What is the basic structure of an sql?

1031

---

what is 'mysqlshow'? : Sql dba

973

---

Is join and inner join the same?

940

---

What is the difference between alter trigger and drop trigger statements?

1041

---

What is optimistic concurrency control? : Transact sql

939

---

What is integrity in sql?

979

---

What are database links used for?

988

---

what are the advantages a stored procedure? : Sql dba

923

---

How delete a row in sql?

921

---

What is package in pl sql with an examples?

967

---

What are the datatypes available in pl/sql ?

1042

---