Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of primary key over unique+notnull
- 7 Answers
- 22301 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
What is a primary key called that is made up of more than one field?
What happens when a trigger is associated to a view?
What is ttitle and btitle?
what is meant by nl2br()? : Sql dba
What is sql query optimization?
What is the use of desc in sql?
discuss about myisam index statistics collection. : Sql dba
how to convert dates to character strings? : Sql dba
What is a table?
What is native sql query?
What are character functions in sql?
What is the difference between cluster and non-cluster index?
what is the difference between cluster and non cluster index? : Sql dba
What is the purpose of using pl/sql?
what is clause? : Sql dba
