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 are the types of partitions in oracle?
How to load excel data sheet to oracle database
How to assign data of the deleted row to variables?
How to rename an index?
How to create a table interactively?
How to define a variable of a specific record type?
What is merge statement used for?
What is transaction control statement and how many types of transaction control statement in Oracle?
How many memory layers are in the oracle shared pool?
How does the on-delete-cascade statement work?
what is normalisation?what are its uses?
How to display employee records who gets more salary than the average salary in the department?
Explain integrity constraint?
What is query image?
Query to retrieve record for a many to many relationship ?