If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / eshwari
ur question is not clear.
if ur saying that ur giving unique and not null constraints
to the same column then u can make it as primary key.it
internally supports clustered index also.
if ur saying that ur giving unique and not null constraints
to different columns then u cant make them as primary key
individually.
coz primary key means unique + notnull + clustered index
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to use "while" statements in oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is oracle analytical function?
How do I uninstall oracle client from windows?
What are joins, explain all types of joins?
What is the difference between sharding and replication?
How can you merge two tables in oracle?
Where do we use decode and case statements?
What do you know about normalization? Explain in detail?
Explain an index?
What is a table index?
Respected sir, Please send me technical questions related to oracle apps..
Difference between varchar and varchar2 data types?
Is oracle an operator?
can anyody please send me the dump for Oracle 10g certifications for DBA path?