When is the access path determined for dynamic SQL?

Answers were Sorted based on User's Feedback



When is the access path determined for dynamic SQL?..

Answer / s

The dynamic SQL is prepared at run time and the access path
is determined at execution time. Dynamic SQL changes from
one execution to another.

Is This Answer Correct ?    3 Yes 0 No

When is the access path determined for dynamic SQL?..

Answer / kamalakar

At runtime when the PREPARE statement is issued.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

How to find last record before record through SQLRPGLE?

1 Answers   IBM,


how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,


What is coalesce in db2?

0 Answers  


What is a view? Why use it?

3 Answers  


Is it possible using max on a char column?

0 Answers  


In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,


Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  


What is load replace in db2?

0 Answers  


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  


How can you count the number of rows from a table tab?

0 Answers  


What is the role of union all and union

0 Answers  


db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  


Categories