If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
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
What are oracle functions?
What is the oracle implicit cursor?
Where do you use decode and case statements?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is an Oracle index?
Explain the use of analyse option in exp command.
What is max rowid in oracle?
please explain.. DB architecture ...
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to unlock the sample user account in oracle?
How to upsert (update or insert into a table)?
How to invoke the original export import utilities?
Is insert autocommit in oracle?
How do we get field details of a table?
What is a lookup table in oracle?