Difference between primary key and unique key ?
Answer Posted / sikander
Primary key does not allow null value but unique key allows
null value. suppose tableA two column : columnB & columnC .
where coulmnB is primary key & columnC is unique key.
If we insert null value in columnB.It will not accept
columnB but columnC
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is connection pool in oracle?
How do I learn what codesets are available in oracle?
What is Virtual Private Database in Oracle?
How to convert character types to numeric types?
How to export data to a csv file?
Why use resource manager in Oracle?
How to empty your oracle recycle bin?
How to connect ms access to oracle servers?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is a package ? What are the advantages of package ?
Name the three major set of files on disk that compose a database in Oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
what is IDE,DMV in sql server?
Give the various exception types.
How to put more than 1000 values into an oracle in clause?