Answer Posted / dan

Kumar Navdeep Shanker

I have created the table provided and it works well.
You said that is possible to have two primary key, I am
sorry I have to disagree with you and all who said yes.

Let me explain using your table

cno balance cname
1 2 w
2 2 x
1 3 r
primary key no two tuple have the same value

what you are providing is a composite key

Thus, we can have more than one key in a table that the
compinaition of the keys are unique

BUT we have only one primary key that means it is unique

Please correct me if i am wrong

What is an implicit commit?

1038

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1246

---

How do you modify a trigger?

914

---

What is the purpose of a sql?

962

---

What is the cause of mutating table error and how can we solve it?

1036

---

What is a relationship and what are they?

1128

---

What is sql rowcount?

988

---

Which join is like an inner join?

1012

---

What is trigger in sql and its types?

1042

---

How to get unique records from a table?

942

---

What are the different tcl commands in sql?

1152

---

Does sql view stored data?

937

---

Can instead of triggers be used to fire once for each statement on a view?

950

---

Why do we use cursors?

976

---

what are the advantages of sql ? : Sql dba

1042

---