最新的IBM 000-541免費考試真題

問題1

Click the Exhibit button.

IBM 000-541: Practice Exam
Referring to the exhibit, which security mechanism would be used to authenticate a remote user running a db2trc command?

A. CLIENT authentication

B. GSS-APIplugin "db2trc"

C. CLIENT_ENCRYPT authentication

D. SERVER ENCRYPT authentication

正確答案: D

問題2

Because of an application abend, a database named PAYROLL needs to be restored to approximately 9:26 am on June 1, 2009. After the database is restored from a backup image, the command shown below is executed: ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP
When this command is executed, the error shown below is generated:
SQL4970N Roll-forward recovery on database "PAYROLL" cannot reach the specified stop point (end-of-log or point-in-time) because of missing log file(s) on node(s) "0".
Which two commands could be used to resolve this error? (Choose two.)

A. ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP

B. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOP

C. ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP NORETRIEVE MISSING RECORDS

D. ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP OVERFLOW LOG PATH /mnt/arclog

正確答案: B,D

問題3

What are three implementations for DB2 Workload Management? (Choose three.)

A. alert

B. workload

C. snapshot

D. service class

E. threshold

正確答案: B,D,E

問題4

Click the Exhibit button.

Refer to the logging configuration parameters shown in the exhibit.
If the active log path was only configured to have enough space for 100 active log files, what will happen if there are currently 100 active log files and DB2 needs to create active log file 101?

A. The database will continue normal operation because infinite logging has been enabled and any logs that will not fit in the active log path will automatically be created within the OVERFLOWLOGPATH until logs in the active log path begin to be archived.

B. The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log path is full. The transaction will be rolled back andit's associated application will be forced off.

C. The database will appear to be hung because the BLK_LOG_DSK_FUL configuration parameter is set to YES. Once some active log files arearchived,the database will resume normal operation.

D. The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log space and active log path are both full. The transaction will be rolled back andit's associated application will be forced off.

正確答案: C

問題5

When using table partitioning, which three operations are valid? (Choose three.)

A. ATTACH partition

B. DETACH partition

C. DROP partition

D. REORG all partitions

E. partition level REORG

正確答案: A,B,E

問題6

Which statement is correct about informational constraints?

A. The database manager uses an informational constraint to enforce the uniqueness of the key during changes to the columns of the unique constraint.

B. An informational constraint is a column or combination of columns that has the same properties as a unique constraint.

C. An informational constraint can be used by the SQL compiler to improve the access to data and query performance.

D. An informational constraint specifies that every row that is inserted or updated in the table must conform to the definition of the table.

正確答案: C

問題7

Which DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables, and dynamic SQL?

A. db2fodc

B. db2top

C. db2dart

D. db2pm

正確答案: B

問題8

Which set of procedures will be required to perform a rolling upgrade in a HADR environment?

A. 1. Upgrade the system where the standby database resides.
2.Issue the TAKEOVER HADR command on the primary database server.
3.Upgrade the original primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.

B. 1. Upgrade the system where the primary database resides.
2.Issue the TAKEOVER HADR command on the primary database server.
3.Upgrade the new primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.

C. 1. Upgrade the system where the standby database resides.
2.Issue the TAKEOVER HADR command on the standby database server.
3.Upgrade the original primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.

D. 1. Upgrade the system where the primary database resides.
2.Issue the TAKEOVER HADR command on the primary database server.
3.Upgrade the original primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.

正確答案: C

問題9

Which list of automatic maintenance parameters can have a policy defined to specify their automatic behavior?

A. AUTO_DB_BACKUP, AUTO_RUNSTATS, AUTO_REORG

B. AUTO_STMT_STATS, AUTO_DB_BACKUP, AUTO_RUNSTATS, AUTO_REORG

C. AUTO_RUNSTATS, AUTO_REORG, AUT0_STMT_STATS

D. AUTO_RUNSTATS, AUTO_STMT_STATS, AUTO_DB_BACKUP

正確答案: A

最新的IBM DB2 9.7 DBA for Linux UNIX and Windows - 000-541免費考試真題

聯系我們

站內鏈接

最新更新