Difference between primary key and unique key ?

Answer Posted / boomiraj.p

Primary key: Do not allow the
duplicates and null values.
Unique key : Do not accept the
duplicates,but allow null value

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out the types of joins.

834


Can a parameter be passed to a cursor?

798


Explain the use of file option in exp command.

855


What are oracle functions?

759


Does oracle charge for java?

800


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2087


What is connection pooling in oracle?

726


What is the difference between $oracle_base and $oracle_home?

794


What is tns name?

728


Explain how you would restore a database using RMAN to Point in Time?

1871


In which language oracle has been developed?

838


How to install oracle odbc drivers?

829


What is the relation of a user account and a schema?

861


What is an oracle tablespace?

776


How to resolve name conflicts between variables and columns?

779