Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 15294 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
How do I spool to a csv formatted file using sqlplus?
State and explain the different types of data models?
What is the difference between Delete, Truncate and Drop in Oracle?
Can a parameter be passed to a cursor?
Why should I use oracle database?
How many file formats are supported to export data?
Describe the types of sub query?
What are the data types in oracle?
What is user managed backup in Oracle?
How do I know if oracle client is installed on windows?
How can windows applications connect to oracle servers?
What is PL/SQL ?
How to create a new tablespace in oracle?
How to pass parameters to procedures?
How to list all user accounts in oracle?
