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: 1 – (Topic 1)

Which table configuration CANNOT utilize multi-temperature storage?

  1. A range-partitioned table utilizing multiple table spaces that map to DMS containers.

  2. Multiple tables containing the same data at different ages placed into the same table space.

  3. Multiple tables containing the same data at different ages placed into separate table spaces.

  4. A range-partitioned table utilizing multiple table spaces that map to individual storage groups.

Answer: B

Question No: 2 – (Topic 1)

What will occur when a database administrator adds a new automatic storage path to an existing storage group?

  1. New table spaces will start consuming storage on the new path.

  2. Existing table spaces will not consume storage on the new path.

  3. The storage group will be placed in quot;Rebalance Pendingquot; mode.

  4. DB2 will verify that space is available on the storage path specified.

Answer: B

Question No: 3 – (Topic 1)

Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

  1. Data class, work class, and a limit

  2. Data class, action class, and a threshold

  3. Service subclass, action class, and a limit

  4. Service subclass, work class, and a threshold

Answer: D

Question No: 4 – (Topic 1)

The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = #39;Quebec#39; Which statement will create an index for optimal query performance?

  1. CREATE INDEX sales_idx ON sales (region)

  2. CREATE INDEX sales_idx ON sales (sales_person)

  3. CREATE INDEX sales_idx ON sales (region, sales_person)

  4. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

Answer: C

Question No: 5 – (Topic 1)

To configure instance-level auditing with db2audit, which authority is required?

  1. SYSADM

  2. SYSCTRL

  3. SECADM

  4. SYSMAINT

Answer: A

Question No: 6 – (Topic 1)

Which statement about data type mappings is true in a federated system?

  1. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.

  2. Data types can be mapped in both directions between a remote and local data type.

  3. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.

  4. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.

Answer: B

Question No: 7 – (Topic 1)

A table named SALES was created as follows:

Ensurepass 2017 PDF and VCE

Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data for the first quarter of 2013 to the SALES table and leave the table accessible?

  1. ALTER TABLE sales ADD PARTITION part_2013q1 STARTING (#39;01/01/2013#39;) ENDING (#39;03/31/2013#39;) IN ts5;

  2. ALTER TABLE sales ATTACH PARTITION part_2013q1 STARTING (#39;01/01/2013#39;) ENDING (#39;03/31/2013#39;)

    FROM TABLE q12013_sales;

  3. ALTER TABLE sales ADD PARTITION part_2013q1 STARTING (#39;01/01/2013#39;) ENDING (#39;03/31/2013#39;) IN ts5; SET INTEGRITY FOR sales IMMEDIATE CHECKED;

  4. ALTER TABLE sales ATTACH PARTITION part_2013q1 STARTING (#39;01/01/2013#39;) ENDING (#39;03/31/2013#39;)

FROM TABLE q12013_sales;

SET INTEGRITY FOR sales IMMEDIATE CHECKED;

Answer: D

Question No: 8 – (Topic 1)

What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?

  1. Call the ADMIN_MOVE_TABLE procedure.

  2. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure.

  3. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.

  4. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.

Answer: A

Question No: 9 – (Topic 1)

An auxiliary HADR standby database must use which HADR sync mode?

  1. SYNC

  2. ASYNC

  3. NEARSYNC

  4. SUPERASYNC

Answer: D

Question No: 10 – (Topic 1)

Consider the following statement:

Ensurepass 2017 PDF and VCE

Which indexes should be created for optimal query performance?

  1. CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);

  2. CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);

  3. CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);

  4. CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname);

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