Assessment: DB2 9.7 Advanced DBA for LUW (A2090-544) Free Practice Test

Question 1

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

A. EXECUTE privilege on audit routines with NO DATA

B. DBADM authority

C. SECADM authority

D. EXECUTE privilege on audit routines with DATA

E. SYSADM authority

Correct Answer: C,D

Question 2

A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?

A. Configuration Advisor

B. Partition Assistant

C. Workload Manager

D. Design Advisor

Correct Answer: D

Question 3

A Windows user with a local database is not able to connect to a zOS database. The System Database Directory and the Node Directory have the correct entries. Other users can connect to the database from their workstations without problems. What should be done resolve the problem?

A. Catalog the zOS database in the Local Database Directory.

B. Catalog the zOS database in the Distributed Data Facility Directory.

C. Uncatalog and re-catalog the directory entries for the zOS database and try again.

D. Catalog the zOS database in the Database Connection Services Directory.

Correct Answer: D

Question 4

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. INDEXSCAN

B. VOLATILE

C. CURRENT CARDINALITY

D. CARDINALITY VOLATILE

Correct Answer: B

Question 5

What determines the degree of inter-partition parallelism used?

A. The value of the DFT_DEGREE database configuration parameter.

B. The value of the INTER_PARALLEL Database Manager configuration parameter.

C. The number of database partitions and the definition of partition groups.

D. The number of database connections and the definition of partitions groups.

Correct Answer: C

Question 6

Given a newly created database and sufficient memory. If the following statements are successful: CREATE BUFFERPOOL bp1 SIZE 40MB; CREATE BUFFERPOOL bp2 PAGESIZE 16K SIZE 40000; How much memory will be allocated for buffer pools BP1 and BP2?

A. 80MB

B. 40MB

C. 680MB

D. 665MB

Correct Answer: D

Welcome to TestSimulate

IBM Assessment: DB2 9.7 Advanced DBA for LUW (A2090-544) Free Practice Test