Which tool can be used to get database design recommendations based on SQL statements stored in the
database package cache?

Where does the DB2 Problem Determination tool (db2pd) get information from?

Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

An HADR environment has two standby databases – one principal and one auxiliary. What is the only mode
that can be used to transfer data to the auxiliary standby?

Which statement about the db2move command is TRUE?

Which of the following statements is TRUE?A. REORGCHK automatically runs tables reorganization.

Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

You receive a large data file that contains large object data values that need to be copied into a table in the
shortest amount of time possible. Which utility should be used?

Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

Which operation can be performed with trusted context privileges that are acquired through a role?