What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?

Answer Posted / allin

The Primarykey Constraint= unique + Not Null constraints.
For the Unique the meaning it self it is telling unique
value. won't accept duplicate values.

Thanks & Regards,
RatnaRao
9833847339

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is columnar storage what is the advantage?

752


What is Virtual Private Database in Oracle?

834


What is an oracle user account?

773


What is a cursor variable?

800


Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2738


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1680


What are the attributes of the cursor?

774


What is the difference between Delete, Truncate and Drop in Oracle?

862


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1804


What is max rowid in oracle?

787


How do we display rows from the table without duplicates?

740


What would you do with an in-doubt distributed transaction?

1728


What are the parameters that we can pass through a stored procedure?

826


How to use attributes of the implicit cursor in oracle?

783


Why is oracle database so popular?

775