真正上考場時，時間壓力往往比題目本身更可怕。Fast2test 的 Desktop Test Engine 完整模擬 IBM DB2 9.7 Advanced DBA for LUW 的考試環境，搭配 106 道 000-544 練習題反覆實戰演練，正式考試時就能像平常練習一樣從容。

IBM 000-544 考試概覽:

IBM 000-544 考試大綱主題:

關於 000-544 考試，你可能想知道的事

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

問題 #1

What steps, in the correct order, are performed by the SQL and XQuery compilers to generate executable code for non-federated queries?

A. parse query; check semantics; rewrite query; build access plan
B. parse query; rewrite query; check semantics; pushdown predicates; execute access plan
C. check semantics; parse query; build access plan; pushdown predicates; execute access plan
D. check semantics; parse query; rewrite query; build access plan

問題 #2

A database called PRODDB has a weekly full backup taken on Saturday, non-cumulative (delta) backups taken daily, and a midweek cumulative backup that is taken on Wednesday. A database crash occurs on a Saturday prior to the full backup being taken.
What is the fastest way to restore the database?

A. RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Monday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Tuesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Wednesday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Thursday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
B. RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
C. RESTORE DB proddb TAKEN AT (Saturday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
D. RESTORE DB proddb TAKEN AT (Friday);
RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Saturday);

問題 #3

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

問題 #4

Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server?
TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY

A. Any time after 11:07:03 am
B. Any time after 11:02:03 am
C. Any time after 11:07:04 am
D. Any time before 11:07:03 am

問題 #5

Which command CANNOT be used to create the compression dictionary for a table?

A. RUNSTATS
B. IMPORT
C. INSPECT
D. LOAD

問題與答案：