DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (C2090-546) Free Practice Test

Question 1

Which two database manager configuration parameters were added to support encryption? (Choose two.)

A. SSL_CLIENT_KEYDB

B. SSL_CLNT_STASH

C. SSL_CLIENT_KEYSTASH

D. SSL_CLNT_KEYDB

E. SSL_CLIENT_STASH

Correct Answer: B,D

Question 2

Which SQL statement must be executed in order to give a user named USER1 the ability to query the system catalog tables and views?

A. GRANT SQLADM ON DATABASE TO user1

B. GRANT DATAACCESS ON DATABASE TO user1

C. GRANT ACCESSCTRL ON DATABASE TO user1

D. GRANT WLMADM ON DATABASE TO user1

Correct Answer: B

Question 3

Which db2val option will create a log file?

A. -f

B. -l

C. -r

D. -o

Correct Answer: B

Question 4

What is the correct setting for the DIAGSIZE database manager configuration parameter to limit the total size of the db2diag.log and <instance>.nfy files to 60 MB and use 10 rotating files for db2diag.log and 10 for <instance>.nfy?

A. DIAGSIZE=60

B. DIAGSIZE=10,60

C. DIAGSIZE=6

D. DIAGSIZE=60,10

Correct Answer: A

Question 5

Which two authorities can grant SELECT privilege on a table? (Choose two.)

A. SECADM authority on the database.

B. DATAACCESS authority on the database.

C. ACCESSCTRL authority on the database.

D. SYSADM authority on the instance.

E. DBADM authority on the database.

Correct Answer: A,C

Question 6

Which is true regarding collecting distribution statistics for XML data?

A. XML distribution statistics are collected for indexes over XML data of type VARCHAR HASHED.

B. XML distribution statistics are collected for partitioned indexes over XML data defined on a data partitioned table.

C. XML distribution statistics are collected when collecting index statistics during index creation.

D. XML distribution statistics are collected for indexes over XML data of type VARCHAR.

Correct Answer: D

Question 7

The SALES database was created without AUTOMATIC STORAGE. If the following command is executed: ALTER DATABASE sales ADD STORAGE ON '/db2fs1', '/db2fs2' What is the expected result?

A. The SALES database and all its table spaces are converted to AUTOMATIC STORAGE.

B. The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, existing table spaces need to be dropped and recreated.

C. The SALES database is converted to AUTOMATIC STORAGE and all its existing DMS table spaces are in rebalance pending state.

D. The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, ALTER TABLESPACE statement is needed to convert existing table spaces.

Correct Answer: D

Question 8

Which function/stored procedure CANNOT be used to view audit facility data?

A. SYSPROC.AUDIT_AUTH

B. SYSPROC.AUDIT_DELIM_EXTRACT

C. SYSPROAUDIT_LIST_LOGS

D. SYSPROC.AUDIT_ARCHIVE

Correct Answer: A

Welcome to TestSimulate

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (C2090-546) Free Practice Test