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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

When is the access path determined for dynamic SQL?

Question Posted / guest

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 2 resolve the -311 sqlcode

1 Answers  

What does db2 mean?

0 Answers  

What is a SELECT statement?

1 Answers  

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

What does the REORG Utility do?

2 Answers  

What is a data page?

1 Answers  

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

Why cursor is used in db2?

0 Answers  

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

What are concurrency issues?

0 Answers  

B37 abend during spufi?

0 Answers   IBM,

Explain db2.

0 Answers  

For more DB2 Interview Questions Click Here
Categories