2026 年，IBM 原廠認證在業界的含金量依舊有目共睹，IBM DB2 9.7 Advanced DBA for LUW 更是履歷上的一大亮點。Fast2test 以 106 道 000-544 練習題，協助您穩紮穩打朝這張證照邁進。

IBM 000-544 考試概覽:

IBM 000-544 考試大綱主題:

IBM DB2 9.7 Advanced DBA for LUW 考生常見問題解答

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

問題 #1

A database and a table space were created using the following commands:

Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert the database?

A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;

問題 #2

What is the minimum authority required to execute the RUNSTATS command against a table?

A. SQLADM
B. SECADM
C. SYSMON
D. DATAACCESS

問題 #3

What will the db2audit facility do when a DB2 database instance is stopped?

A. Generate an error stating that the audit facility should be stopped prior to stopping the instance.
B. Stop automatically.
C. Remain active.
D. Write an error message to the audit log and stop automatically.

問題 #4

What is a method for enabling non-buffered I/O at the table space level in a DB2 database?

A. Set the DB2_FILESYSTEM_CACHE configuration parameter to YES.
B. Set the DB2_DIRECT_IO configuration parameter to YES.
C. Use the USE DIRECT IO clause with the CREATE TABLESPACE or ALTER TABLESPACE command.
D. Use the NO FILE SYSTEM CACHING clause with the CREATE TABLESPACE or ALTER TABLESPACE command.

問題 #5

While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client:
CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000;
CATALOG DATABASE samp001 AS samp001 AT NODE node001;
TERMINATE;
When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node.
The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem?

A. Add a Database Connection Services entry to the /etc/services file on the Windows client.
B. Match the port number in the CATALOG TCPIP NODE command with the port number in the /etc/services file on the remote server.
C. Add an entry into the Database Connection Services directory on the Windows client.
D. Change the service name (SVCENAME) in the remote servers database configuration.

問題與答案：