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
- 11864 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?
How to assign a table row to a record variable?
How to convert character types to numeric types?
What is null value in oracle?
Explain the use of grant option in imp command.
How to use subqueries in the from clause in oracle?
What is a user role in oracle?
Compare and contrast between sql and sql server and explain its various functions?
Explain do view contain data?
How many types of table in Oracle?
How to define an external table with a text file?
How is it different from a normal table?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is the difference between a hot backup and a cold backup in oracle?
What is the usage of save points in oracle database?
