IBM C2090-317 Online Practice Questions and Exam Preparation

IBM C2090-317 Online Questions & Answers

• Question 41:

  Which DB2 catalog or directory table space CANNOT be reorganized?

  A. DSNDB01.SCT02
  B. DSNDB01.SYSUTILX
  C. DSNDB06.SYSTSCPY
  D. DSNDB06.SYSTSPDO
  D. DSNDB06.SYSTSPDO

• Question 42:

  Your production DB2 subsystem is up and running, the following message is received:

  DSNJ126I - BSDS ERROR FORCED SINGLE BSDS MODE

  because one of the BSDS volumes is offline.

  After the volume is back online, in order to ensure a securely running system, what is the least disruptive scenario to correct this error?

  A. Run the recover BSDS utility.
  B. Issue the -RECOVER BSDS command.
  C. IDCAMS REPRO the correct BSDS VSAM replacing the corrupt BSDS VSAM.
  D. Wait until the next stop and then start the DB2 subsystem to correct the problem.
  C. IDCAMS REPRO the correct BSDS VSAM replacing the corrupt BSDS VSAM.

• Question 43:

  Having to deal with data inconsistency during a disaster recovery can significantly impact the length of time needed to recover. One of the actions that could be taken to prevent this from occurring is to not take an image copy of a data set that contains inconsistent data.

  Which two options can be used to help prevent taking an image copy of inconsistent data?

  A. Run the DIAGNOSE utility before making an image copy.
  B. Run the CHECK DATA utility before making an image copy.
  C. Use the CHECKPAGE option when running the COPY utility.
  D. Prior to making an image copy, run DSN1 COPY with the CHECK option.
  E. At install time, use the DSNTIJIC install job to take a full image copy of the DB2 catalog and directory.
  C. Use the CHECKPAGE option when running the COPY utility.
  D. Prior to making an image copy, run DSN1 COPY with the CHECK option.

• Question 44:

  DB2 can use RUNSTATS profiles for autonomic statistics maintenance. Which catalog table holds the options specified for the profiles?

  A. SYSIBM.SYSAUTOALERTS
  B. SYSIBM.SYSSTATFEEDBACK
  C. SYSIBM.SYSTABLES_PROFILES
  D. SYSIBM.SYSTABLESPACESTATS
  D. SYSIBM.SYSTABLESPACESTATS

• Question 45:

  Which action should you take to improve the performance of authorization checking for stored procedures or user-defined functions?

  A. Set subsystem parameter EXTSEC to YES.
  B. Increase the value of subsystem parameter SECQTY.
  C. Increase the value of subsystem parameter AUTHCACH.
  D. Increase the value of subsystem parameter CACHERAC.
  D. Increase the value of subsystem parameter CACHERAC.

• Question 46:

  Local buffer pool updated pages are queued by data set until they are written out to DASD when which event occurs?

  A. A page is added.
  B. A COMMIT is executed.
  C. When VPSEQT is reached.
  D. A system checkpoint is taken.g
  B. A COMMIT is executed.

• Question 47:

  In a data-sharing environment, what is the first step to prepare for a DB2 RESTORE SYSTEM to a point in time?

  A. Stop all DB2 members.
  B. Stop one DB2 member.
  C. Do not stop any DB2 members.
  D. Stop only the member where RESTORE SYSTEM will run.
  D. Stop only the member where RESTORE SYSTEM will run.

• Question 48:

  In order to guarantee complete security for your DB2 subsystem, which statement is correct?

  A. BSDS and catalog VSAM data sets should always be protected by the SYSADM authority.
  B. BSDS and catalog VSAM data sets should always be protected by the MSTR address space.
  C. BSDS and catalog VSAM data sets should always be protected by an external security profile.
  D. BSDS and catalog VSAM data sets should always be protected by the BSDS system privilege
  C. BSDS and catalog VSAM data sets should always be protected by an external security profile.

• Question 49:

  Which statement is true regarding DB2 definitions for SMF collection?

  A. SMF collection is not required for DB2.
  B. At the minimum, DB2 statistics class 1 trace is required.
  C. At the minimum. DB2 accounting classes 1.2.3 are required.
  D. The SMF subsystem does not have to be active for DB2 to write SMF trace records.
  B. At the minimum, DB2 statistics class 1 trace is required.

• Question 50:

  You wish to enable automatic clean-up of committed pseudo-deleted index entries for all indexes in the DB2 subsystem. You have verified that system table SYSIBM.SYSINDEXCLEANUP has no rows. Without taking any other action, which action will accomplish this?

  A. Set subsystem parameter INDEX_CLEANUP_THREADS to 10.
  B. Set subsystem parameter INDEX_CLEANUP_THREADS to YES.
  C. Issue an ALTER INDEX statement against all indexes with ERASE YES.
  D. Issue an ALTER INDEX statement against all indexes with FREEPAGE 0.
  A. Set subsystem parameter INDEX_CLEANUP_THREADS to 10.