Difference between primary key and unique key ?
Answer Posted / anuradha
The unique column constraints permits multiple entries of
null in the column. these null values are clubbed at top of
column in order they were entered into table. this is
essential difference .
Table have more than 1 unique key which is not possible in
primary key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are nested tables?
How does oracle handle read consistency?
What are the attributes that are found in a cursor?
Please explain oracle data types with examples?
How to retrieve data from an explicit cursor?
Point the difference between translate and replace?
How can windows applications connect to oracle servers?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is program global area (pga) in oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is meant by raw datatype?
What is PL/SQL ?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Please explain joins in oracle?
Describe varray?