IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows 認定 A2090-541 試験問題:

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

A) snapshot
B) service class
C) alert
D) threshold
E) workload

2. If a non-recoverable database crashes, how can a DBA successfully restart the database if a table space is damaged and cannot complete crash recovery?

A) The damaged table space will require that the entire database be restored from the latest backup image because the database is non-recoverable and will not be accessible.
B) The damaged table space must be restored from the latest backup and any active transaction logs in the log path can then be applied to it using the TABLESPACE ONLINE option of the ROLLFORWARD DATABASE command. This will bring the table space on-line and synchronize it with the rest of the database.
C) The database must be restarted using the RESTART DATABASE command with the DROP PENDING TABLESPACES option specified. At that point, the database can be brought on-line and the damaged table space must be dropped and re-created.
D) The damaged table space must be restored from the latest backup image. Once restored from the backup image, the RESTART DATABASE command can be issued to apply all the relevant transactions from the active logs. At that point, the database will come on-line and all table spaces will be synchronized.

3. What are three authorization categories in DB2? (Choose three.)

A) Object-level
B) Instance-level
C) Database-level
D) System-level
E) Network-level

4. Click the Exhibit button.

IBM 000-541: Practice Exam
Given the TCP/IP configuration shown in the exhibit, to what must the alternate server be set on the Primary, to allow Automatic Client Reroute to connect to the Standby after a HADR takeover?

A) 192.168.1.102
B) 192.168.2.1
C) 192.168.2.102
D) 192.168.1.1

5. Which statement is true about using the EXPORT utility with a table that contains XML data?

A) By default, XML documents will be written to the same file that contains the relational data exported unless the XMLFILE option is used.
B) By default, XML documents are written to a single, separate file, which is stored in the same location as the file that contains the relational data exported.
C) If the table being exported does not contain well-formed XML documents, the XMLSAVESCHEMA option must be provided with the EXPORT command used.
D) If you are exporting XML documents that are greater than 32 Kb in size, you must use the XMLINSEPFILES modifier to avoid truncation.

質問と回答：