IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 81:

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

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

• Question 82:

  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
  D. MON_GET_REBALANCE_STATUS

• Question 83:

  A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed to establish the specified connections?

  A. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, and nicknames for all databases.
  B. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, and nicknames for all databases.
  C. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.
  D. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.
  C. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.

• Question 84:

  Which command(s) should be used to drop database partition 10 from a database named MYDB?

  A. STOP DBM DROP DBPARTITIONNUM 10; DROP DBPARTITIONNUM VERIFY;
  B. DROP DBPARTITIONNUM VERIFY; STOP DBM DROP DBPARTITIONNUM 10;
  C. CONNECT TO mydb; DROP DBPARTITIONNUM 10; CONNECT RESET;
  D. CONNECT TO mydb; DROP DBPARTITIONNUM 10; ACTIVATE DB mydb;
  B. DROP DBPARTITIONNUM VERIFY; STOP DBM DROP DBPARTITIONNUM 10;

• Question 85:

  If a large amount of sequential prefetching is occurring, what can be done to improve efficiency?

  A. Set SEQDETECT to NO.
  B. Set NUMBLOCKPAGES to 0 in all buffer pools.
  C. Allocate a block-based area in the appropriate buffer pool.
  D. Create indexes that encourage the optimizer to use index-only access.
  C. Allocate a block-based area in the appropriate buffer pool.

• Question 86:

  A DBA wants to create a table named SALES that has the following characteristics:

  Effective data clustering and management of space utilization Rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?

  A. ORGANIZE BY DIMENSIONS
  B. ORGANIZE BY INSERT TIME
  C. ORGANIZE BY TIME PERIOD
  D. ORGANIZE BY KEY SEQUENCE
  B. ORGANIZE BY INSERT TIME

• Question 87:

  What is the preferred method for reclaiming unused storage in a DMS table space?

  A. Perform an ALTER TABLESPACE...REDUCE operation.
  B. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation.
  C. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.
  D. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation.
  C. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.

• Question 88:

  What must be done to convert a populated base table to a multidimensional clustering (MDC) table?

  A. Export the data, create an MDC table, and then import or load the data into the MDC table.
  B. Execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table.
  C. Create an MDC table and then move the data in the base table to the MDC table with the db2move command.
  D. Export the data, execute the ALTER TABLE ... ORGANIZE BY DIMENSIONS statement to convert the table, and then import or load the data into the converted table.
  A. Export the data, create an MDC table, and then import or load the data into the MDC table.

• Question 89:

  On which two operating systems can DB2 pureScale run? (Choose two.)

  A. AIX
  B. Linux
  C. HP-UX
  D. Solaris
  E. Windows
  A. AIX
  B. Linux

• Question 90:

  What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)

  A. Table space available space
  B. Table space read and write activity
  C. Table space container assignments
  D. Table level activity within a table space
  E. Table space backup and recovery information
  A. Table space available space
  B. Table space read and write activity