IBM DB2 10.1 DBA for Linux, UNIX, and Windows 認定 C2090-611 試験問題:

1. If the following statements are executed in the order shown:

Which statement is true?

A) Insert, update, and delete operations performed against table TAB1 are automatically cascaded to table TAB2.
B) The REFRESH TABLE statement must be executed before insert, update, and delete operations performed against table TAB1 will be seen intable TAB2.
C) Data stored in table TAB1 is automatically copied to table TAB2 immediately after table TAB2 is created.
D) Insert, update, and delete operations can be performed against table TAB2.

2. Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?

A) REPLICATION
B) INGEST
C) LOAD WITH READ ACCESS
D) IMPORT WITH BUFFERED INSERT

3. Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)

A) CLIENT
B) SERVER
C) KERBEROS_PLUGIN
D) LDAP_PLUGIN
E) DATA_ENCRYPT

4. Which statement about the db2pd tool is true?

A) It collects information from the snapshot monitor and a predefined set of event monitors.
B) It collects information from the log buffer and active log files.
C) It may retrieve data that is not completely accurate.
D) It ensures that information is not retrieved on changing data.

5. Which statement is correct when describing Range Clustered Tables (RCT) as compared to regular base tables that use at least one index?

A) RCTs require more logging, less buffer pool space, and more maintenance.
B) RCTs require more logging, more buffer pool space, and less maintenance.
C) RCTs require less logging, less buffer pool space, and less maintenance.
D) RCTs require less logging, more buffer pool space, and less maintenance.

質問と回答：