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 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.
Why do we need integrity constraints in a database?
How can we view last record added to a table?
How do we create privileges in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What are the arithmetic operations?
What do you understand by a database object? Can you list a few of them?
Can a parameter be passed to a cursor?
How to create a table in a specific tablespace?
What is a package ? What are the advantages of package ?
What happens to the data files if a tablespace is dropped?
How to store only time; not date and time?
How a tablespace is related to data files?
How to turn on or off recycle bin for the session?
Is rowid unique in oracle?