what are the advantages of primary key over unique+notnull
- 7 Answers
- 20963 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
What is anonymous block in sql?
Is hadoop a nosql?
What are the two virtual tables available at the time of database trigger execution?
How can I get the number of records affected by a stored procedure?
How do I restart sql?
What do you understand by pl/sql packages?
What is gpt format?
What is view? Can we update view
Is it possible to read/write files to-and-from PL/SQL?
How you improve the performance of sql*loader? : aql loader
What is a schema sql?
what are the different functions in sorting an array? : Sql dba
What is the difference between function, procedure and package in pl/sql?
Explain sql data types?
What are the operators in sql?
