Online Access Free A2090-544 Practice Test

What determines the degree of inter-partition parallelism used?

• A.The value of the DFT_DEGREE database configuration parameter.
• B.The number of database connections and the definition of partitions groups.
• C.The value of the INTER_PARALLEL Database Manager configuration parameter.
• D.The number of database partitions and the definition of partition groups.

Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?

• A.Non-fenced routines can be invoked, however automatic database maintenance will be disabled.
• B.In a partitioned environment, infinite communications will be enabled between partitions.
• C.In a partitioned environment, communications will not be buffered.
• D.User-defined function calls will be disabled.

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; use the ALTER TABLESPACE command to convert all existing SMS table spaces.
• B.Use the ALTER DATABASE command to convert the database; all existing table spaces will be converted automatically.
• C.Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing DMS table spaces.
• D.Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing table spaces.

Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?

• A.RELEASE FREE EXTENTS ONLY
• B.RECLAIM FREE BLOCKS
• C.RECLAIM EXTENTS ONLY
• D.RELEASE FREE BLOCKS ONLY

Which conditions must be met to implement HADR?

• A.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).
• B.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).
• C.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).
• D.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).