IBM DB2 10.1 DBA for Linux, UNIX, and Windows - 000-611 Exam Practice Test

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

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

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

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

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

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

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

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

A. SYSADM

B. DBADM

C. SQLADM

D. SECADM

A. To recommend physical changes to objects in a database.

B. To recommend database configuration parameter changes.

C. To generate query definitions required to create usage reports.

D. To generate profiles for autonomic activity within the database.

A. It cannot be accomplished without scanning the associated table.

B. It can be accomplished by sampling the index.

C. It requires a full index scan.

D. It must be executed against all indexes for the table.

A. DB2_ENABLE_AUTOCONFIG_DEFAULT

B. DB2_INDEX_DEFAULT

C. DB2_EXTENDED_OPTIMIZATION

D. DB2_INDEX_PCTFREE_DEFAULT

A. Remote

B. Server

C. Cascaded

D. Local

E. Client

A. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.

B. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.

C. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.

D. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.

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 IN DATABASE option and specify the set of tablespaces that are needed.

C. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.

D. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN IMAGE option and specify the set of table spacesthat are needed.