Correct Answer: An SQL statement created at program execution time
Explanation:
Note: This Question is unanswered, help us to find answer for this one
DB2 Administration Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More DB2 Administration MCQ Questions
What is a DB2 access path?
How does DB2 determine which lock-size to use?
What is a DB2 bind?
Which is not true for a segmented table space?
When is the access path determined for dynamic SQL?
What is a DB2 IMAGECOPY
Which DB2 object allows multiple users to access data in a table with each user only being able to access certain portions of the data?
When working with concurrency controls, what happens when the number of locks held on rows and tables is equal to the percentage of the locklist specified by maxlocks?
Why is the deadlock detector an important part of DB2 architecture?
Given the code: EXEC SQL DECLARE cursor1 CURSOR FOR SELECT name, age, b_date FROM person; EXEC SQL OPEN cursor1; Under which of the following situations will the above cursor be implicitly closed?