IBM IBM Certified Advanced Database Administrator C2090-614 Questions & Answers

• Question 11:

  What values can be assigned to the HADR_SYNCMODE configuration parameter?

  A. SYNC, NEARSYNC, ASYNC, and NOSYNC

  B. SYNC, NOSYNC, ASYNC, and SUPERASYNC

  C. SYNC, ASYNC, SEMISYNC, and SUPERASYNC

  D. SYNC, NEARSYNC, ASYNC, and SUPERASYNC

  Correct Answer: D

• Question 12:

  Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

  A. Data class, work class, and a limit

  B. Data class, action class, and a threshold

  C. Service subclass, action class, and a limit

  D. Service subclass, work class, and a threshold

  Correct Answer: D

• Question 13:

  What can be done to prevent applications from failing when DB2 cannot create a new log file?

  A. Set MAX_LOG to 0

  B. Set LOGBUFSZ to -1

  C. Set LOGSECOND to -1

  D. Set BLK_LOG_DSK_FUL to YES

  Correct Answer: D

• Question 14:

  Which statement about DB2 Merge Backup is FALSE?

  A. It can be used to merge offline backups to build full offline table space backups.

  B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.

  C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.

  D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.

  Correct Answer: B

• Question 15:

  Which table function can be used to determine whether all of a particular table space data objects have been moved from one storage group toWhich table function can be used to determine whether all of a particular table space data objects have been moved from one storage group to another?

  A. MON_GET_TABLESPACE

  B. ADMIN_GET_STOGROUP_INFO

  C. ADMIN_GET_STORAGE_PATHS

  D. MON_GET_REBALANCE_STATUS

  Correct Answer: D

• Question 16:

  Which type of storage is utilized in the implementation of an effective and flexible multi- temperature database?

  A. System managed storage

  B. Automatic storage utilizing storage groups

  C. System managed storage utilizing storage groups

  D. Database managed storage with file system caching

  Correct Answer: B

• Question 17:

  Which statement about SMS table spaces is correct?

  A. The system catalog cannot be stored in an SMS table space.

  B. Tables, large objects (LOBs), and indexes can each reside in separate SMS table spaces.

  C. SMS table spaces are recommended when you have small tables that are not likely to grow quickly.

  D. Extents are more likely to be contiguous with SMS table spaces than they are with DMS table spaces.

  Correct Answer: C

• Question 18:

  Which operation can be performed by executing an ALTER STOGROUP statement?

  A. Change the name of an existing storage group.

  B. Make an existing storage group the default storage group.

  C. Reduce the current high water mark of all table spaces that have been assigned to a storage group.

  D. Specify the average time, in milliseconds, that it takes to read one page of data from the slowest storage path used by a storage group.

  Correct Answer: B

• Question 19:

  The following statement was used to create a table space named TBSP1 in a non-partitioned database:

  

  Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?

  A. ALTER TABLESPACE tbsp1 REDUCE MAX

  B. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK

  C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);

  D. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;

  Correct Answer: C

• Question 20:

  You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?

  A. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 0.

  B. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 100.

  C. Issue a LIST UTILITIES statement with the 'SUSPEND ' option specified.

  D. Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.

  Correct Answer: D