IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 101:

  To configure instance-level auditing with db2audit, which authority is required?

  A. SYSADM
  B. SYSCTRL
  C. SECADM
  D. SYSMAINT
  A. SYSADM

• Question 102:

  Which statement about data type mappings is true in a federated system?

  A. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.
  B. Data types can be mapped in both directions between a remote and local data type.
  C. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.
  D. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.
  B. Data types can be mapped in both directions between a remote and local data type.

• Question 103:

  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.
  C. SMS table spaces are recommended when you have small tables that are not likely to grow quickly.

• Question 104:

  What is a benefit of multi-temperature data storage?

  A. It helps reduce redundant I/O.
  B. It helps improve data compression ratios.
  C. It helps reduce storage costs for infrequently accessed data.
  D. It helps identify data access patterns to aid in storage planning.
  C. It helps reduce storage costs for infrequently accessed data.

• Question 105:

  Which command will be executed successfully on every database partition if db2_all is used?

  A. CONNECT
  B. FORCE APPLICATION
  C. RESTART DATABASE
  D. ACTIVATE DATABASE
  C. RESTART DATABASE

• Question 106:

  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.
  B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.

• Question 107:

  If the following statements are executed:

  CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot;

  What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?

  A. Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.
  B. Issue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.
  C. Perform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.
  D. Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.
  A. Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.

• Question 108:

  A database named TEST was created and two buffer pools named BP_GENERAL and BP_AUDITING were created as follows:

  

  The majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers thatThe majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers that would populate the table in table space TS2 each time changes were made to the database were then defined and the database was put into production. At first, ad-hoc queries performing random I/O against the table in table space TS2 ran fine, but performance has gotten worse as the table has gotten larger. What should be done to improve query performance?

  A. Reduce the size of the BP_AUDITING buffer pool.
  B. Increase the size of the BP_AUDITING buffer pool.
  C. Change the page size of the BP_AUDITING buffer pool to 16 or 32 K.
  D. Replace the BP_AUDITING buffer pool with a block-based buffer pool.
  A. Reduce the size of the BP_AUDITING buffer pool.