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

plz suggest me the books for the preparation of NIC written exam.

4 Answers   NIC, Rolta,

What is the candidate key used for?

0 Answers   BirlaSoft,

Explain entity ?

0 Answers  

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

0 Answers  

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?

3 Answers   CTS,




Is hive a database?

0 Answers  

What is the main difference b/w Teradata and Oracle?

1 Answers   TCS,

What is OQL?

4 Answers  

How do you connect to a database?

0 Answers  

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

0 Answers   Datamatics,

How to do Stored procedure testing? Who does this testing (Developer or tester)?

0 Answers  

a __________ is a virtual table made up of subset of actual table

2 Answers  

For more Databases AllOther Interview Questions Click Here
Categories