Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of primary key over unique+notnull
- 7 Answers
- 22512 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
where are cookies actually stored on the hard disk? : Sql dba
What is a common use of group by in sql?
how to write date and time literals? : Sql dba
What is union?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How does cross join work in sql?
What is difference between sql and mysql?
Explain the difference between drop and truncate commands in sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
How to handle bulk data?
What is not in sql?
What is right join sql?
What is the max nvarchar size?
Why self join is used in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
