Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210329 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 / yjreddy
primary key doesnt allow duplicates and null values
unique key allows null value only once
and more over
when you applying primary key by default clustered index is created on that table
when u applying unique key non clustered index is created on that table.
so primary key can be allowed only once(1) and unique u can apply more
than one on a single table(249)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Please explain joins in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is oracle rownum?
what is meant by magic query
How to define a data field as not null?
Why does Oracle not permit the use of PCTUSED with indexes?
Explain the use of online redo log files in oracle.
How to lock and unlock a user account in oracle?
Explain a private synonyms?
 How to use an oracle sequence generator in a mapping?
State the various uses of dbcc command?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is a synonym? What are its various types?
What is object data modeling?
