Difference between primary key and unique key ?
- 77 Answers
- 190982 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 / mohammad ali
-The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values.
-We can declare only one primary key in a table
but a table can have multiple unique key
-Clustered index is created on Primary key constraint and
non clustered unique indexes is created on Unique key constraint.
-Primary key columns automatically become NOT NULL (unique
keys can contain nulls).
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How to create a new user account in oracle?
What are the built-in functions used for sending Parameters to forms ?
What is bulk load in oracle?
Explain the use of parfile option in exp command.
Can we create database in oracle using command line ?
Explain oracle’s server parameter file.
How to connect to a local oracle 10g xe server?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is an oracle user account?
How can I introduce multiple conditions in like operator?
Explain the use of record option in exp command.
What is instant client oracle?
What are the attributes of the cursor?
What is the parameter mode that can be passed to a procedure?
