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
- 12452 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 privilege is needed for a user to delete rows from tables in another schema?
How to assign values to data fields in record variables?
how do u setup a replication site?
Is postgres faster than oracle?
How to list all tables in your schema?
What are the varoius components of physical database structure of oracle database?
What to do if the binary spfile is wrong for the default instance?
How will you write a query to get a 5th rank student from a table student_report?
How to turn on or off recycle bin for the instance?
What are the major difference between truncate and delete?
How to define a cusotmer as a supplier in ORACLE R12
What is a read write transaction in oracle?
Can you create a synonym without having a table?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
