Interested to Buy Any Domain ? << Click Here >> for more details...
If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
- 8 Answers
- 12477 Views
- IBM, I also Faced
- E-Mail Answers
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
What is the best way to do multi-row insert in oracle?
What is SQL Tuning Advisor in Oracle?
Explain the characteristics of oracle dba?
What is an index associated with a constraint?
What is oracle used for?
how to clone 9i Database on to 10g Database.
6. Display the client name and order date for all orders using the traditional method.
What is not equal to in oracle?
What is the purpose of save points in oracle database?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What do you mean by a deadlock?
How to load excel data sheet to oracle database
What are the different types of synonyms?
What is parameterized cursor in oracle?
