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


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 execute stored procedures?

0 Answers  


How to restart a DB2 program?

0 Answers   Cognizant,


when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,


why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  


What is a system catalog table in db2?

0 Answers  


What is Call attach facility? How does it work?

1 Answers   Syntel,


When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  


What is a db2 package?

0 Answers  


What happens in bind step in a db2 program?

0 Answers  


What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,


Name the lockable units in DB2?

0 Answers  


What is the meaning concurrency in the db2 database?

0 Answers  


Categories