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 is a sub query? What are its various types?
Explain the dml?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What are the ways tablespaces can be managed and how do they differ?
What is procedure overloading in oracle?
How to get a list of all background sessions in the database?
What is execute immediate in oracle?
What is a initialization parameter file in oracle?
How to view the data files in the current database?
How many types of cluster table in Oracle?
How to view all columns in an existing table?
Point out the difference between user tables and data dictionary?
What are the differences between char and varchar2 in oracle?
What is integrity and what is constraint??Explain with example
what is the dual table in oracle?