If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
- 8 Answers
- 9881 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / prashant t.
No.
It will same for doesn't allow null and duplicate values.
But, Primary key constrained applied Cluster index on that
column and unique key constraint non clustered index on
that column. that is the major differece still be there.
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
How to drop an index in oracle?
Explain rename?
Can we store images in oracle database?
What is Segment Advisor in Oracle?
Why do you create or replace procedures rather that drop and recreate.
What are the differences between primary key and unique key?
How many file formats are supported to export data?
what is the dual table in oracle?
How to use in conditions in oracle?
What does sharding mean?
what are the default admin accounts in Oracle 10g ?
How to define a data field as not null?
How many data types are supported?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to use like conditions in oracle?
