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
- 11924 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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Explain a synonym?
What are the different types of trigger and explain its various uses and functions?
How to get execution path reports on query statements?
What is the dynamic sql in oracle?
How to define an explicit cursor in oracle?
what is the use of system.effective.date variable in oracle?
How to use windows user to connect to the server?
Explain what are clusters?
What is oracle server autotrace in oracle?
What are the uses of synonyms?
What is oracle latest version?
what is the scripts in data base?
How to set a transaction to be read only in oracle?
Explain the truncate in oracle?
