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?
A . A list of queries that are in error is produced.
B . Updated values are placed in SYSIB
C . SYSQUERY and SYSIB
D . SYSQUERYPLAN tables.
E . New values are inserted into the SYSIB
F . SYSQUERY and SYSIB
G . SYSQUERYPLAN tables.
H . Messages containing only the status of rows in catalog tables SYSIB
. SYSQUERY and
SYSIB
. SYSQUERYPLA
Answer: B
Explanation: http://www01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc/db2z_ cmd_bindquery.dita?cp=SSEPEK_11.0.0%2F10-1-1-0-0-2