A2090-611問題集、IBM実際の試験問題

質問 1

A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?

A. HSJOIN

B. NLJOIN

C. IXSCAN

D. TBSCAN

正解: C

質問 2

Which statement about the db2pd tool is true?

A. It may retrieve data that is not completely accurate.

B. It collects information from the log buffer and active log files.

C. It ensures that information is not retrieved on changing data.

D. It collects information from the snapshot monitor and a predefined set of event monitors.

正解: A

質問 3

What authority must be held to create a trusted context?

A. SQLADM

B. CONNECT

C. SECADM

D. DBADM

正解: C

質問 4

A user with SYSADM authority executes the following commands at host SERVER1:

Assuming the user ADMINISTRATOR exists, what could be causing the problem?

A. The userid should not be longer than eight characters.

B. The db2c_sample entry in the Windows Services File might not be assigned port number 50000.

C. The syntax of the CATALOG NODE command must contain a valid TCP/IP address.

D. The password for user ADMINISTRATOR is missing.

正解: B

質問 5

Given the following statement:

How many constraints are present in the DEPARTMENT table?

A. 3

B. 4

C. 1

D. 2

正解: B

質問 6

What is the FLUSH PACKAGE CACHE statement used for?

A. It saves dynamic SQL stored in the package cache to an external file.

B. To remove all cached static SQL statements from the package cache.

C. It causes all SQL statements in the package cache that are currently in use to be recompiled.

D. To remove all cached dynamic SQL statements from the package cache.

正解: D

質問 7

Which statement describes adaptive row compression?

A. Adaptive compression incorporates four compression approaches: tablespace-level, table-level, page-level, and bufferpool-level.

B. Adaptive compression incorporates both classic table-level row compression and page-by-page based row compression.

C. Adaptive compression allows for use of customized compression dictionary creation algorithms.

D. Adaptive compression maintains a dynamic and ever changing table-level row compression dictionary.

正解: B

質問 8

What are two types of security label components that can be used with Label-Based Access Control (LBAC)? (Choose two).

A. Group

B. Tree

C. Set

D. Range

E. Hierarchy

正解: B,C

質問 9

Which statement is true regarding the workload management dispatcher?

A. The workload management dispatcher monitors non-DB2 work performed in fenced mode processes such as fenced stored procedures.

B. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.

C. The workload management dispatcher monitors work performed by applications or middleware products that perform a portion of their workoutside of the DB2 database manager.

D. The workload management dispatcher monitors work performed by entities executing in the DB2 system service class.

正解: B

IBM Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows - A2090-611 模擬練習