Online Access Free 000-546 Practice Test

On which two operating systems (OS) can you integrate Workload Management (WLM) in DB2 LUW with the Workload Management in the OS? (Choose two.)

• A.Solaris
• B.AIX
• C.Windows
• D.HP/UX
• E.Linux

If table TAB_A has just been created as follows:

Which command will create a compression dictionary for table TAB_A?

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

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 and all its existing DMS table spaces are in rebalance pending state.
• B.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.
• C.The SALES database and all its table spaces are converted to AUTOMATIC STORAGE.
• D.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.

A DBA wants to use XQuery on a XML document to determine the number of lock waits for a particular workload. Which of the following table functions should be used?

• A.MON_GET_WORKLOAD_DETAILS
• B.MON_GET_LOCKS_DETAILS
• C.MON_GET_LOCKS
• D.MON_GET_WORKLOAD

Given the following GRANT commands:

Assuming that user BOB belongs to the group STAFF and STAFF has no other privileges aside from what is defined above, what is the highest level of privilege that BOB has on the database?

• A.CONNECT
• B.DBADM
• C.ACCESSCTRL
• D.DATAACCESS