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 the reports view in oracle sql developer?

0 Answers  

What is raid? How does it help storage of databases?

0 Answers  

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

1 Answers   Fidelity, Oracle,

What is use of package in pl sql?

0 Answers  

What are the different dml commands in sql?

0 Answers  

What is server name sql?

0 Answers  

how will be date change into string

4 Answers  

what is the difference between union and union all? : Sql dba

0 Answers  

What does (*) mean in sql?

0 Answers  

what is External tables? explain with examples

2 Answers   TCS,

what is meant by forward declaration in functions?

4 Answers   TCS,

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories