DB2 9 DBA for Linux UNIX and Windows
Questions, Answers, Braindumps (000-731)
Thanx to www.examscheets.com for providing helpful
material.Here is my contribution.
Which of the following event monitor types is defined
and active for all by default?
A Database administrator needs to benchmark a database
for both SQL and XQUERY. What utility can be used
to accomplish this task?
Which of the following TWO commands will apply AUTOCONFIGURE
recommended changes to buffer pools?
A. AUTOCONFIGURE USING <options> APPLY NONE
B. AUTOCONFIGURE USING <options> APPLY DB ONLY
C. AUTOCONFIGURE USING <options> APPLY db AND
D. AUTOCONFIGURE USING <options. APPLY BUFFERPOOLS
E. AUTOCONFIGURE USING <options> APPLY DB AND
Which of the following settings would allow 20 sorts
with a maximum of 10MB each to run currently on a
A. Set the DB SHEAPTHERS to 50000 and DB SORTHEAP
B. Set the DBM SHEAPTHERES to 50000 and DB SORTHEAP
C. Set the DBM SHEAPTHERS to 50000 and DBM SORTHEAP
D. Set the DBM SHEAPTHERS_SHR to 50000 and DBM SHEAPTHRES
Which of the following is the most complete list of
methods by which the EXPORT utility can be invoked?
A. Control Center and the CLP
B. Control Center, CLI and the CLP
C. Control Center, CLP and the ADMIN_CMD stored procedures
D. Control Center, CLI,CLP and ADMIN_CMD stored procedures
Which of the following authorities should a user have
in order to QUIESCE the DB2 instance?
A Database administrator has HADR enabled and wants
to do a LOAD WITH COPY NO option on the primary server.
What happens on the standby server?
A. The Load is replicated without problems
B. The Load will stop with an appropriate error message
C. The Load will be automatically converted to NONRECOVERABLE
and the standby database will be marked bad
D. The Load will be automatically converted to COPY
YES if the directory or device specified on the primary
server is accessible for the standby database
A Recovery of database DB1 is started by issuing RECOVERY
DATABSE DB1 TO END Of LOGS. The Recovery fails during
the rollforward phase. In order to continue the recovery
from the point of failure, which of the following
commands should be executed?
A. RECOVER DATABASE DB1 TO RESTART
B. RECOVER DATABSAE DB1 TO END OF LOGS
C. RECOVER DATABSAE DB1 TO END OF LOGS RESTART
D. RECOVER DATABSAE DB1 CONTINUE TO END OF LOGS