IBM
C2090-312 · Question #181
If the OPTHINTS subsystem parameter is set to YES, and you issue the following DB2 command relating to optimization parameter hints: BIND QUERY LOOKUP (YES) what is the result of the execution of…
The correct answer is D. Messages containing only the status of rows in catalog tables SYSIBM.SYSQUERY and. See the full explanation below for the reasoning.
Question
If the OPTHINTS subsystem parameter is set to YES, and you issue the following DB2 command relating to optimization parameter hints:
BIND QUERY LOOKUP (YES) what is the result of the execution of this command?
Options
- AA list of queries that are in error is produced.
- BUpdated values are placed in SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.
- CNew values are inserted into the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.
- DMessages containing only the status of rows in catalog tables SYSIBM.SYSQUERY and
How the community answered
(52 responses)- A12% (6)
- B4% (2)
- C4% (2)
- D81% (42)
Community Discussion
No community discussion yet for this question.