Difference between primary key and unique key ?
- 77 Answers
- 190985 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 / anand b
Primary Key : Is an identity of a row, Only one primary key per table, No duplicate values allowed, & No NULL values are allowed.
Unique Key : Its values are unique, It can contain any number of NULL values unless combination is going to be unique.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to assign values to variables?
What privilege is needed for a user to create tables in oracle?
What is execute immediate in oracle?
How to assign a table row to a record variable?
Explain the importance of .pll extension in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Point out the difference between user tables and data dictionary?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is a private synonym?
How to use attributes of the implicit cursor in oracle?
What is a named program unit?
Is truncate autocommit in oracle?
How to use "in" parameter properly?
How to revoke create session privilege from a user in oracle?
Can you assign multiple query result rows to a variable?
