Difference between primary key and unique key ?

Answer Posted / rubiya george

Primary Key Vs Unique key
1.Each table having 1. contain many UNIQUE KEYS.
only one PRIMARY KEY.
2.Primary key not accepts 2.Unique Key accepts null
null values values

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ADDM Advisor in Oracle?

665


How to update values in a table in oracle?

579


What happens to the indexes if a table is recovered?

579


How many types of table in Oracle?

619


What is tns service name?

624






For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1558


What are set operators?

648


How to create id with auto_increment on oracle?

547


How to assign data of the deleted row to variables?

581


What is tns entry?

625


How to count duplicated values in a column in oracle?

554


How to filter out duplications in the returning rows using oracle?

644


Explain a segment?

621


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4021


how do u setup a replication site?

1502