← Back to exam page

Free C2090-312 – IBM DB2 11 DBA for z/OS Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–3 of 7 questions

Question 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?

Select all that apply, then click Submit answer.

  • ○

    A period-specification placed in the FROM clause of a subselect.

  • ○

    A period-specification placed in the WHERE clause of a subselect
  • ○

    A SELECT statement predicate against the transaction start ID of the base tablE.

  • ○

    A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect.
  • ○

    A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal tabl
Question 2

You analyze an accounting report. You see a high "NOT ACCOUNTED" timE. Which two events can contribute to this high value?

Select all that apply, then click Submit answer.

  • ○

    CPU wait timE.

  • ○

    I/O read wait timE.

  • ○

    Log write wait timE.

  • ○

    Real storage paging wait timE.

  • ○

    Execution unit switch wait tim
Question 3

Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the results in a data set or as a result set?

Select an option, then click Submit answer.

  • ○

    ADMIN_INFO_SQL

  • ○

    ADMIN_JOB_QUERY
  • ○

    ADMIN_INFO_SYSPARM

  • ○

    ADMIN UPDATESYSPARM