IBM IBM Certifications C2090-600 Questions & Answers

• Question 41:

  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;

  Correct Answer: C

• Question 42:

  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

  Correct Answer: B

• Question 43:

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

  A. db2cluster –cfs –list –filesystem datafs

  B. db2cluster –cfs –display –filesystem datafs

  C. db2cluster –cfs –listconfig –filesystem datafs

  D. db2cluster –cfs –displayconfig –filesystem datafs

  Correct Answer: A

• Question 44:

  Which options are valid for an online reorganization operation?

  A. FULL and RECLAIM EXTENTS

  B. CLASSIC and RECLAIM EXTENTS

  C. FULL and CLEANUP OVERFLOWS

  D. CLEAN OVERFLOWS and RECLAIM EXTENTS

  Correct Answer: A

• Question 45:

  For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)

  A. XML

  B. BLOB

  C. CLOB

  D. VARCHAR

  E. DATETIME

  Correct Answer: DE

• Question 46:

  Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

  A. Select from the ADMIN_GET_ENCRYPTION_INFO table function

  B. Run the db2ckbkp command and verify the compression settings

  C. Checkthe encrypted database parameter in database configuration

  D. Check ENCROPTS database configuration parameter for encryption options

  Correct Answer: D

• Question 47:

  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

  Correct Answer: AC

• Question 48:

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

  A. DB2memory sets

  B. the db2diag.log file

  C. Monitoring table functions

  D. A set of pre-defined event monitors

  Correct Answer: A

• Question 49:

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

  A. db2look

  B. db2advis

  C. db2expln

  D. db2exfmt

  Correct Answer: C

• Question 50:

  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?

  A. The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.

  B. Once the first QUIESCE completes, there are no runningtransactions involving tab1, but there might be running transactions against other tables in TS1.

  C. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. There might besome uncommitted data in TS1.

  D. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. This ensures none of the application changes were applied.

  Correct Answer: D