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.

How can you select unique records from a table?

995

---

Write an sql query to select all records from the table?

970

---

How do you write a subquery?

968

---

what is the use of set statement in tsql? : Transact sql

945

---

Explain the insert into statements in sql?

939

---

How to display the records between two range in Oracle SQL Plus?

1101

---

What are the types of join and explain each?

989

---

What is data control language (dcl)?

1047

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

957

---

Why we use cross join?

892

---

What is sql and its types?

1114

---

Which is faster joins or subqueries?

931

---

does sql support programming? : Sql dba

993

---

what is meant by urlencode and urldocode? : Sql dba

1092

---

What are properties of the transaction?

958

---