Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 16631 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 are the common oracle dba tasks?
How to load excel data sheet to oracle database
What is max rowid in oracle?
How to rename an index in oracle?
Write a trigger example in oracle?
Explain the use of record option in exp command.
What is the difference between I and G in Oracle?
What is an external table?
Describe varray?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Explain the difference between a procedure and a function?
Can sub procedure/function be called recursively?
How to resolve the ORA-39133 error in Oracle?
What is tns entry?
State any two functions of oracle?
