Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210448 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 / dinesh
Primary Key:
It wont accept NULL values.
It wont accept Duplication.
Unique Key:
It accepts NULL values.
Foreign Key:
It accepts NULL values.
It accepts Duplication.
Main point is, A Foreign key denotes a Primary key in the another table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the roles of dba?
How to use attributes of the implicit cursor in oracle?
6. Display the client name and order date for all orders using the traditional method.
Is rowid unique in oracle?
how the indexes are stored in the Oracle Database?
How can we view last record added to a table?
What are the varoius components of physical database structure of oracle database?
How to check your oracle database 10g xe installation?
How to count groups returned with the group by clause in oracle?
What are the uses of Database Trigger ?
What is BBED in Oracle?
What are dml statements in oracle?
what is Single Byte Overhead...?
Can you assign multiple query result rows to a variable?
