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

Is storing images in a database a good idea?

0 Answers  

What is table scan and index scan?

0 Answers  

Explain the field term used in database.

0 Answers  

What is sqlcode -923 ?

1 Answers  

Why do we need distributed database?

0 Answers  

5. Explain about relational algebra.

0 Answers  

Which is the best graph database?

0 Answers  

How do I setup a database connection?

0 Answers  

How to do performance tunning a database in DB2 V8.2 UDB in linux

0 Answers  

Explain various types of locks in a transaction? Which is better and why?

0 Answers   Agilent,

Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?

1 Answers  

1.what are components of querystdio and report studio and cognoss connection? 2. how to use prompts in query studio? 3.what is lock and un lock objects? 4.how to test the re[ports in query studio? 5.how to use brust option and when? 6.what is the performance testing? 7.condition explorer whaen your using? 8.in impromptu how do you create cascading prompt? 9.diff between section and group? 10.types filters where you are using group filters and tabular filter? 11.tabular model, tabular references ,tabular set , tabular sql? 12.what is the use of multi[le packages? 13what types of problems arise when create a join? 14.how to provide package sequirety? 15.report server components? 16.how many kinds of quality subjects? 17.how do you specify the joins? 18.how would you maintain the relations in frame work manager? 19.what is usage of segments and how to provide it? 20.governer settings in frame work maneger? 21.how to create filter in frame work manager? 22diffrence between represention layer and physical layer? 23.how to create prompts in frame work manager? 24.what errors occured when verify the model? 25.how to publish package in net work or local system?

1 Answers   Wipro,

For more Databases AllOther Interview Questions Click Here
Categories