Answer Posted / vital reddy

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 .

How does oracle handle read consistency?

1093

---

Can a formula column referred to columns in higher group ?

2498

---

What is difference between truncate and delete?

1036

---

How to check the oracle tns settings?

1045

---

Difference between pre-select and pre-query

1101

---

What is an oracle user account?

986

---

How would you go about verifying the network name that the local_listener is currently using?

2045

---

How to get a list of all background sessions in the database?

991

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2129

---

What are internal user account in oracle?

1004

---

List out the components of logical database structure of oracle database.

1034

---

State all possible different index configurations a table can possibly have?

994

---

What is meant by a deadlock situation?

1107

---

What is the difference between $oracle_base and $oracle_home?

1083

---

What is bind variable in oracle 11g?

1037

---