Difference between primary key and unique key ?

Answer Posted / ark chowdary

7. Primary Key doesnt allow the Null Values. where as in
Unique accept the Null values.
One table may have more than one Unique Key Constraint.
But it sholud have only one Primary Key Constraint column.

Is This Answer Correct ?    77 Yes 47 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to start a new transaction in oracle?

587


Is oracle an operator?

532


What is the use of oracle?

549


What privilege is needed for a user to delete rows from tables in another schema?

562


What is set verify off in oracle?

577






What do you mean by redo log file mirroring?

555


IS it possible to built the oracle database without setting the kernal parameters?

1759


How to list all user accounts in oracle?

608


How to use attributes of the implicit cursor in oracle?

560


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1605


What are advantages of dateset in datastage?

1744


various types of hints and their usage

2131


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1562


How to establish administrator authentication to the server?

558


What is an oracle user account?

578