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
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to use windows user to connect to the server?
When system tablespace is created?
List out the components of logical database structure of oracle database.
What are operators in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
How to estimate disk space needed for an export job?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Please explain drop constraint oracle?
Explain what are the type of synonyms?
Explain oracle insert into command?
What is hash cluster in oracle?
How do we get field details of a table?
How can windows applications connect to oracle servers?
What is a cursor in oracle?