If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
- 8 Answers
- 9832 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 is the difference between a primary key & a unique key?
What is the difference between PFILE and SPFILE in Oracle?
Explain cascading triggers.
List the parts of a database trigger.
How many file formats are supported to export data?
How different is ms access and oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Can we use bind variables in oracle stored procedure?
Can we create database in oracle using command line ?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Explain the use of compress option in exp command.
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How can we view last record added to a table?
How do I start tns listener?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
