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

Explain a data segment?

849


Are truncate and delete commands same? If so why?

848


What are the ways tablespaces can be managed and how do they differ?

1948


How do you find current date and time in oracle?

800


How translate command is different from replace?

753


What is a sub query? Describe its types?

784


How to resolve name conflicts between variables and columns?

805


candidate key is subset of super key but not vice-verse explain

1794


I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

881


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2052


What is a private synonym?

1312


What is the difference between sharding and partitioning?

748


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1849


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2020


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1908