AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For IBM- C2090-312





Question ID 22103

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?

Option A

A list of queries that are in error is produced.

Option B

Updated values are placed in SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.

Option C

New values are inserted into the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.

Option D

Messages containing only the status of rows in catalog tables SYSIBM.SYSQUERY and
SYSIBM.SYSQUERYPLAN.

Correct Answer B
Explanation Reference: http://www- 01.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


Question ID 22104

What is necessary in order to enable optimization hints?

Option A

ASYSIBM.PLAN_TABLEtable.

Option B

INSERT authority on SYSIBM.SYSQUERY table.

Option C

A required index on the PLAN_TABLE used for optimization hints.

Option D

ADSN USERQUERY TABLE table under the schema in which hints will be created.

Correct Answer C
Explanation

Send email to admin@getfreedumps for new dumps request!!!