what is unique key?

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 .

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1869


Why do we need integrity constraints in a database?

588


How can we view last record added to a table?

602


How do we create privileges in oracle?

588


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1695






What are the arithmetic operations?

590


What do you understand by a database object? Can you list a few of them?

610


Can a parameter be passed to a cursor?

600


How to create a table in a specific tablespace?

543


What is a package ? What are the advantages of package ?

605


What happens to the data files if a tablespace is dropped?

578


How to store only time; not date and time?

557


How a tablespace is related to data files?

583


How to turn on or off recycle bin for the session?

610


Is rowid unique in oracle?

530