Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212357 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
How to create lov dynamically at runtime & attach to text field?
Is there a combination of "like" and "in" in sql?
What are the restrictions on external table columns?
How do you bind variables in oracle?
What is a tns file?
what are archived logs?
What is the Tune Query
how the indexes are stored in the Oracle Database?
How many memory layers are in the oracle shared pool?
Explain the importance of .pll extension in oracle?
What is oracle rownum?
How to rebuild an index in oracle?
What is open database communication (odbc) in oracle?
How to manage transaction isolation level?
How to use select statement to count the number of rows in oracle?
