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...


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

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 does currency type mean in database?

0 Answers   Amazon,


What is Data Modelling?

0 Answers   Informatica,


First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

0 Answers   IBM,


Explain database partitioning. What is its importance?

0 Answers  


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

2 Answers   Accenture,


Is redis in memory database?

0 Answers  


What is aws documentdb?

0 Answers  


Can you tell any two advantages of stored procedures?

0 Answers   Verifone,


How default key is different from primary key?

0 Answers   Abacus,


If the master device is full, how do I make the master database bigger?

0 Answers  


What is sqlcode -923 ?

1 Answers  


Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

0 Answers   Amazon,


Categories