최신 DB2 C2090-614 무료샘플문제:

1. What is the default user workload class that is created for each database table?

A) SYSDEFAULTUSERWORKLOAD
B) SYS_DEFAULT_USER_WORKLOAD
C) SYSUSERDEFAULTWLM
D) DEFAULT_USER

2. Which monitoring tool can be used to find out how many data pages have been read from the table space containers for regular, large, and temporary table spaces?

A) The MON_BP_UTILIZATION administrative view.
B) The MON_DB_SUMMARY administrative view.
C) The MON_GET_EXTENT_MOVEMENT_STATUS table function.
D) The MON_GET_ACTIVITY_DETAILS table function.

3. Which tool provides the simplest method for monitoring buffer pool hit ratios?

A) The MON_GET_BUFFERPOOL table function.
B) The BP_HITRATIO administrative view.
C) The BP_WRITE_IO administrative view.
D) The MON_GET_PAGE_ACCESS_INFO table function.

4. Where is the HADR_TARGET_LIST configuration parameter set?

A) On the tertiary standby databases.
B) On the primary database only.
C) On the auxiliary standby databases only.
D) On all participating databases.

5. Which statement about the initiation of parallel I/O is correct?

A) For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
B) For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
C) For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
D) For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.

질문과 대답: