What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
Answer Posted / naren
When ever you create a primary key constraint on perticular
column in a table it creates clustered index by default,
it cannot allow null values and a table having only one
primary key constraint. But in the case of Unique Key
constraint, it allow only one null value, it creates non-
clustered index by default and a table having multiple
unique key constraints.
Regards
Naren Krishna
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
State and explain about oracle instance?
What is a nested table?
What is oracle update statement with inner join ?
Explain overloading. Can functions be overloaded?
How to invoke the data pump export utility?
What is oracle rowcount?
How to invoke the data pump import utility?
How to create an initialization parameter file?
How do we represent comments in oracle?
What are a query and state the different types of queries and their uses?
What is the quickest way to export a table to a flat file?
What language does oracle use?
What is where clause in oracle?
How do we create privileges in oracle?