Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210512 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 / omkar
In any table there can be one and only one primary key
(composite priamry key can have more than 1 column but
together conside one key only) but more than one unique
keys.
Primary key cannot accecpt null value.unique key accecpts
one or more than one null values.
primary key uniquly identifies the table but unique key is
used for uniquly identified of table as it contain one or
more than onee null.
Clustered index is created on
Primary key constraint and non clustered unique indexes is
created on Unique key constraint.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by a database object? Can you list a few of them?
Difference between the “verify” and “feedback” command?
Is rowid unique in oracle?
Can we insert data in view oracle?
What operating systems are supported by oracle database 10g xe?
Explain the use of rows option in exp command.
What is a cognitive schema?
What is java oracle used for?
Can we use bind variables in oracle stored procedure?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is tns entry?
Explain what are the uses of rollback segment?
What do you mean by redo log file mirroring?
Why do we use bulk collect in oracle?
What do database buffers contain?
