what is the different between unique+not null & primary key,
Answer Posted / mohan babu
A unique key is nothing but it does not allow any
duplicateds but allows nullvalues
A primary key is nothing but it does not allow duplicates
as well as Null values i.e Not Nulls
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Can we group by two columns in sql?
Why do we use cursors?
how to use like conditions? : Sql dba
Where is sql database stored?
What is foreign key in sql with example?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is cross join example?
What is sql comments?
what are the authentication modes in sql server? : Sql dba
Which is better trigger or stored procedure?
How to load data with sql*loader?
What is a null value?
How do I count rows in sql query?
What does over partition by mean in sql?
What are the topics in pl sql?