Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 15362 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 differences between char and nchar in oracle?
What is oracle open database communication (odbc)?
Explain joins in oracle?
How do we get field details of a table?
How to use regular expression in pattern match conditions in oracle?
is there a tool to trace queries, like profiler for sql server?
How to define and use table alias names in oracle?
Explain temporal data types in oracle
When system tablespace is created?
What is background process in Oracle?
What is integrity and what is constraint??Explain with example
How to unlock the sample user account in oracle?
How to use existing values in update statements using oracle?
What is enter substitution variable in oracle?
What is Virtual Private Database in Oracle?
