what are the advantages of primary key over unique+notnull
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 to create a new table by selecting rows from another table in mysql? : Sql dba
What are the advantages of pl sql over sql?
What is view explain with example?
What is a parameter query?
What are the parameter modes supported by pl/sql?
what are different types of keys in sql?
Should I use mbr or gpt?
Can we create a trigger on view?
Who is the owner of mysql database?
What is sqlerrm?
Which normal form is best?
How does cross join work in sql?
What is clustered index in sql?
What is a database event trigger?
How to fetch alternate records from a table?