what is the result of the execution of this command?

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

View Answer

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