最新的IBM C2090-544免費考試真題

問題1

Your UNIX system administrator has indicated that there appears to be a lot of I/O wait time associated with your database, which is stored in a 7+p RAID array. An investigation reveals the following information: DB2_PARALLEL_IO=*
Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of 16K, an extent size of 32, and a prefetch size of 64.
Which setting would optimize I/O for the largest table?

A. DB2_PARALLEL_IO=7:64

B. DB2_PARALLEL_IO=7:7

C. DB2_PARALLEL_IO=7:32

D. DB2_PARALLEL_IO=7:16

正確答案: B

問題2

At which two levels can events be audited? (Choose two.)

A. Server level

B. Database level

C. Operating System level

D. Node level

E. Instance level

正確答案: B,E

問題3

A DBA needs to create a federated database and configure access to join data from three Oracle instances and one DB2 database. Which objects are needed to establish the specified connections?

A. 1 Oracle server , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database

B. 3 Oracle servers , 1 DB2 server , 3 Oracle wrappers , 1 DB2 wrapper , and nicknames for each database

C. 3 Oracle servers , 1 DB2 server , 1 Oracle wrapper , 1 DB2 wrapper , and nicknames for each database

D. 1 Oracle server , 1 DB2 server , 3 Oracle wrappers , and nicknames for each database

正確答案: C

問題4

A DBA wants to migrate a DB2 LUW 8.2.2 database to version 9.7 and plans to use currently committed (CC) semantics on an application-by-application basis. Which process will yield the desired results?

A. Migrate the database, then assign the value AVAILABLE to the CURR_COMMIT configuration parameter.

B. Migrate the database, then assign the value ON to the CURR_COMMIT configuration parameter.

C. Set the DB2_USE_CC_SEMANTICS registry variable to YES, then migrate the database.

D. Set the DB2_USE_CC_SEMANTICS registry variable to APPLICATION, then migrate the database.

正確答案: A

問題5

If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?

A. db2acsutil

B. db2dart

C. db2apptrk

D. db2pd

正確答案: D

問題6

The DBA needs to create a table with key columns YEARMONTH and YEAR. This table needs to be partitioned by column YEARMONTH with three months per data partition. Additionally, data needs to be organized by column YEAR, so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?

A. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (yearmonth))

B. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 12)
ORGANIZE BY DIMENSIONS (year))

C. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year))

D. CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 12)
ORGANIZE BY DIMENSIONS (yearmonth))

正確答案: C

最新的IBM DB2 9.7 Advanced DBA for LUW - C2090-544免費考試真題

聯系我們

站內鏈接

最新更新