Which is the correct way to back up only metadata about database backups, table space backups, and table
load operations for database MYDB?

Which of the following are valid Explain operators? (Choose two.)

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have
indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for
indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run
against the SALES table?

Which options are valid for an online reorganization operation?

Which statement regarding event monitors is TRUE?

Which command can be used to view the configured global registry settings for all installed DB2 copies found
on a Linux server?

Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2
pureScale cluster?

Which statement about label-based access control (LBAC) is TRUE?

Which security mechanism is responsible for verifying that users are indeed who the claim to be?

Automatic space reclamation for column-organized tables can be accomplished in which of the following
scenarios?