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
What do you understand by a database object?
What is the use of aggregate functions in oracle?
How to login to the server without an instance?
How to invoke the data pump export utility?
Explain an exception?
What is oracle instant client?
How to concatenate two text values in oracle?
How to rename an index?
What do you mean by a tablespace?
How to delete a column in an existing table in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
definition of cluster and non-clustered index?
How to sort output in descending order in oracle?
What is a initialization parameter file in oracle?
How to rollback the current transaction in oracle?