what are the advantages of primary key over unique+notnull
Answer Posted / tulsi
Primary key will avoid duplicate and null values in a table
which the combination of unique+not null will do.But the
advantage is,if a table has primary key we can create
relation to child tables.
Is This Answer Correct ? | 28 Yes | 13 No |
Post New Answer View All Answers
What is a join?
How many types of triggers are there in pl sql?
what is a composite key ? : Sql dba
What is the difference between pl and sql?
Define tables and fields in a database
What are the differences between implicit and explicit cursors?
Can we use pl sql in mysql?
What is cartesian join in sql?
What is auto increment in sql?
What is sql procedures and functions?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is the difference between truncate and drop statements?
Why is pl sql used?
What are the different type of joins in sql?
What is trigger in pl sql?