Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210087 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
What are a query and state the different types of queries and their uses?
How to experiment a data lock in oracle?
How to name query output columns in oracle?
What is tns entry?
What do you mean by group by clause?
In what script is snap$ created? In what script is the scott/tiger schema created?
what is port in oracle? how is it related to database application.
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??
Explain the types of exception?
What is Undo Management Advisor in Oracle?
Explain overloading. Can functions be overloaded?
What are the limitations of check constraint?
defination of bitmap index
How to connect to a remote server?
query optmization techniques and quwry analyser+projects+ppts
