Answer Posted / uhaish

Yes and it can and the number of primary keys in a single
table is not limited and can be 3,4, unlimited .The concept
is imagine 2 primary keys cols in a table as one primary
key col .
which means if you have two cols A and B both are primary
key by defination then..
AB
00
01
02
12
21
21
22

,see individually a primary key col is not anymore unique
but as hole its unique no other row in a table can have the
same combination of these two primary keys i.e '02' cannot
be repeated .

What is a record in a database?

1071

---

what is an extent ? : Sql dba

1109

---

Explain clause in sql?

1036

---

What is cartesian join in sql?

1139

---

What is query syntax?

980

---

Why do we need a foreign key?

1108

---

What is trigger types of trigger?

1078

---

What are stuff and replace function?

1091

---

What is a table partition?

1147

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1212

---

What is sql*loader?

1201

---

How bulk collect improves performance?

1014

---

What is a primary key example?

969

---

How do you select unique values in sql?

1007

---

Can we use commit inside a trigger?

1100

---