IBM DB2 11 DBA for zOS Set 1

Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?

As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action?

Prefetch l/Os are executed under a service request block in which address space?

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?

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? 
 

What is necessary in order to enable optimization hints?

Which command populates the EXPLAIN tables but does not create a package?

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?

Which global variables statement is true?

Which DB2 subsystem parameter limits the number of concurrent active TSO requests?