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 are the uses of synonyms?
What are joins, explain all types of joins?
Can you create a synonym without having a table?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is the purpose of save points in oracle database?
What is the difference between a primary key & a unique key?
How to use subqueries with the in operator using oracle?
Explain self joins in oracle?
Explain about the analyze command in oracle?
List the various oracle database objects?
What is parameterized cursor in oracle?
How to loop through data rows in the implicit cursor?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Can you drop an index associated with a unique or primary key constraint?