Free IBM A2090-614 Exam Dumps Questions & Answers

For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE command?

• A.  It will backup just the partition that the command is executed from.
• B.  It will backup just the partitions that reside on the host that the command is executed from.
• C.  It will backup just the catalog partition.
• D.  It will backup all partitions simultaneously.

What values can be assigned to the HADR_SYNCMODE configuration parameter?

• A.  SYNC, NOSYNC, ASYNC, and SUPERASYNC
• B.  SYNC, NEARSYNC, ASYNC, and SUPERASYNC
• C.  SYNC, ASYNC, SEMISYNC, and SUPERASYNC
• D.  SYNC, NEARSYNC, ASYNC, and NOSYNC

A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?

• A.  ORGANIZE BY INSERT TIME
• B.  ORGANIZE BY DIMENSIONS
• C.  ORGANIZE BY TIME PERIOD
• D.  ORGANIZE BY KEY SEQUENCE

What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)

• A.  Table space available space
• B.  Table space backup and recovery information
• C.  Table space container assignments
• D.  Table level activity within a table space
• E.  Table space read and write activity

If a large amount of sequential prefetching is occurring, what can be done to improve efficiency?

• A.  Create indexes that encourage the optimizer to use index-only access.
• B.  Allocate a block-based area in the appropriate buffer pool.
• C.  Set NUMBLOCKPAGES to 0 in all buffer pools.
• D.  Set SEQDETECT to NO.