Difference between primary key and unique key ?
Answer Posted / himanshu porwal
Primary key does not allow null values whereas in UNIQUE constraint we can have 1 null value means for that column one null value is allowed.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How can you use check constraints for self referential integrity?
How do we get field detail of a table?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Give the different types of rollback segments.
does the query needs a hint to access a materialized view?
Explain mutating triggers.
What is the difference between Delete, Truncate and Drop in Oracle?
How many categories of data types in oracle?
What is translate in oracle?
How to write an inner join with the where clause 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.
Can sub procedure/function be called recursively?
What is a dead lock in oracle?
What are the oracle differences between nvl and coalesce
How to execute the package in oracle?