• Description:DB2 UDB V7.1 Family Application Development
• Passing Score:0%
• Practice Test - Number of questions:106 questions
• Simulation Test - Number of questions:106 questions
• Simulation Test Duration:120 minutes
• Has explanations:No

Under which of the following situations must dynamic SQL be used?

Answer(s)

1. When Large Objects (LOBs) are used
2. When the host variables values aren't known at compile time
3. When the columns in the SELECT clause aren't known at compile time
4. When the number of rows being returned aren't known at compile time

When the columns in the SELECT clause aren't known at compile time