Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?

Question Posted / swapna

Answers were Sorted based on User's Feedback



When we can declare a column as Unique and Not Null both at the same time. What is the use pf Pri..

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

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Pri..

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

Post New Answer

More SQL PLSQL Interview Questions

What is difference between inner join and cross join?

0 Answers  

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

Can a foreign key be a duplicate?

0 Answers  

How does postgresql compare to "nosql"?

0 Answers  

how to create object in plsql

3 Answers   Microsoft,

What is Overloading of procedures ?

4 Answers   Amdocs,

what is the difference between nested subquery and correlated subquery?

0 Answers  

How do you determine the current isolation level? : Transact sql

0 Answers  

Describe different types of general function used in sql?

0 Answers  

What is difference between stored procedures and application procedures?

0 Answers  

wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,

How do you define a foreign key?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories