Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of primary key over unique+notnull
- 7 Answers
- 22192 Views
- Consultancy, LGS, Oracle, I also Faced
- E-Mail Answers
Answer Posted / shilpa.oracle
Primary key accepts only unique values and does not allow
null values.
Unique key accepts unique values and allows null values.
not null constraint allows duplicate values and doesnt allow
null values.
When a primary key constraint or unique key constraint is
created by default index is created on the columns with
these constraints.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
How do I create a memory optimized filegroup?
How do you break a loop in pl sql?
What is the use of partition by in sql?
What is the difference between sql and mysql?
What is gpt format?
What is bulk compiling in pl/sql.?
Which is faster truncate or drop?
Is oracle and sql same?
How much does sqlite cost?
What is the difference between rollback and rollback to statements?
what are the different index configurations a table can have? : Sql dba
Is null operator in sql?
What are the types of join and explain each?
What is the importance of sqlcode and sqlerrm?
What is the best free sql database?
