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
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What are the differences between interval year to month and interval day to second?
How to generate query output in html format?
How to load data through external tables?
What are the differences between char and varchar2 in oracle?
How to divide query output into groups in oracle?
Give the advantages and disadvantages of clusters.
What privilege is needed for a user to delete rows from tables in another schema?
What is a read write transaction in oracle?
What are the uses of a database trigger?
Why do you create or replace procedures rather that drop and recreate.
Point the difference between translate and replace?
What is data type in oracle?
How to unlock the sample user account in oracle?
How to load data from external tables to regular tables?