Difference between primary key and unique key ?

Answer Posted / avesh upadhyay,iims

are yar
primary key that does not accept null value
and in table only one exist.
but the case of uniue key that accept null value one or more
and many unique key exist in a single table

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an oracle data file?

621


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1708


How to invoke the data pump import utility?

657


List the various oracle database objects?

605


How to install oracle database 10g xe?

575






Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2460


Is the After report trigger fired if the report execution fails ?

2412


What is a directory object?

599


How to use windows user to connect to the server?

536


How to connect the oracle server as sysdba?

640


What is merge in oracle?

574


What is logical backup in oracle?

580


How to see the table columns used in an index?

606


How to use "if" statements on multiple conditions?

729


Explain the difference between sap and oracle?

585