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

How to run create database statement again?

844


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

858


What is system tablespace?

872


Can we create trigger on materialized view in oracle?

780


What are the arithmetic operations?

863


Name the three major set of files on disk that compose a database in Oracle?

870


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1834


How to empty your oracle recycle bin?

805


What is memory advisor in Oracle?

845


How to convert times to characters in oracle?

825


Explain user account with reference to oracle.

784


How to check your oracle database 10g xe installation?

768


Explain about your project and its relation to the current job position you are applying to?

795


How to delete a user account in oracle?

769


Explain the use of consistent option in exp command.

766