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
- 12220 Views
- IBM, I also Faced
- E-Mail Answers
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
What is a lookup table in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to retrieve data from an explicit cursor?
What are the major difference between truncate and delete?
what is the difference between functional dependecy and multilevel dependency?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to assign data of the deleted row to variables?
Where are the settings stored for each instance in oracle?
What is a parameter file in oracle?
How to write an inner join with the where clause in oracle?
What is proxy method?
Give the different types of rollback segments.
What is a nvl function?
Why does Oracle not permit the use of PCTUSED with indexes?
