C2090-312

A statement-level access path hint can be applied to which type of SQL statement?A .  Static SQL statements only.B .  Dynamic SQL statements only.C .  Both static and dynamic SQL statements.D .  Statements included in a CREATE PROCEDURE statement only.View AnswerAnswer: B

The TCP/IP Already Verified (TCPALVER) DB2 system parameter controls whether DB2 accepts a TCP/IP connection requests. Which statement is NOT a valid value?A .  TCPALVER=NOB .  TCPALVER=YESC .  TCPALVER=SERVER_SECURED .  TCPALVER=SERVERENCRYPTView AnswerAnswer: B

A table space is successfully recovered by using RECOVER TABLESPACE db. ts TOLASTFULLCOPY. This table space is referenced by an index. Which statement is true?A .  The index has now a status of REFC .  The index has now a status of RECE .  The index has now a status...

Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?A .  A period-specification placed in the FROM clause of a subselect.B .  A period-specification placed in the WHERE clause of a subselectC .  A SELECT statement predicate...

What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?A .  1GB .  2GC .  4GD .  8GView AnswerAnswer: C

Which command populates the EXPLAIN tables but does not create a package?A .  REBINDCOPYB .  REBINDEXPLAIN(NO)C .  REBINDEXPLAIN(YES)D .  REBIND EXPLAIN(ONLY)View AnswerAnswer: D Explanation: http://www01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc/db2z_ bindoptexplain.dita

What is necessary in order to enable optimization hints?A .  ASYSIBB . PLAN_TABLEtable.C .  INSERT authority on SYSIBD . SYSQUERY table.E .  A required index on the PLAN_TABLE used for optimization hints.F .  ADSN USERQUERY TABLE table under the schema in which hints will be created.View AnswerAnswer: C

A hotel prices its rooms differently at different times of the year. For example, Room 101 rents for $100 per night January through March, $150 per night April through September, and $80 per night October through December. Which type of table could be used to implement the time-based rate changes?A...

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...

What is the least disruptive way of externalizing real-time statistics for table space DB1TS1?A .  -SET LOG LOGLOAD(O)B .  -DISPLAY DB(DB1)SPACENAM(TS1)C .  RUNSTATS TABLESPACE DB1TS1D .  -ACCESS DB(DB1) SPACENAM(TSI) MODE(STATS)View AnswerAnswer: C