what are the advantages of primary key over unique+notnull
- 7 Answers
- 20895 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
Can we update views in sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Explain 3 basic parts of a trigger.
What is the starting oracle error number? What is meant by forward declaration in functions?
Which is faster union or join?
how to analyze tables with 'mysqlcheck'? : Sql dba
Is sqlite good enough for production?
How do I count rows in sql query?
What is the difference between left and left outer join?
What are local and global variables and their differences?
Why stored procedure is faster than query?
What is difference between stored procedure and trigger?
What types of commands can be executed in sql*plus?
Define join and name different types of joins?
What are all ddl commands?
