what is the different between unique+not null & primary key,
Answer Posted / giri
unique:it does not allow duplicate values but it allow null values.
not null:It does not allow null values but allow duplicate values.
primary:It does not allow both duplicate and null values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between primary key and unique key? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
What does count (*) mean in sql?
What is a sql*loader control file?
What are basic techniques of indexing?
What is break?
What are crud methods?
How to connect a sql*plus session to an oracle server?
What is informix sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Explain commit, rollback and savepoint.
Write the command to remove all players named sachin from the players table.
Explain spool.
How do I save a stored procedure?
What is rank dense_rank and partition in sql?