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 THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

0 Answers   Wipro,

After normalization, what are the conditions which have to keep in mind to de-normalize it?

0 Answers   C DAC, CDAC,

Define the following terms i. Inverted List ii. Candidate Key iii. B-Tree iv. Foreign Key

1 Answers   Ignou,

hai i want to learn oracle apps and i want to put the fake exp of one year so could you please suggest me which is best institute in hyderabad to learn oracle with real time project experience?

2 Answers  

How to do Data size testing? Who does this testing (Developer or tester)?

0 Answers  




Explain entity type?

0 Answers  

how can we view column head in first page but not in remaining pages?

0 Answers   TCS,

What is the use of graph database?

0 Answers  

How do you pass parameter in stored procedure?

0 Answers   CGI,

Explain database partitioning.

0 Answers  

What is the difference between specialization and generalization?

0 Answers   BirlaSoft,

Datatypes are unlimited,true or false?

2 Answers   Infosys,

For more Databases AllOther Interview Questions Click Here
Categories