Which statement about the db2pd tool is true?

Which system command can be used to locate and return only ADM4500W messages from the DB2
diagnostics log file?

By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even
though an index exists. In order to utilize the existing index, what should be done before issuing the
RUNSTATS command to collect statistics for both the index and table?

Which statement regarding snapshot administrative views and snapshot monitor table functions is true?

What authority is required to create, alter and drop workload management objects?

A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named
ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from
seeing the DEV instance and its databases?

Which statement is true regarding client-server database connectivity?

Which command is used to export connectivity configuration information from a file known as a configuration
profile?

Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol
(LDAP)? (Choose two.)

Given the following statement:

How many constraints are present in the DEPARTMENT table?