Difference between primary key and unique key ?
- 77 Answers
- 198512 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 / pralhad
Each table having only one PRIMARY KEY.And my contain many
UNIQUE KEYS.
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
BOTH keys will not contain repeated value.
BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 63 Yes | 47 No |
Post New Answer View All Answers
What is rich query?
What are the data types in oracle?
What are the different oracle database objects?
what are steps for interface? where is exchange rate defined in which table?
How to run create database statement again?
What happens to the current transaction if the session is ended?
What do you understand by a database object? Can you list a few of them?
How to retrieve data from an explicit cursor?
What do you mean by redo log file mirroring?
What is the usage of control file in oracle?
How to shutdown your 10g xe server?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to specify default values in insert statement using oracle?
How to write a query with an inner join in oracle?
What is the difference between $oracle_base and $oracle_home?
