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

問題1

A DBA migrating an existing database to DB2 9.7 wants to allow the primary and secondary recovery logs to be used with non-buffered IO. Which statement is true?

A. This behavior is automatically enabled by default.

B. The DB2_LOGGER_BUFFERED registry variable must be set to OFF.

C. The DB2_LOGGER_AUTO_BUFFERED registry variable must be set to YES.

D. The DB2_LOGGER_NON_BUFFERED_IO registry variable must be set to AUTO.

正確答案: A

問題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

Table T1 was created by executing the following statement:

Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application that inserted 100,000 rows into table T1. The following query is frequently ran against the T1 table:
SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123' Assuming current statics exist for the table and index, which index will provide optimal performance for this query?

A. CREATE INDEX idx1 ON t1 (deptno, empno)

B. CREATE INDEX idx1 ON t1 (deptno)

C. CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)

D. CREATE INDEX idx1 ON t1 (deptno, empno) INCLUDE (deptname)

正確答案: A

問題4

A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?

A. Design Advisor

B. Partition Assistant

C. Configuration Advisor

D. Workload Manager

正確答案: A

問題5

Which action can be performed by the ALTER TABLESPACE statement?

A. Change the size of a container in an SMS table space.

B. Change an SMS table space to a DMS table space on any database partition.

C. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.

D. Add a container to an SMS table space on a database partition that currently has no containers.

正確答案: 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

問題7

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 automatically releases the database connection and returns to the pool.

C. It remains active as long as the MAXAGENTS setting is not exceeded.

D. It is placed in the agent pool if the connection is terminated.

正確答案: D

問題8

Given the following output from the GET DATABASE CONFIGURATION command:

Which of the following DB configurations listed below will enable circular logging?

A. LOGARCHMETH1=OFF and LOGARCHMETH2=OFF

B. LOGRETAIN=CIRCULAR

C. LOGSECOND=-1

D. LOGPRIMARY=LOGCIRCULAR and LOGRETAIN=OFF

正確答案: A

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

聯系我們

站內鏈接

最新更新