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
How can I create database in oracle?
Can we connect to ORACLE db using Windows Authentication?
What are the ansi data types supported in oracle?
What is an index associated with a constraint?
What is columnar storage what is the advantage?
How to write a query with a left outer join in oracle?
Is oracle an operator?
What to do if dba lost the system password?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Difference between inner join vs where ?
How to bring a tablespace offline?
How to install oracle odbc drivers?
How to count groups returned with the group by clause in oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
what is difference between sql plus and sql*plus? (not sql and sql plus).