IBM DB2 11.1 DBA for LUW (C2090-600) Free Practice Test

Question 1

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

A. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.

B. The INTRA_PARALLEL database manager configuration parameter is set to NO.

C. The DFT_EXTENT_SZ database configuration parameter is set to 8.

D. The AUTO_REORG database configuration parameter is set to NO.

E. The PAGESIZE database configuration parameter is set to 32K.

Correct Answer: A,B

Question 2

What is the default value of the DB2 registry variable DB2LDAP SEARCH_SCOPE?

A. NONE

B. DOMAIN

C. LOCAL

D. GLOBAL

Correct Answer: D

Question 3

Which statement about Data Server Manager (DSM) is TRUE?

A. DSM can be used for configuration management of DB2 Data Server drivers

B. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue

C. DSM cannot be used for database administration

D. DSM can be used for reviewing audit trails

Correct Answer: B

Question 4

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

A. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT

B. Set the DB2COMM registry variable to DB2COMM=SSL

C. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

D. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP

Correct Answer: D

Question 5

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 -display -filesystem datafs

B. db2cluster -cfs -listconfig -filesystem datafs

C. db2cluster -cfs -displayconfig -filesystem datafs

D. db2cluster -cfs -list -filesystem datafs

Correct Answer: D

Question 6

Which of the following statements is TRUE?

A. REORGCHK automatically run stables reorganization.

B. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.

C. REORGCHK uses only current table and index statistics.

D. REORGCHK can only be used for user tables, not for system tables.

Correct Answer: C

Welcome to TestSimulate