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
- 11948 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sujith
no it is not.......... you may have some other columns which
have not null and unique constraints on it..... the thing is
that you should explicitly choose which one should be
treated as primary key so that clustered index can be put on
it, and non clustered on others where needed.........
foreign key may be used to refer to unique constraint
column, but while dropping you may loose relative unique
constraint also.. where as in case of primary referred by
foreign, will not allow so to happen............
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain view?
What is an anonymous block?
What do you mean by redo log file mirroring?
What is Segment Advisor in Oracle?
What is difference between cartesian join and cross join?
Why does oracle 9i treat an empty string as null?
Which environment variables are absolutely critical in order to run the OUI?
20. Using a set operator, display the client number of all clients who have never placed an order.
What are set operators?
What is an oracle data file?
How much memory your 10g xe server is using?
What is catalog in Oracle?
Explain a data segment?
Explain rename?
How to rename an existing table?
