IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 51:

  If the following commands complete successfully for a single partition database: CREATE DATABASE mydb;

  CREATE BUFFERPOOL mybp; Which statement is true?

  A. Self tuning is enabled for the MYBP buffer pool.
  B. The initial size for the MYBP buffer pool is zero pages.
  C. The database has to be restarted before the MYBP buffer pool will become active.
  D. The page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL statement.
  A. Self tuning is enabled for the MYBP buffer pool.

• Question 52:

  A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have been assigned to this group. What kind of table spaces must the DBA assign to the storage group before the desired tables can be created?

  A. Automatic storage (AS) table spaces
  B. System managed space (SMS) table spaces
  C. Database managed space (DMS) table spaces that use FILE containers
  D. Database managed space (DMS) table spaces that use RAW containers
  A. Automatic storage (AS) table spaces

• Question 53:

  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
  D. Set BLK_LOG_DSK_FUL to YES

• Question 54:

  A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of several columns in the SQL Server data source are changed?

  A. Drop the current data type mapping. Create the new data type mapping.
  B. Drop the nickname to the table. Create the new data type mapping. Recreate the nickname to the table.
  C. Drop the current data type mapping. Create the new data type mapping. Drop the nickname to the table. Recreate the nickname to the table.
  D. Drop the current user mapping. Drop the current data type mapping. Create the new user mapping. Create the new data type mapping. Recreate the nickname to the table.
  B. Drop the nickname to the table. Create the new data type mapping. Recreate the nickname to the table.

• Question 55:

  A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows:

  

  What can be done to improve the performance of a query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?

  A. Reload table SALES and use only one partition with a collocated join to the DATE_DIM table using the primary key DATE_ID
  B. Reload table DATE_DIM and use only one partition with a collocated join to the SALES table using the primary key DATE_ID
  C. Create a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table, create index on DATE_ID column in the REPL_SALES table, and collect statistics on REPL_SALES table.
  D. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh REPL_DATE_DIM table, create index on DATE_ID column in the REPL_DATE_DIM table, and collect statistics on REPL_DATE_DIM table.
  D. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh REPL_DATE_DIM table, create index on DATE_ID column in the REPL_DATE_DIM table, and collect statistics on REPL_DATE_DIM table.

• Question 56:

  Which statement about partitioned indexes is FALSE?

  A. Both system- and user-generated indexes can be partitioned.
  B. Each index partition contains references only to data in its corresponding data partition.
  C. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition
  D. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the corresponding partition index.
  D. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the corresponding partition index.

• Question 57:

  Where is the HADR_TARGET_LIST configuration parameter set?

  A. On the primary database only.
  B. On all participating databases.
  C. On the tertiary standby databases.
  D. On the auxiliary standby databases only.
  B. On all participating databases.

• Question 58:

  Consider the following statement:

  

  Which indexes should be created for optimal query performance?

  A. CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);
  B. CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);
  C. CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);
  D. CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname);
  C. CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);

• Question 59:

  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
  D. SYNC, NEARSYNC, ASYNC, and SUPERASYNC

• Question 60:

  What will occur when a database administrator adds a new automatic storage path to an existing storage group?

  A. New table spaces will start consuming storage on the new path.
  B. Existing table spaces will not consume storage on the new path.
  C. The storage group will be placed in "Rebalance Pending" mode.
  D. DB2 will verify that space is available on the storage path specified.
  B. Existing table spaces will not consume storage on the new path.