Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-614
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-614.html

DB2 10.1 Advanced DBA for Linux UNIX and Windows

Question No: 11 – (Topic 1)

Which Range-Clustered Tables (RCT) statement is correct?

  1. Reverse scans on RCTs are not supported.

  2. Clustering indexes are compatible with RCTs.

  3. The Design Advisor can recommend the use of RCTs.

  4. The IMPORT utility can be used with the REPLACE option to populate RCTs.

Answer: A

Question No: 12 – (Topic 1)

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?

  1. The MON_DB_SUMMARY administrative view.

  2. The MON_BP_UTILIZATION administrative view.

  3. The MON_GET_ACTIVITY_DETAILS table function.

  4. The MON_GET_EXTENT_MOVEMENT_STATUS table function.

Answer: B

Question No: 13 – (Topic 1)

Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?

  1. One composite block index and one unique index.

  2. One composite clustering index and one dimension block index.

  3. One index that serves as both the dimension block index and the composite block index.

  4. One index that serves as both the dimension block index and the composite clustering index.

Answer: C

Question No: 14 – (Topic 1)

A DBA wants to create a table named SALES that has the following characteristics:

-> Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21.

-> Data for the second half of the year will reside in table space TBSP2; the index for

this data will reside in table space TBSP22.

Which clause must be used with the CREATE TABLE statement to define this table?

  1. DISTRIBUTE BY HASH

  2. PARTITION BY RANGE

  3. ORGANIZE BY DIMENSIONS

  4. ORGANIZE BY KEY SEQUENCE

Answer: B

Question No: 15 – (Topic 1)

Which statement about partitioned indexes is FALSE?

  1. Both system- and user-generated indexes can be partitioned.

  2. Each index partition contains references only to data in its corresponding data partition.

  3. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition

  4. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the

corresponding partition index.

Answer: D

Question No: 16 – (Topic 1)

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

  1. Table space available space

  2. Table space read and write activity

  3. Table space container assignments

  4. Table level activity within a table space

  5. Table space backup and recovery information

Answer: A,B

Question No: 17 – (Topic 1)

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

  1. For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.

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

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

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

Answer: C

Question No: 18 – (Topic 1)

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

  1. It will backup just the catalog partition.

  2. It will backup all partitions simultaneously.

  3. It will backup just the partition that the command is executed from.

  4. It will backup just the partitions that reside on the host that the command is executed from.

Answer: C

Question No: 19 – (Topic 1)

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

  1. DEFAULT_USER

  2. SYSUSERDEFAULTWLM

  3. SYSDEFAULTUSERWORKLOAD

  4. SYS_DEFAULT_USER_WORKLOAD

Answer: C

Question No: 20 – (Topic 1)

Which diagnostic tool can be used to collect metrics on individual SQL statement executions?

  1. db2dart

  2. A snapshot monitor

  3. A statement event monitor

  4. The MON_GET_UNIT_OF_WORK_DETAILS table function

Answer: C

100% Ensurepass Free Download!
Download Free Demo:C2090-614 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-614 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE