Assessment: DB2 9.7 Advanced DBA for LUW - Assessment: A2090-544

Which conditions must be met to implement HADR?

A. Operating systems on primary and standby servers must be the same; DB2 versions need not be the

same; and the databases must have the same bit-size (32 or 64 bit).

B. Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

C. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

D. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).

At which two levels can events be audited? (Choose two.)

A. Instance level

B. Database level

C. Server level

D. Operating System level

E. Node level

A database named MYDB was created by executing the following command: CREATE DATABASE mydb AUTOMATIC STORAGE NO Later, a decision is made to modify this database so that both it and its table spaces use automatic storage. What steps are required to make this modification?

A. Use the ALTER DATABASE command to convert the database; all existing table spaces will be converted automatically.

B. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing table spaces.

C. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing SMS table spaces.

D. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing DMS table spaces.