Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
- 3 Answers
- 7205 Views
- I also Faced
- E-Mail Answers
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 Virtual Private Database in Oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to create a new user account in oracle?
Is oracle a relational database?
What are the types of partitions in oracle?
What is the difference between postgresql and oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Explain the use of consistent option in exp command.
What is tns name?
What are the attributes of the cursor?
Explain an extent?
Explain how you would restore a database using RMAN to Point in Time?
What is merge statement used for?
how to do daily transactions with out sql* loader control file regesterd in apps?
what is Single Byte Overhead...?
