Difference between primary key and unique key ?

Answer Posted / umapathy.r

The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values assume that t3 is a table with two
columns t1 having primary key constraint and t2 having
unique constraint if u try to insert null into t2 it will
accept that values whereas column t1 will not accept null

Is This Answer Correct ?    1164 Yes 121 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use bulk collect in oracle?

834


How to display employee records who gets more salary than the average salary in the department?

839


How to count duplicated values in a column in oracle?

804


What are the arithmetic operations?

865


Is oracle a relational database?

728


In oracle there is column command, how will you explain that?

756


What is the difference between substr and instr?

747


What to do if dba lost the system password?

864


Explain alias?

930


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

1930


What is truncate oracle?

751


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2158


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1747


Explain an exception?

759


What is a private synonym?

1337