Online Access Free A2090-541 Practice Test

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

A database administrator created a new database from an existing full database backup image. If the original database resided on a 64-bit AIX server and the new database was created on a different 64-bit AIX server, which two statements are correct? (Choose two.)

• A.Incremental backups are not allowed until a non-incremental backup is taken.
• B.Incremental backup images for the original database can be used to restore the new database.
• C.Existing packages will be copied to the new database and can be used immediately.
• D.Existing SQL procedures must be dropped and re-created in the new database before they can be used

Click the Exhibit button.

IBM 000-541: Practice Exam
What is the result after executing the SELECT statement shown below?
SELECT COUNTO FROM applicant WHERE gender='C'

• A.4
• B.0
• C.3
• D.7

Which administrative authority is needed to run the audit stored procedures and table functions such as the AUDIT_DELIM_EXTRACT stored procedure?

• A.DBADM
• B.SECADM
• C.SQLADM
• D.SYS ADM

The event monitor for transactions has been replaced in DB2 9.7 with which tool?

• A.MON_GET_WORKLOAD table function
• B.MON_GET_ACTIVITY_DETAILS table function
• C.db2top
• D.db2evmonfmt