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
- 12210 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
What do you mean by merge in oracle and how can we merge two tables?
Difference between inner join vs where ?
How does oracle handle read consistency?
What is a data lock in oracle?
How to write numeric literals in oracle?
What are the uses of Database Trigger ?
What is the relation of a user account and a schema in oracle?
How to use like conditions in oracle?
Can we protect our pl/sql source code?
how to join query for one source type is oracle another source type is sql server ?
What are the attributes that are found in a cursor?
When do I need to use a semicolon vs a slash in oracle sql?
What types of joins are used in writing subqueries?
material view and view disadvantages?
Explain overloading. Can functions be overloaded?
