Answer Posted / koteswara rao.k

suppose you have landline and through the landline you have
taken net connection .
so at the end of the month you will get two bills on the
landline which is subject to one means

primary key is landline which is parent one ( customer
code available)
broadband and landline ( two bills generation ) are the
unique keys called child keys .(contract ids available)
so in this scenario contract ids can be null but cannot be
duplicate .
One more You cannot remove the primary key until and unless
remove the branched ones.

I have good knowledge on GSM /broadband/pstn technologies .
Any wrong ping with me pls koteswara.9.rao@gmail.com

How to use existing values in update statements using oracle?

1074

---

How to use "in out" parameter properly?

1056

---

what is a Nested Loop join?

2123

---

What is an oracle and why it is used?

1157

---

What are the data types in oracle?

1047

---

What is the difference between substr and instr?

1042

---

How to create id with auto_increment on oracle?

995

---

What is a trigger and what are its types?

1240

---

What is meant by a deadlock situation?

1116

---

Can we call procedure inside function in oracle?

1103

---

What is a schema in oracle?

1026

---

Explain the use of record length option in exp command.

1072

---

Can you tell me how to add new column in existing views?how?How is possible?

1452

---

How view is different from a table?

1045

---

How to speed up webrick?

1081

---