Difference between primary key and unique key ?
Answer Posted / vitthal parkar
Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns
| Is This Answer Correct ? | 35 Yes | 58 No |
Post New Answer View All Answers
Explain temporal data types in oracle
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is the string concatenation operator in oracle?
What are the differences between interval year to month and interval day to second?
How to see free space of each tablespace?
How do I uninstall oracle 11g?
can u plz provide me oca sql dumps please i need them
What are the different types of failures that occur in Oracle database?
How to select an oracle system id (sid)?
State the various uses of dbcc command?
How to drop a tablespace?
why dont we assign not null constraint as table level constraint.
Explain enable novalidate constraint.
How to declare a local variable?
Explain the difference between a procedure and a function?