Which of the following are all valid types of trigger?

Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is
created, what happens? (Choose two.)

The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in
database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the
application. The first QUIESCE completes at time “pit”.
BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE
QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE
QUIESCE TABLESPACES FOR TABLE tab1 RESET
Which of the following is TRUE?

Which of the following enables the user to connect to the HADR standby database and execute select
statements?

When operating in NPS compatibility mode, which of the following are limitations for using a routine written in
NZPLSQL? (Choose two.)

Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may
potentially fill, returning an error?

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?