IBM A2090-611 問題集

質問 1：
Which High Availability Disaster Recovery (HADR) synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?
A. SUPERASYNC (super asynchronous)
B. SYNC (synchronous)
C. ASYNC (asynchronous)
D. NEARSYNC (near synchronous)
正解：A

質問 2：
Which statement is true regarding the workload management dispatcher?
A. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.
B. The workload management dispatcher monitors work performed by entities executing in the DB2 system service class.
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 non-DB2 work performed in fenced mode processes such as fenced stored procedures.
正解：A

質問 3：
If the following command is executed:
CREATE DATABASE sample RESTRICTIVE
Which statement is true?
A. No authorities or privileges will be granted to PUBLIC.
B. Only the creator is allowed to access the SAMPLE database.
C. PUBLIC will hold only SELECT privilege on the system catalog views.
D. The RESTRICT_ACCESS database configuration parameter must be set to YES by the creator.
正解：A

質問 4：
Which statement about the ADMIN_MOVE_TABLE procedure is true?
A. 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.
B. 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.
C. 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.
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.
正解：A

質問 5：
Which statement about BEFORE triggers is FALSE?
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's action is executed for each row in the set of affected rows instead of executing the trigger event.
C. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.
D. 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.
正解：B

質問 6：
What are two types of DB2 Discovery requests that a client can make? (Choose two.)
A. LOOKUP
B. KNOWN
C. SEARCH
D. TRUSTED
E. UNTRUSTED
正解：B,C

質問 7：
If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?
A. Roll-forward recovery
B. Version recovery
C. Disaster recovery
D. Crash recovery
正解：D

質問 8：
Which registry variable should be used to specify that 20 percent of each index page is to be left as as free space when building any index in any database?
A. DB2_INDEX_PCTFREE_DEFAULT
B. DB2_EXTENDED_OPTIMIZATION
C. DB2_INDEX_DEFAULT
D. DB2_ENABLE_AUTOCONFIG_DEFAULT
正解：A