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 does count (*) do in sql?

984

---

What is union?

1137

---

What is primary and foreign key?

1046

---

what are tables and fields? : Sql dba

1031

---

Which operator is used in query for pattern matching?

1072

---

What is update query?

962

---

What is sql*loader and what is it used for?

1121

---

what is clause? : Sql dba

1052

---

What are commit, rollback, and savepoint?

967

---

What is oracle pl sql developer?

964

---

What are the different types of constraints?

1155

---

What is rownum and rowid?

1019

---

Can you join views in sql?

939

---

Is oracle and sql same?

993

---

What do you mean by stored procedures? How do we use it?

983

---