IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 1:

  If the AUDIT_BUF_SZ configuration parameter is set to zero (0), what will happen?

  A. The audit facility writes records to disk at the same time the statements generating the audit records are executing.
  B. Statements generating audit records must wait for the records to be written to disk before they can complete execution.
  C. The writing of audit records to disk will be delayed until a minimum number of records (based on record size and memory available in the database heap) have been generated.
  D. There is no limit to how many audit records can be stored in an internal memory buffer for one single statement generating audit records.
  B. Statements generating audit records must wait for the records to be written to disk before they can complete execution.

• Question 2:

  After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool would you use to determine which LOAD operation is being problematic?

  A. db2pd
  B. db2dart
  C. db2fodc
  D. db2ls
  A. db2pd

• Question 3:

  In which situation would you NOT use a redirected restore?

  A. To redefine the paths of a defined storage group.
  B. To move table space containers onto different physical devices.
  C. To restore a backup image from one operating system to another.
  D. To restore a backup image to a target machine that is different from the source machine.
  C. To restore a backup image from one operating system to another.

• Question 4:

  In what situation should you use a redirected restore operation?

  A. You want to drop a storage group during a restore process.
  B. You want to move data from one operating system to another.
  C. You want to restore you table spaces into new storage groups.
  D. You want to restore your table space containers into a different physical location.
  D. You want to restore your table space containers into a different physical location.

• Question 5:

  You need to restore a table space that was backed up earlier, but before you begin a restore operation you want to determine whether any tables in the table space were populated with a LOAD ... NONRECOVERABLE operation. What can be used to provide this information?

  A. The INSPECT utility
  B. The db2pd command
  C. The db2dart command
  D. The database recovery history file
  D. The database recovery history file

• Question 6:

  Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels?

  A. db2pd
  B. inspect
  C. db2dart
  D. db2mtrk
  A. db2pd

• Question 7:

  Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis:

  db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to perform the same backup operation?

  A. BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup
  B. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup
  C. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup
  D. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup
  D. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup

• Question 8:

  Which configuration parameter is used to designate a storage area for archived log files that are retrieved for recovery purposes?

  A. logarchopt1
  B. failarchpath
  C. mirrorlogpath
  D. overflowlogpath
  D. overflowlogpath

• Question 9:

  What is the default user workload class that is created for each database table?

  A. DEFAULT_USER
  B. SYSUSERDEFAULTWLM
  C. SYSDEFAULTUSERWORKLOAD
  D. SYS_DEFAULT_USER_WORKLOAD
  C. SYSDEFAULTUSERWORKLOAD

• Question 10:

  With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?

  A. The primary database only.
  B. The auxiliary standby database only.
  C. The principal standby database only.
  D. The primary, auxiliary standby, and principal standby database.
  C. The principal standby database only.