1.
Which statement is true regarding client-server database connectivity?
2.
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?
3.
What authority is required to create, alter and drop workload management objects?
4.
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?
5.
Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file?
6.
Which statement about the db2pd tool is true?
7.
If you are running DB2 in clustered environment, what utility should you use to get the status of cluster?
8.
Which user-managed file system is required for DB2 pureScale deployments?
9.
What information can be obtained by analyzing EXPLAIN data?
10.
How is the time that an agent waits for log records to be flushed to disk calculated?