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

1. An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?

A) Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.
B) Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted.
C) Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.
D) Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.

2. Which is the suggested way to restore a database with a subset of its original table spaces?

A) Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.
B) Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.
C) Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN IMAGE option and specify the set of table spacesthat are needed.
D) Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN DATABASE option and specify the set of tablespaces that are needed.

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 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.

5. If the following command is executed:

Which statement is true?

A) If using a remote database connection, the file "/mnt/datafile.del" must be accessible to the database server host.
B) Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.
C) While the Load is executing, other transactions can both read and write into table SCHEMA6.T1
D) Rejected records will be inserted into the table SCHEMA2.E1

質問と回答：