Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of primary key over unique+notnull
- 7 Answers
- 22513 Views
- Consultancy, LGS, Oracle, I also Faced
- E-Mail Answers
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
Can a key be both primary and foreign?
How do I truncate a sql log file?
How will you distinguish a global variable with a local variable in pl/sql?
What is the life of an sql statement?
How do you update sql?
what is query cache in mysql? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are sql data types?
Explain the methods used to protect source code of pl/sql.
Why do we use set serveroutput on?
Write a sql query to convert all character to uppercase after hypen.
What are database links used for?
How to disable a trigger name update_salary?
Define select, insert, create, delete, update, drop keywords
The in operator may be used if you know the exact value you want to return for at least one of the columns.
