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
- 11868 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
Explain about integrity constraint?
How to delete a column in an existing table in oracle?
How to create a new table in oracle?
Can you assign multiple query result rows to a variable?
What is the difference between truncate & delete command?
How to use values from other tables in update statements using oracle?
What is the difference between a primary key & a unique key?
What is where clause in oracle?
Explain parameter file in oracle.
How to drop a stored function?
How does Oracle guarantee data integrity of data changes?
What is a parameter file in oracle?
What is the difference between sharding and replication?
What is a sub query and what are the different types of subqueries?
Name the three major set of files on disk that compose a database in Oracle?
