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
What privilege is needed for a user to connect to oracle server?
What are the differences between primary key and unique key?
what is port in oracle? how is it related to database application.
Compare and contrast between sql and sql server and explain its various functions?
How to convert a string to a date in oracle database?
What is a cursor in oracle?
What is oracle analytical function?
How can I see all tables in oracle?
How to use subqueries with the exists operator in oracle?
How to insert multiple rows with one insert statement in oracle?
What are the different types of modules in oracle forms?
How to filter out duplications in the returning rows using oracle?
How to do a full database export?
What do you mean by merge in oracle and how can we merge two tables?
Explain the use of tables option in exp command.