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
What is ADDM Advisor in Oracle?
How to update values in a table in oracle?
What happens to the indexes if a table is recovered?
How many types of table in Oracle?
What is tns service name?
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 ?
What are set operators?
How to create id with auto_increment on oracle?
How to assign data of the deleted row to variables?
What is tns entry?
How to count duplicated values in a column in oracle?
How to filter out duplications in the returning rows using oracle?
Explain a segment?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
how do u setup a replication site?