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
- 12167 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 the use of file option in exp command.
What is a cognitive schema?
what is the difference between data migration and production migration.
Why does oracle 9i treat an empty string as null?
What is analyze command used for?
How can I introduce multiple conditions in like operator?
What to do if the binary spfile is wrong for the default instance?
How to get a list of all user accounts in the database?
What is a nvl function?
What do you mean by cdb and pdb in oracle 12c?
How can Oracle users be audited?
How to write text literals in oracle?
What is different types of joins?
What is the difference between alert log file and tarce file ?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
