If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / bhakti
ya thats true.i.e.,in case of Primary Key we can have
parent to child relationship if that is say foreign key in
another table.In case of unique and not null we cant achive
dis.
But while inserting data into one table both will have no
difference.
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is a sub query and what are the different types of subqueries?
What are the extensions used by oracle reports?
Explain an exception and its types?
Which is faster join or subquery in oracle?
What do you mean by redo log file mirroring?
What happens to the current transaction if the session is killed?
In which language oracle has been developed?
What is recovery manager in Oracle?
Explain the difference between replace() and translate() functions in oracle?
What is the difference between translate and replace in oracle?
Explain alias?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
what is the difference between functional dependecy and multilevel dependency?
How do you find current date and time in oracle?
What is private procedure oracle?