what is unique key?

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

Is This Answer Correct ?    10 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the numeric comparison operations?

633


What is a data dictionary and how can it be created?

615


Explain what are the uses of rollback segment?

588


Explain do view contain data?

585


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1744






What is raw datatype in oracle?

583


Explain alias?

715


What are the execution control statements in oracle?

606


Is oracle a relational database?

523


How to work with data objects interactively?

556


How to change user password in oracle?

605


Can we store images in oracle database?

554


Which environment variables are absolutely critical in order to run the OUI?

1659


Explain self joins in oracle?

564


Explain a private synonyms?

637