Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of primary key over unique+notnull
- 7 Answers
- 22500 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
how to show all tables with 'mysql'? : Sql dba
How to run pl sql program in mysql?
What is rownum in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is embedded sql with example?
What is bind reference and how can it be created?
What is input buffer in sql*plus?
Can we use the cursor's to create the collection in PL/SQL?
What is a pl/sql block?
How many columns should be in an index?
How do I find duplicates in a single column in sql?
What are different joins used in sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the use of non clustered index?
Explain isolation levels. : Transact sql
