When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?
Answers were Sorted based on User's Feedback
Answer / thanga prabu.n
Unique Key creates Non-Cluster index in default,
But in Primary Key creates Cluster index in default
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / swapna
The concept of adding an unique key and not null constraint
to a column as well as adding as unique index to it , you
will assume to get the benefits of adding an primary key
to that column.
But use it for the purpose of referential integrity will
not allow to do so.
That's what PK is so useful. You will use it for
normalization purpose.
Is This Answer Correct ? | 12 Yes | 6 No |
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
How to run sql commands in sql*plus?
Why do we go for stored procedures?
What are the different schemas objects that can be created using pl/sql?
What is asqueryable?
What is trigger in pl sql?
What is a constraint?
What is write ahead logging in sql server?
diff b/w sub query and co-relater query?
What is composite primary key in sql?
Types of joins ?
3 Answers Digital GlobalSoft, HeadStrong,