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

1. Which is a valid statement about the Row and Column Access Control (RCAC) feature?

A) RCAC is a more powerful security mechanism than Label Based Access Control (LBAC).
B) Users with SECADM authority are exempt from RCAC rules.
C) The RCAC feature uses a subset of Label Based Access Control (LBAC) functionality.
D) When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are returned.

2. What authority is required to grant a user ACCESSCTRL authority?

A) DBADM
B) SQLADM
C) DATAACCESS
D) SECADM

3. Table TAB_A resides within table space TBSP_1.

Which statement is correct?

A) The indexes for TAB_A will not be completely rebuilt because the INCREMENTAL indexing mode is used. Instead, new index keys will beappended to the original indexes. This will improve concurrency for the applications that are reading TAB_A during the LOAD operation.
B) A flash copy of TAB_A will be made at the beginning of the LOAD because of the COPY YES option. This copy allows applications to read thedata that existed in the table prior to the LOAD operation and improves performance since the read operations will not collide with the LOAD.
C) The indexes for TAB_A will be copied at the beginning of the LOAD operation because of the COPY YES option. Since the indexes will also bebuilt using the INCREMENTAL indexing mode, the concurrency of table TAB_A will be maximized for any applications that wish to access thetable.
D) TAB_A is a table that has implicitly hidden columns and the file DEL_FILE contains data for both regular columns and hidden columns. Whilenew data is being loaded into TAB_A, applications will be able to read the data that existed prior to the LOAD operation.

4. Which command can be used to restore a corrupted database using only the recovery history file?

A) RECOVER DATABASE
B) RESTORE DATABASE
C) RESTART DATABASE
D) ROLLFORWARD DATABASE

5. Which statement about the ADMIN_MOVE_TABLE procedure is true?

A) If the ADMIN_MOVE_TABLE procedure is invoked with the KEEP option specified, the active (source) table will be kept and if the target table isto be created automatically, a name that is different from that of the active table must be specified for the target table.
B) If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, thetarget table is renamed (to the source table name) once the data has been copied into the target table.
C) The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operationto the target table.
D) The ADMIN_MOVE_TABLE procedure stores all changes that occur to data in the active (source) table during the move to a user-suppliedstaging table so they can be replayed against the target table when the move is complete.

質問と回答：