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
How to write date and time literals in oracle?
How to list all tables in your schema?
What is different types of joins?
How can we force the database to use the user specified rollback segment?
What is difference between cartesian join and cross join?
How to convert dates to characters in oracle?
How to delete all rows a table in oracle?
What is logical backup in oracle?
How to export your own schema?
How to store pictures on to the database?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What are internal user account in oracle?
What is oracle sid?
What is the difference between 10g OEM and 11g OEM?
How to display row numbers with the records?