Online Access Free 000-544 Practice Test

Given the following table definition in a multi-partitioned database:

Which column(s) will be chosen by DB2 as a distribution key (partitioning key)?

• A.EMP_ID
• B.NAME
• C.SS_ID
• D.SS_ID, EMP_ID, and NAME

An employee is not able to connect to the PRODDB database using the correct user ID and password. The TCP/IP protocol is running normally; other remote clients are also having problems connecting to this database. Which two could be the cause of the problem? (Choose two.)

• A.The client's authentication type is not compatible with the server.
• B.The DB2 Administration Server is not started.
• C.The server node and/or database are not cataloged correctly on the client.
• D.The DB2COMM environment variable at the server is not set to TCPIP.
• E.The port number is not assigned in the server's services file.

What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

• A.SYSADM authority
• B.SECADM authority
• C.EXECUTE privilege on audit routines with NO DATA
• D.DBADM authority
• E.EXECUTE privilege on audit routines with DATA

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

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

Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?

• A.The ADMIN_GET_TAB_INFO table function.
• B.The ADMINGETTABCOMPRESSINFO_V97 table function.
• C.The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.
• D.The ADMINGETTABCOMPRESSINFO table function.