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 does the hierarchical profiler does?
Which version of sql do I have?
How to prepare for oracle pl sql certification?
Why do we use subquery?
Can we create table inside stored procedure?
Explain cursor types?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Is primary key a clustered index?
What are the steps for performance tuning.
Are dml statements autocommit?
What are the different types of database management systems?
What is a record in pl/sql?
What pl/sql package consists of?
How exception handling is done in advance pl/sql?
how many groups of data types? : Sql dba