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 >> Databases AllOther
  2. Suggest New Category

utility used to obtain inform regarding the optimizes
choice of access strategy for SQL stmts
A) LOAD
B) REORG
C) COPY
D) EXPLAIN

Question Posted / harish

Answers were Sorted based on User's Feedback



utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) ..

Answer / akoman

D) EXPLAIN

Is This Answer Correct ?    5 Yes 0 No

utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) ..

Answer / raj kumar

Explain

explain will give the optimizer plan for the query

explain select * from .......etc

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

What is difference between clustered, non-clustered and unique index?

0 Answers   Abacus,

Explain the record term used in database.

0 Answers  

A design problem was given in which I was supposed to make a design for the data base for a given problem.

0 Answers   Motorola,

can we delete autodiff back up that we have set through sql server agent.

0 Answers   Indian Web Technology,

What are the differences between Database Trigger and Integrity constraints ?

2 Answers   Synergy,

How do database connections work?

0 Answers  

What do you mean by cluster and non cluster index?

0 Answers  

What the various ways to tune a teradata query

0 Answers  

What is a Transformation?

0 Answers   Informatica,

On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

0 Answers  

How much does it cost to build a database?

0 Answers  

what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?

1 Answers   OVGU,

For more Databases AllOther Interview Questions Click Here
Categories