IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 1:

  Which of the following statements is NOT correct?

  A. UNLOAD with NOPAD improves performance.
  B. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).
  C. Unload will process cloned table with UNLOAD CLONE and CLONED YES on the LISTDEF.
  D. Clone table allows replacing data without renames and rebinds to support online load replace.
  B. Partition parallelism in UNLOAD is activated with STACK(YES) and UNIT(TAPE).

• Question 2:

  Which option allows the UNLOAD utility to unload LOBs into output files together with non-LOB data?

  A. DELIMITED
  B. SPANNED YES
  C. DSNTYPE HFS on the TEMPLATE
  D. DSNTYPE LIBRARY or PDS on the TEMPLATE
  B. SPANNED YES

• Question 3:

  For monitoring space growth over time, which statistics should NOT be considered?

  A. SYSIBM.SYSTABLEPART_HIST CARDF, SPACEF SYSIBM.SYSINDEXPART_HIST CARDF, SPACEF
  B. SYSIBM.SYSTABLEPART CARDF, SPACEF SYSIBM.SYSINDEXPART CARDF, SPACEF
  C. SYSIBM.SYSTABLESPACE DSSIZE, AVGROWLEN SYSIBM.SYSINDEXES PIECESIZE, AVGKEYLEN
  D. SYSIBM.SYSTABLESPACESTATS SPACE SYSIBM.SYSINDEXSPACESTATS SPACE
  C. SYSIBM.SYSTABLESPACE DSSIZE, AVGROWLEN SYSIBM.SYSINDEXES PIECESIZE, AVGKEYLEN

• Question 4:

  The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?

  A. Issue a LOCK TABLE for all 4 tables.
  B. Execute the SQL INSERT before the SQL UPDATE.
  C. Provide an effective commit / restart process.
  D. Run a QUIESCE utility before the process starts.
  C. Provide an effective commit / restart process.

• Question 5:

  Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)

  A. LOG NO
  B. SORTKEYS 16
  C. FASTSWITCH YES
  D. AUTOESTSPACE YES
  E. DRAIN_WAIT and RETRY
  C. FASTSWITCH YES
  E. DRAIN_WAIT and RETRY

• Question 6:

  When planning for disaster recovery, which two items are NOT required to send to the remote site? (Choose two.)

  A. DB2 archive logs.
  B. Image copies of indexes.
  C. A copy of your ICF catalog.
  D. Image copies of table spaces.
  E. Backups of the DB2 catalog and directory.
  B. Image copies of indexes.
  C. A copy of your ICF catalog.

• Question 7:

  An object (table space, index space or a physical partition of a table space or index space) is in AREST or RESTP status. If backout activity is not already underway, what should occur?

  A. Issue a RECOVER POSTPONED command.
  B. Issue a START command with ACCESS(RW).
  C. Recycle the system with the system parameter LBACKOUT=NO.
  D. Issue a STOP command and then a START command with ACCESS(RW).
  A. Issue a RECOVER POSTPONED command.

• Question 8:

  What is one of the first key steps in preparing to use the BACKUP SYSTEM utility?

  A. Run the MODIFY RECOVERY utility.
  B. Alter the BSDS to allow BACKUP SYSTEM.
  C. Define one or more storage groups to a COPYPOOL.
  D. Stop DB2 to enable DFSMShsm functionality to be used.
  C. Define one or more storage groups to a COPYPOOL.

• Question 9:

  What kind of information is stored in SYSIBM.SYSCOPY?

  A. General information needed for recovery.
  B. Only information about existing image copies.
  C. Information about currently running and stopped copy jobs.
  D. Only information about objects which are currently in copy pending.
  A. General information needed for recovery.

• Question 10:

  In a data sharing environment, how is the LRSN value created?

  A. It is selected from the DB2 catalog.
  B. It is generated from a sequence object.
  C. It is derived from the sysplex timer (store clock).
  D. It is derived from combining RBAs from multiple members.
  C. It is derived from the sysplex timer (store clock).