IBM C2090-317 Online Practice Questions and Exam Preparation

IBM C2090-317 Online Questions & Answers

• Question 11:

  Which statement regarding DSN1LOGP is FALSE?

  A. DSN1 LOGP does not require DB2 privileges.
  B. DSN1 LOGP runs on archive data sets when DB2 is running.
  C. DSN1 LOGP can read logs that have been compressed by DFSMS.
  D. DSN1 LOGP can print the log records for both base and clone table objects.
  C. DSN1 LOGP can read logs that have been compressed by DFSMS.

• Question 12:

  Which trace can be helpful in determining the resources involved with locking (i.e. deadlocks, timeouts) at a subsystem level?

  A. Statistics trace class 1
  B. Statistics trace class 3
  C. Accounting trace class 1
  D. Accounting trace class 3
  B. Statistics trace class 3

• Question 13:

  Which subsystem parameter is used to enable the RECOVER utility to use system-level backups as a recovery base?

  A. RESTORE_TAPEUNITS
  B. SYSTEM_LEVEL_BACKUPS
  C. UTILS_DUMP_CLASS_NAME
  D. RESTORE _ RECOVER_ FROMDUMP
  D. RESTORE _ RECOVER_ FROMDUMP

• Question 14:

  Program Authorization does NOT work in which environment?

  A. IMS
  B. CICS
  C. DSN command processor
  D. Programs that run in stored procedure address spaces
  C. DSN command processor

• Question 15:

  In an environment with a large amount of dynamic SQL, which subsystem parameter should be adjusted to increase the amount of memory available for caching statements in the global dynamic statement cache?

  A. EDMPOOL
  B. EDMDBDC
  C. MAXKEEPD
  D. EDMSTMTC
  C. MAXKEEPD

• Question 16:

  What happens in DB2 11 CM once you hit RBA x'FFF800000000' in a non-data sharing environment?

  A. No updates are allowed.
  B. DB2 terminates and can only be restarted in maintenance mode.
  C. DB2 does not allow any activity except REORG SHRLEVEL CHANGE or REFERENCE.
  D. No updates are allowed unless you migrated the BSDS to 10-byte RBA/LRSN format.
  D. No updates are allowed unless you migrated the BSDS to 10-byte RBA/LRSN format.

• Question 17:

  Which statement regarding migration from DB2 10 for z/OS to DB2 11 for z/OS is true?

  A. All packages must be rebound with application compatibility set to V10R1.
  B. The DB2 catalog and directory must be changed to reside on SMS managed DASD.
  C. All packages last bound prior to DB2 9 for z/OS must be rebound in DB2 10 or DB2 11.
  D. The size of the DB2 bootstrap datasets must be increased to accommodate a larger LRSN and RBA length.
  A. All packages must be rebound with application compatibility set to V10R1.

• Question 18:

  A column mask is defined on TB_A. Which statement runs successfully?

  A. SELECT ' FROM TB_A UNION ALL SELECT ' FROM TB_B
  B. SELECT ' FROM TB_A INTERSECT SELECT * FROM TB_B
  C. SELECT ' FROM TB_A EXCEPT ALL SELECT ' FROM TB_B
  D. SELECT'FROM TB A INTERSECT ALL SELECT * FROM TB B
  A. SELECT ' FROM TB_A UNION ALL SELECT ' FROM TB_B

• Question 19:

  You want to temporarily switch-off one of your trusted contexts. How can this be accomplished?

  A. DROP TRUSTED CONTEXT...
  B. -STOP DB(DSNDB06) TS(SYSCONTX)
  C. ALTER TRUSTED CONTEXT ... DISABLE
  D. -STOP TRACE(AUDIT) AUDTPLCY(TRUSTED_CONTEXT)
  C. ALTER TRUSTED CONTEXT ... DISABLE

• Question 20:

  One of your applications is experiencing long elapsed times. You notice from DB2 accounting data that 90% of the class 2 elapsed time consists of class 3 suspension time. Which statement describes the behavior of the application?

  A. The application is the victim of excessive performance tracing.
  B. The application spends the majority of its time waiting on the network.
  C. The application contains complex SQL statements that are CPU intensive.
  D. The application spends the majority of its time waiting for buffer pool I/O and log I/O.
  C. The application contains complex SQL statements that are CPU intensive.