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 dialect in database?

0 Answers  

define primary key index, bitmap index, hash index,virtual indwx

0 Answers   Cap Gemini,

what is primary key,unique key, foreign key? can u teach me in simple language?

44 Answers   Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

What is the advantage of varchar2 over char?

0 Answers   ADITI,

what is difference between delete and truncet ?

7 Answers   Fidelity,




What is the database url?

0 Answers  

What is the role of tester in discovery(in Checklist)?

0 Answers  

WHAT IS CARDINALITIES OF JOIN?

0 Answers  

How concurrency problems effect the database?

0 Answers   BirlaSoft,

Explain the table term used in database.

0 Answers  

Is database a hardware or software?

0 Answers  

What are the types of indexes that are present inside a database?

0 Answers   Abacus,

For more Databases AllOther Interview Questions Click Here
Categories