IBM IBM Certified Advanced Database Administrator A2090-544 Questions & Answers

• Question 21:

  What new security authorities have been introduced in DB2 V9.7?

  A. WLMADM, ACCESSCTRL, SECADMIN

  B. EXPLAIN, SECADMIN, DATAACCESS

  C. SECADMIN, ACCESSCTRL, SQLADM

  D. WLMADM, SQLADM, EXPLAIN

  Correct Answer: D

• Question 22:

  What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

  A. SECADM authority

  B. EXECUTE privilege on audit routines with DATA

  C. DBADM authority

  D. EXECUTE privilege on audit routines with NO DATA

  E. SYSADM authority

  Correct Answer: AB

• Question 23:

  What is the minimum authority required to execute the RUNSTATS command against a table?

  A. SYSMON

  B. SQLADM

  C. DATAACCESS

  D. SECADM

  Correct Answer: B

• Question 24:

  Which type of table queue is used to pass data between database partitions when rows are being fetched?

  A. asynchronous table queue

  B. synchronous table queue

  C. non-merging table queue

  D. listener table queue

  Correct Answer: A

• Question 25:

  Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?

  A. The ADMINGETTABCOMPRESSINFO table function.

  B. The ADMINGETTABCOMPRESSINFO_V97 table function.

  C. The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.

  D. The ADMIN_GET_TAB_INFO table function.

  Correct Answer: C

• Question 26:

  In which two environments would intra-partition parallelism be used? (Choose two.)

  A. Single database partition, single processor core

  B. Single database partition, multiple processor cores

  C. Multiple database partitions, single processor core

  D. Multiple database partitions, multiple processor cores

  Correct Answer: BD

• Question 27:

  Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility?

  A. UTIL_HEAP_SZ and STAT_HEAP_SZ

  B. LOAD_HEAP_SZ and DATABASE_MEMORY

  C. LOAD_HEAP_SZ and STAT_HEAP_SZ

  D. UTIL_HEAP_SZ and DATABASE_MEMORY

  Correct Answer: D

• Question 28:

  Which option of the ALTER TABLE statement tells the DB2 optimizer to use an index scan on a table that might vary in size at run time from being empty to containing a large number of rows?

  A. CARDINALITY VOLATILE

  B. INDEXSCAN

  C. VOLATILE

  D. CURRENT CARDINALITY

  Correct Answer: C

• Question 29:

  A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?

  A. Code the application to issue a LOCK TABLE statement.

  B. Code the application to issue a LOCK ROW statement.

  C. Increase the group commit count.

  D. Increase the size of the lock list.

  Correct Answer: A

• Question 30:

  Given a database with Self-Tuning Memory Manager (STMM) enabled, what will DB2 do when a new buffer pool is created using the IMMEDIATE option?

  A. Attempt to create the buffer pool and immediately request additional memory from the operating system to allocate. If the operating system memory is not available, the buffer pool will not be created.

  B. Attempt to create the buffer pool and immediately allocate the memory requested, resizing the existing buffer pools and heaps as required. If there is insufficient memory in the global memory allocation for DB2, the buffer pool will not be created.

  C. Attempt to create the buffer pool and immediately allocate the memory requested from available database shared memory. If the memory available is not sufficient, then allocation of the buffer pool will be deferred until the database is stopped and restarted.

  D. Attempt to create the buffer pool and immediately request additional instance level memory. If the instance level memory is not available, then creation of the buffer pool is deferred until the database is stopped and restarted.

  Correct Answer: C