Which DB2 Explain Facility tool uses the Explain tables to display access plain information?

A. db2look

B. db2advis

C. db2expln

D. db2exfmt

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

A. Catalog a storage access alias in the DB2 database

B. Create an FTP account on IBM Softlayer Object Storage

C. Use the DB2REMOTE parameter of the LOAD command

D. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect

E. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

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

A. SELECT tbsp_name, tbsp_utilization_percentFROM TABLE(sysproc.mon_tbsp_utilization()) AS tWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;

B. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;

C. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;

D. SELECT tbsp_name, tbsp_utilization_percentFROM sysibmadm.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;

What is an advantage of using range partitioned tables?

A. Abilityto run utilities against the partitions in parallel

B. Increased query performance through data partition elimination

C. Block indexes are much smaller than RID indexes, providing better performance

D. Table data is automatically and continuously clustered, requiring minimal reorganization

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

A. Creating, using, or altering thresholds

B. Granting, altering, or revoking workload privileges

C. Using or altering the default service classes and workloads

D. Creating service classes, service subclasses, and workloads

E. Creating, activating, stopping or dropping workload management event monitors

Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?

A. A local keystore is not needed if a Hardware Security Module (HSM) is used to managemaster keys.

B. If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.

C. A master key must be generated and placed in an existing local keystore before a new encrypted

database will be created.

D. After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.

On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

A. As the db2 instance owner (db2inst1) execute the command:exportDB2_FMP_COMM_HEAPSZ=256000

B. Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000

C. As the db2 instance owner (db2inst1) execute the command:db2set 璱 DB2_FMP_COMM_HEAPSZ=256000

D. As the db2 instance owner (db2inst1)execute the command:db2set 璱 db2inst1 DB2_FMP_COMM_HEAPSZ=256000

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

A. LBAC protection can be applied to a nickname

B. LBAC cannot be used to restrict access to a staging table

C. LBAC cannot be used to restrict access to data of columns and rows in the same table

D. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

Which of the following are all valid types of trigger?

A. AFTER, ATOMIC, BEFORE

B. AFTER, ATOMIC, INSTEAD OF

C. AFTER, BEFORE, INSTEAD OF

D. ATOMIC, BEFORE, INSTEAD OF

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

A. CONNECT TO mydbPRUNE HISTORY TO /outdir

B. db2trc on –db mydb –m “backup,load”run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off

C. BACKUP DATABASE mydb NO TABLESPACE TO /outdir

D. db2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump