Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210081 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
List out the types of joins.
Explain joins in oracle?
How to find out what oracle odbc drivers are installed?
Explain what are the type of synonyms?
Why does oracle 9i treat an empty string as null?
interview questions with answer for cts
How can we view last record added to a table?
Where is the export dump file located?
How remove data files before opening a database?
Explain the types of exception?
What is integrity and what is constraint??Explain with example
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Why do you create or replace procedures rather that drop and recreate.
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Can sub procedure/function be called recursively?
