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

Previous-Page 1 2 3 4 5 6 7 8 9. . . 14 15 Next-Page

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