Ensurepass.com : Ensure you pass the IT Exams
2018 Jan 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: 61 – (Topic 2)

A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed to establish the specified connections?

  1. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, and nicknames for all databases.

  2. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, and nicknames for all databases.

  3. 3 Oracle servers, 1 Oracle wrapper, 2 SQL Server servers, 1 SQL Server wrapper, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.

  4. 3 Oracle servers, 3 Oracle wrappers, 2 SQL Server servers, 2 SQL Server wrappers, 1 DB2 server, 1 DB2 wrapper, and nicknames for all databases.

Answer: C

Question No: 62 – (Topic 2)

Which is NOT a valid method for prefetching data?

  1. Smart data prefetching

  2. Read-ahead prefetching

  3. Consecutive prefetching

  4. Sequential detection prefetching

Answer: C

Question No: 63 – (Topic 2)

Which item is NOT eligible for adaptive compression?

  1. Indexes

  2. Base tables

  3. Temporary tables

  4. Inline LOB values

Answer: C

Question No: 64 – (Topic 2)

The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for optimal query performance?

  1. CREATE INDEX salary_bonus_idx ON employee (salary, bonus)

  2. CREATE INDEX bonus_salary_idx ON employee (bonus, salary)

  3. CREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER

  4. CREATE INDEX salary_bonus_idx ON employee (salary, bonus) CLUSTER

Answer: C

Question No: 65 – (Topic 2)

A table named MYTAB was created as follows:

Ensurepass 2018 PDF and VCE

How many rows will be inserted into the MYTAB table?

  1. 4

  2. 8

  3. 11

  4. 12

Answer: B

Question No: 66 – (Topic 2)

Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis: db2_all quot;lt;lt;-1lt; db2 BACKUP DATABASE sales TO /mnt/backupquot; Which command can now be used to perform the same backup operation?

  1. BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup

  2. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup

  3. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup

  4. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup

Answer: D

Question No: 67 – (Topic 2)

The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?

  1. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)

  2. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)

  3. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)

  4. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)

Answer: D

Question No: 68 – (Topic 2)

If the following commands complete successfully for a single partition database: CREATE DATABASE mydb; CREATE BUFFERPOOL mybp; Which statement is true?

  1. Self tuning is enabled for the MYBP buffer pool.

  2. The initial size for the MYBP buffer pool is zero pages.

  3. The database has to be restarted before the MYBP buffer pool will become active.

  4. The page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL statement.

Answer: A

Question No: 69 – (Topic 2)

Which table function can be used to determine whether all of a particular table space data objects have been moved from one storage group toWhich table function can be used to determine whether all of a particular table space? data objects have been moved from one storage group to another?

  1. MON_GET_TABLESPACE

  2. ADMIN_GET_STOGROUP_INFO

  3. ADMIN_GET_STORAGE_PATHS

  4. MON_GET_REBALANCE_STATUS

Answer: D

Question No: 70 – (Topic 2)

Which statement about Range-Clustered Tables (RCTs) is correct?

  1. More logging is required compared to similarly-sized regular tables.

  2. More buffer pool memory is required to store the table#39;s B index structure.

  3. Space is pre-allocated and reserved for use by the table even when records do not yet exist.

  4. More maintenance is required since indexes must be updated after every insert, update, or delete operation.

Answer: C

100% Ensurepass Free Download!
Download Free Demo:C2090-614 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-614 Dumps

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.