Difference between primary key and unique key ?
- 77 Answers
- 197813 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 / sandhya
Primary Key cannot contain null values
Each table has one and only one Primary Key
Primary Key is used to reference as Foreign key while
performing table joins
Clustered index is created on Primary Key
Unique Key can contain null value
A table can have any numberof unique keys
Non-clustered index is created on unique key columns
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the logical operations?
Explain the function of optimizer in oracle?
What is varray?
What is merge statement used for?
What is truncate oracle?
What is an oracle recycle bin?
What privilege is needed for a user to create views in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is the recommended interval at which to run statspack snapshots, and why?
How to use "for" statements in oracle?
What is the use of file param in imp command?
What is a data dictionary and how can it be created?
How to call a stored function in oracle?
How to view the data files in the current database?
