IBM 000-546 Prüfungsthemen:

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade 000-546 Prüfungsfragen mit Lösungen

Frage #1

When the DIAGSIZE database manager configuration parameter is set to 10 on a Linux or Unix OS, what behavior will occur?

A. DB2 rotates through 10 db2diag.log files that are 10 MB in size.
B. DB2 limits the size of the db2diag.log and <instance>.nfy files to 10 MB, and purges the old records when the limit is reached.
C. DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files that are 10 MB in size.
D. DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files and limits the total size of the 20 files to 10 MB.

Frage #2

What authority is required to grant SECADM authority to roles and groups?

A. Security Administrator
B. Database Administrator
C. Database Administrator with DATAACCESS and ACCESSCTRL privileges
D. System Administrator

Frage #3

Which statement describes the state of the DMS table space TBS_1 after the successful execution of the following script? ALTER TABLESPACE tbs_1 MANAGED BY AUTOMATIC STORAGE

A. The table space TBS_1 is managed by automatic storage, in a backup pending state and all its containers are relocated to the database assigned automatic storage paths.
B. The table space TBS_1 is managed by automatic storage and in a rebalance pending state waiting for the REBALANCE command.
C. The table space TBS_1 is managed by automatic storage, online and all its containers are relocated to the database assigned automatic storage paths.
D. The table space TBS_1 is managed by automatic storage, online and still using its old containers.

Frage #4

If table TAB_A has just been created as follows:

Which command will create a compression dictionary for table TAB_A?

A. DELETE FROM tab_a
B. LOAD FROM data.del OF DEL INSERT INTO tab_a
C. REORG TABLE tab_a
D. UPDATE tab_a SET c1 = c1*1.1

Frage #5

The SALES database was created without AUTOMATIC STORAGE. If the following command is executed: ALTER DATABASE sales ADD STORAGE ON '/db2fs1', '/db2fs2' What is the expected result?

A. The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, existing table spaces need to be dropped and recreated.
B. The SALES database is converted to AUTOMATIC STORAGE and all its existing DMS table spaces are in rebalance pending state.
C. The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, ALTER TABLESPACE statement is needed to convert existing table spaces.
D. The SALES database and all its table spaces are converted to AUTOMATIC STORAGE.

Fragen und Antworten: