Difference between primary key and unique key ?
- 77 Answers
- 190732 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 to define a data source name (dsn) in odbc manager?
What is connection pool in oracle?
How to use an explicit cursor without open statements?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to connect asp pages to oracle servers?
What is blob data type in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is the relation of a user account and a schema in oracle?
List the parts of a database trigger.
What are the types of trigger in oracle?
What is the use of oracle?
Explain oracle’s system global area (sga).
How to define an explicit cursor in oracle?
What is rowid and rownum in oracle?
