Difference between primary key and unique key ?
Answer Posted / anand b
Primary Key : Is an identity of a row, Only one primary key per table, No duplicate values allowed, & No NULL values are allowed.
Unique Key : Its values are unique, It can contain any number of NULL values unless combination is going to be unique.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is a user account in oracle?
What do you mean by cdb and pdb in oracle 12c?
Can I create users through internet explorer in oracle 10g?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to set up autotrace for a user account?
What is the order of defining local variables and sub procedures/functions?
Define oracle database
Are truncate and delete commands same? If so why?
Differentiate between translate and replace?
How to change program global area (pga) in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is a snapshot log?
how to handle exceptions in post production
How much memory your 10g xe server is using?
Where is the export dump file located?