IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 v7.0
Question 1
What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?
- A. The number of times an attempt to queue a column-organized prefetch request for temporary table spaces was made but failed.
- B. The number of times a temporary error occurred while trying to queue a column- organized prefetch request for a regular table space.
- C. The number of times DB2 had to retrieve a page from disk for a temporary column- organized table because the page no longer resided in the buffer pool.
- D. The number of times an asynchronous read request failed when attempting to read temporary column-organized data from the buffer pool after the page had been flushed to disk.
Answer : B
Question 2
When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?
- A. When crash recovery is occurring on the standby cluster.
- B. When all the log streams are in peer or assisted remote catchup state.
- C. When the primary database is not connected to the standby database.
- D. All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.
Answer : D
Question 3
Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?
- A. EHL is enabled by default in DB2 10.5 pureScale environments.
- B. There are three EHL states available: SHARED, DIRECT_ACCESS and NONSHARED.
- C. Only regular tables, temporary tables, and non-partitioned indexes can take advantage of EHL.
- D. EHL is designed to improve DB2 pureScale performance by avoiding CF communications for tables that are accessed from only one member.
Answer : A
Question 4
Which type of compression is NOT provided as part of the DB2 Storage Optimization
Feature?
- A. Row compression
- B. Index compression
- C. Backup compression
- D. Temporary table compression
Answer : C
Question 5
Which statement regarding NOT ENFORCED unique constraints is true?
- A. NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.
- B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data access plan.
- C. Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a unique index.
- D. When attempting to insert data that does not conform to the NOT ENFORCED unique constraint, an error will be returned and the record will not be inserted.
Answer : A
Question 6
When does space reclamation for a column-organized table normally occur?
- A. Whenever an individual row is deleted.
- B. Whenever an individual row is updated.
- C. After all rows in an extent have been updated.
- D. After all rows in an extent where updates took place have been deleted.
Answer : A
Question 7
Which command, when executed, will enable workload management for column-organized table workloads?
- A. db2setDB2_WORKLOAD=ANALYTICS
- B. db2set DB2_WLM_DISP_CONCUR=START
- C. UPDATE DBM CFG USING WLM_DISPATCHER YES
- D. UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL
Answer : C
Question 8
Which type of compression is typically used with column-organized tables?
- A. BLU compression
- B. Value compression
- C. Actionable compression
- D. Adaptive row compression
Answer : A
Question 9
By default, the Optim Workload Table Organization Advisor will recommend converting row-organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?
- A. 15 percent
- B. 20 percent
- C. 25 percent
- D. 30 percent
Answer : B
Question 10
What will cause the creation of a column-organized table to fail?
- A. Setting the database code set to UNICODE.
- B. Setting the DFT_DEGREE database configuration parameter to ANY.
- C. Setting the AUTO_RUNSTATS database configuration parameter to ON.
- D. Setting the UTILJHEAP_SZ database configuration parameter to at least 1.000,000 pages.
Answer : C
Question 11
When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width size for database tables?
- A. 32 KB
- B. 64 KB
- C. 1MB
- D. 2 MB
Answer : B
Question 12
How is the Query Workload Tuner license installed and enabled?
- A. With Data Studio, using the license activation kit.
- B. By executing the db2licm command after data server installation.
- C. With the Optim Performance Manager Server, using the license activation kit.
- D. By running the Query Workload Tuner license activation command on the appropriate WebSphere server.
Answer : A
Question 13
Which statement about expression-based indexes is true?
- A. The RUNSTATS command cannot be used to collect statistics for expression-based indexes.
- B. Expression-based indexes must always be defined as UNIQUE to prevent duplicate index keys.
- C. Expression-based index keys consist of a concatenation of one or more specified table columns.
- D. The index key values of expression-based indexes are not the same as the values in the corresponding table columns.
Answer : D
Question 14
If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two capabilities are available?
- A. Multi-tenancy
- B. Workload consolidation
- C. Independent tuning member
- D. Broadcasting STMM tuning decisions to all members
- E. Single INSTANCE_MEMORY instance configuration memory setting
Answer : D,E
Question 15
If the following commands are executed successfully:
Which SQL statement will fail?
- A. Option A
- B. Option B
- C. Option C
- D. Option D
Answer : C