IBM C2090-544 Online Practice Questions and Exam Preparation

IBM C2090-544 Online Questions & Answers

• Question 71:

  A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

  A. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.
  B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.
  C. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.
  D. The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.
  B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.

• Question 72:

  Which command would be used to obtain the name of the first active log file for a database with log retain enabled?

  A. GET CURRENT ACTIVE LOGFILE
  B. LIST LOGFILES
  C. GET DATABASE CONFIGURATION
  D. LIST INDOUBT TRANSACTIONS
  C. GET DATABASE CONFIGURATION

• Question 73:

  A partitioned instance named DB2INST1 uses the following db2nodes.cfg file:

  If the CREATE DATABASE command is executed on server C, which partition will be the catalog partition?

  B. 1
  C. 4
  D. 6
  C. 4

• Question 74:

  When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?

  A. It terminates immediately.
  B. It remains active as long as the MAXAGENTS setting is not exceeded.
  C. It is placed in the agent pool if the connection is terminated.
  D. It automatically releases the database connection and returns to the pool.
  C. It is placed in the agent pool if the connection is terminated.

• Question 75:

  When the DBA chooses the dimensions for a multi-dimensional clustering (MDC) table, which two characteristics should be considered? (Choose two.)

  A. the query transaction rate
  B. numeric data versus character data
  C. extent size
  D. the combined cardinality of the candidate columns
  E. prefetch size
  C. extent size
  D. the combined cardinality of the candidate columns

• Question 76:

  Which option of the ALTER TABLE statement tells the DB2 optimizer to use an index scan on a table that might vary in size at run time from being empty to containing a large number of rows?

  A. CARDINALITY VOLATILE
  B. INDEXSCAN
  C. VOLATILE
  D. CURRENT CARDINALITY
  C. VOLATILE

• Question 77:

  What new security authorities have been introduced in DB2 V9.7?

  A. WLMADM, ACCESSCTRL, SECADMIN
  B. EXPLAIN, SECADMIN, DATAACCESS
  C. SECADMIN, ACCESSCTRL, SQLADM
  D. WLMADM, SQLADM, EXPLAIN
  D. WLMADM, SQLADM, EXPLAIN

• Question 78:

  Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2, C3 and C4 together, which statement(s) will create index(es) that will provide optimal query performance?

  A. CREATE UNIQUE INDEX xtab1 ON tab1 (c1);CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3, c4);
  B. CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3, c4);
  C. CREATE UNIQUE INDEX xtab1 ON tab1 (c4, c3, c2, c1);
  D. CREATE UNIQUE INDEX xtab1 ON tab1 (c3) INCLUDE (c1, c2, c4);
  B. CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3, c4);

• Question 79:

  Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?

  A. RECLAIM EXTENTS ONLY
  B. RELEASE FREE EXTENTS ONLY
  C. RECLAIM FREE BLOCKS
  D. RELEASE FREE BLOCKS ONLY
  A. RECLAIM EXTENTS ONLY

• Question 80:

  Which series of items are required to establish a TCP/IP connection to a DB2 for z/OS database from a DB2 for Linux, UNIX, or Windows server?

  A. hostname, logical unit (LU) name, target database name, local database name, node name
  B. hostname, logical unit (LU) name, subsystem ID, local database name, node name
  C. hostname, port number/protocol, subsystem ID, local database name, node name
  D. hostname, port number/protocol, target database name, local database name, node name
  D. hostname, port number/protocol, target database name, local database name, node name