DB2 9.7 DBA for Linux UNIX and Windows - 000-541 Exam Practice Test

Question 1

A DBA wants to use Label Based Access Control (LBAC) to protect Individual rows in a table. Which data type must be used to create a column to hold the necessary LBAC security data?

A. SYSIBM.DB2SECURITYLABEL

B. SYSIBM.DB2LBACLABEL

C. SYSPR0C.DB2SECURITYU\BEL

D. SYSPR0C.DB2LBACU\BEL

Correct Answer: A

Question 2

Click the Exhibit button.

Refer to the exhibit for information on how tables TABA and TABB were created. What would be the number of extents allocated for each table after the successful creation of both tables?

A. TABA: 1 extent TABB: 1 extent

B. TABA: 1 extent TABB: 10 extents

C. TABA: 2 extents TABB: 20 extents

D. TABA: 4 extents TABB: 40 extents

Correct Answer: D

Question 3

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

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

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

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

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

Correct Answer: D

Question 4

What are three default service classes used by Work Load Management? (Choose three.)

A. SYSDEFAULTSYSTEMCLASS

B. SYSDEFAULTWORKSET

C. SYSDEFAULTMAINTENANCECLASS

D. SYSDEFAULTSERVICECU\SS

E. SYSDEFAULTUSERCLASS

Correct Answer: A,C,E

Question 5

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

A. DETACH partition

B. REORG all partitions

C. partition level REORG

D. ATTACH partition

E. DROP partition

Correct Answer: A,C,D

Question 6

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

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

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

Correct Answer: D

Question 7

Which HADR feature minimizes the impact of software maintenance on the Standby server?

A. Configure AUTOMATIC maintenance and perform a roll forward.

B. Configure all AUTOMATIC maintenance parameters.

C. Configure AUTOMATIC maintenance and perform a rolling upgrade

D. Configure all AUTOMATIC features.

Correct Answer: C

Question 8

Click the Exhibit button.

IBM 000-541: Practice Exam
Refer to the logging configuration parameters shown in the exhibit.
What will happen if there are currently 100 active log files and DB2 needs to create log file 101?

A. Log file 101 will be successfully created in the primary log path since infinite logging has been enabled. Applications will continue processing normally.

B. At least one application will receive a "log full" error and at least one transaction will be rolled back because the active log space is full.

C. The database will appear to be hung since the active log space is full and the BLK_LOG_DSK_FUL parameter is set to YES.

D. Log file 101 will go into the OVERFLOWLOGPATH directory since the active log space is full and infinite logging has been enabled.

Correct Answer: A

Question 9

When are packages automatically rebound?

A. When invalid packages are executed.

B. When inoperative packages are executed.

C. When the DB2_AUTO_REBIND registry variable is set to YES.

D. When the DB2_AUTO_REBIND configuration parameter is set to ENABLED

Correct Answer: A

Question 10

When using Optim Database Administrator to generate a change script, users are given which two EXPORT utility output formats to preserve their data when they drop a table then create a new table with the data? (Choose two.)

A. WSF

B. IXF

C. DEL

D. CSV

Correct Answer: B,C

IBM DB2 9.7 DBA for Linux UNIX and Windows - 000-541 Exam Practice Test

Latest Update

Useful Links

Contact Us