Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 15355 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / chandrika
if we define unique key column to not null
then first attempt it not allow to insert null value in
column but after inserting once we can edit its value to
null even if it is not null ( means its allow null)
if we assign primary key then its not allow (in every
situation it not allow null and duplication)
that is main difference between unique key and primery key
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What is control file used for?
How to call a stored function with parameters?
Explain about functional dependency and its relation with table design?
What is difference between truncate and delete?
What is the difference between Delete, Truncate and Drop in Oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is an index associated with a constraint?
What is the difference between sharding and replication?
How to convert characters to dates in oracle?
How to define a cusotmer as a supplier in ORACLE R12
What is oracle data type?
How to start instance with a minimal initialization parameter file?
What are the differences between blob and clob in oracle?
What are operators in oracle?
How to assign values to data fields in record variables?
