Difference between primary key and unique key ?
Answer Posted / kundn
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 ? | 14 Yes | 17 No |
Post New Answer View All Answers
What is a system tablespace and when it is created?
How to list all tables in your schema?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to convert a date to char in oracle? Give one example.
What is sharded cluster?
What privilege is needed for a user to insert rows to tables in another schema?
Explain do view contain data?
What are the system predefined user roles?
What is Java Pool in Oracle?
How to use "in out" parameter properly?
What are the different oracle database objects?
How to increment dates by 1 in oracle?
What is SQL access advisor in Oracle?
How to create an oracle testing table?
How many types of tables supported by oracle?