Online Access Free 000-611 Practice Test

Which statement is correct when describing trusted contexts?

• A.A trusted context defines a trust relationship for a connection between the database and an external entity.
• B.A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.
• C.A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.
• D.A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.

How can you remove all effects of compression from an index?

• A.Execute the ALTER INDEX statement to turn compression off.
• B.Execute the ALTER TABLE statement to turn compression off; then execute the RUNSTATS command to tell the DB2 optimizer thatcompression is no longer used.
• C.Execute the ALTER TABLE statement to turn compression off.
• D.Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to removed the compression dictionary.

What is an informational constraint?

• A.A constraint that provides Information to the RUNSTATS utility.
• B.A constraint that is used by the optimizer but is not enforced.
• C.A constraint that is created from information supplied to the design advisor.
• D.A constraint that defines a relationship to a federated object.

Which statement is NOT true about a database restore operation?

• A.A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.
• B.A table space restore operation must be done offline.
• C.A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.
• D.A table space is not usable until the restore operation completes successfully.

What is the purpose of the Design Advisor?

• A.To recommend physical changes to objects in a database.
• B.To generate query definitions required to create usage reports.
• C.To recommend database configuration parameter changes.
• D.To generate profiles for autonomic activity within the database.