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
What is object data modeling?
How to turn on or off recycle bin for the instance?
Can you tell me how to add new column in existing views?how?How is possible?
How to assign query results to variables?
List out the types of joins.
What is Library Cache in Oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is the difference between I and G in Oracle?
What is a nested table and how is it different from a normal table?
Define oracle database
Please explain drop constraint oracle?
What is a nvl function?
How do I spool to a csv formatted file using sqlplus?
How to define an external table with a text file?
When do we use group by clause in a sql query?