Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207460 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / mohan singh
Primary key contain non repetitive value and not null
value,and primary key is created on clustered index.In the
table their should be one primary key column.
Unique key contain non repetitive value but can contain
only one null value in the column.And unique key is created
on non clustered index.
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
How to create an oracle testing table?
What is coalesce function?
Explain rename?
How to write date and time interval literals in oracle?
What is instant client oracle?
How to convert a string to a date in oracle database?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is an oracle transaction?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain the use of owner option in exp command.
What is transport network substrate (tns) in oracle?
Difference between inner join vs where ?
How will you differentiate between varchar & varchar2?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Can we write insert statement in function in oracle?
