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 can get second highest salary in sql?
Why coalesce is used in sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What are all the different normalization?
Is pl sql better than sql?
Where the sql database files are stored?
Explain ttitle and btitle.
what are properties of a transaction? : Sql dba
What is tuple in sql?
Why do we need sharding?
What is scalar function in sql?
What is sql profiler in oracle?
What are the types of optimization?
what is sql server agent? : Sql dba
What is rownum and rowid?