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

What is partitioned table in Oracle?

1107

---

What is system tablespace?

1044

---

How can Oracle users be audited?

1056

---

How to add a new column to an existing table with a default value?

967

---

Is there a combination of "like" and "in" in sql?

1007

---

what is the difference between functional dependecy and multilevel dependency?

2422

---

Can objects of the same schema reside in different tablespace?

1002

---

What is a user account in oracle?

1069

---

How do we get field details of a table?

936

---

What is a procedure in oracle?

1076

---

What is the relationship among database, tablespace and data file?

929

---

How to view the data files in the current database?

1045

---

How to check your oracle database 10g xe installation?

927

---

Why does oracle 9i treat an empty string as null?

979

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4482

---