IBM C2090-312 - IBM DB2 11 DBA for z/OS Exam

Page:    1 / 14   
Total 67 questions

Which statement is true?

  • A. Unicode and EBCDIC have a different collating sequence.
  • B. The collating sequence for ASCII and EBCDIC is identical.
  • C. The collating sequence for Unicode and EBCDIC is identical.
  • D. If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation.


Answer : A

Reference:http://www-
01.ibm.com/support/knowledgecenter/SS4LQ8_3.1.0/com.ibm.datatools.aqt3.doc/gui/conc epts/c_idaa_inconsistencies.html(first bulleted point on the page)

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 subselect
  • C. A SELECT statement predicate against the transaction start ID of the base table.
  • D. A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect.
  • E. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal table.


Answer : C,E

Which is NOT a valid privilege/authority for executing CREATE TYPE (array)?

  • A. SYSADM
  • B. SYSOPR
  • C. SYSCTRL
  • D. CREATEIN on the schema


Answer : A

Which DB2 Client command can be used to identify the Client's version?

  • A. db2fm
  • B. db2look
  • C. db2level
  • D. db2ldcfg


Answer : C

The degree of parallelism can vary for the REBUILD INDEX utility.
What action should be taken to limit the use of real memory using the REBUILD INDEX utility?

  • A. Increase the value of the PARALLEL option.
  • B. Decrease the value of the PARALLEL option.
  • C. Increase the value in the CURRENT DEGREE special register.
  • D. Decrease the value in the CURRENT DEGREE special register.


Answer : A

Page:    1 / 14   
Total 67 questions