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 .

what are bitmap indexes? How does they work?

2181

---

how to join query for one source type is oracle another source type is sql server ?

2375

---

How to convert a date to char in oracle? Give one example.

1000

---

How do I connect to oracle?

974

---

What is materialized view in Oracle?

1042

---

What is instant client oracle?

972

---

Which is faster join or subquery in oracle?

931

---

How can I see all tables in oracle?

949

---

Write a trigger example in oracle?

977

---

What are the advantages of oracle?

960

---

How do you bind variables in oracle?

927

---

How to get a list of all user accounts in the database?

1030

---

How to Truncate Table in Oracle

1089

---

What is the difference between substr and instr?

974

---

Explain about your project and its relation to the current job position you are applying to?

942

---