If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / dibya tara shakya
It will same but in case of primary key we can create the
master child relationship with other child table as foreign
key but in case of unique and not null we cannot.
another major difference is that Primary key constraint
applied Cluster index on that
column and unique key constraint non clustered index on
that column.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to apply filtering criteria at group level in oracle?
Explain the use of grant option in imp command.
What are the different windows events activated at runtime ?
How to start a specific oracle instance?
Why is oracle so popular?
How to invoke the original export import utilities?
How can we force the database to use the user specified rollback segment?
What to do if the startbd.bat failed to start the xe instance?
What is the usage of control file in oracle?
How can we delete duplicate rows in a table?
What is oracle database 10g express edition?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to drop an index?
Explain database link?
What do you mean by a deadlock?