[Free] 2018(Jan) Dumps4cert Pass4sure IBM C2090-614 Dumps with VCE and PDF 71-80

By | February 3, 2018

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released C2090-614
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/C2090-614.html

DB2 10.1 Advanced DBA for Linux UNIX and Windows

Question No: 71 – (Topic 2)

Which command will be executed successfully on every database partition if db2_all is used?

  1. CONNECT

  2. FORCE APPLICATION

  3. RESTART DATABASE

  4. ACTIVATE DATABASE

Answer: C

Question No: 72 – (Topic 2)

Given the following output:

Dumps4Cert 2018 PDF and VCE

Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?

  1. EXPLAIN_FROM_DATA

  2. EXPLAIN_FROM_ACTIVITY

  3. EXPLAIN_FROM_SECTION

  4. EXPLAIN_FROM_CATALOG

Answer: B

Question No: 73 – (Topic 2)

With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?

  1. The primary database only.

  2. The auxiliary standby database only.

  3. The principal standby database only.

  4. The primary, auxiliary standby, and principal standby database.

Answer: C

Question No: 74 – (Topic 2)

A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows:

Dumps4Cert 2018 PDF and VCE

What can be done to improve the performance of a query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?

  1. Reload table SALES and use only one partition with a collocated join to the DATE_DIM table using the primary key DATE_ID.

  2. Reload table DATE_DIM and use only one partition with a collocated join to the SALES table using the primary key DATE_ID.

  3. Create a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table, create index on DATE_ID column in the REPL_SALES table, and collect statistics on REPL_SALES table.

  4. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh REPL_DATE_DIM table, create index on DATE_ID column in the REPL_DATE_DIM table, and collect statistics on REPL_DATE_DIM table.

Answer: D

Question No: 75 – (Topic 2)

Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?

  1. Columns with low cardinalities

  2. Columns with high cardinalities

  3. Columns involved in roll-in or roll-out of data

  4. Columns involved in equality or range predicate queries

Answer: B

Question No: 76 – (Topic 2)

The following statement was used to create a table space named TBSP1 in a non- partitioned database:

Dumps4Cert 2018 PDF and VCE

Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?

  1. ALTER TABLESPACE tbsp1 REDUCE MAX

  2. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK

  3. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);

  4. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;

Answer: C

Question No: 77 – (Topic 2)

A database named TEST and a storage group named SG_1 were created with these statements:

Dumps4Cert 2018 PDF and VCE

an error was produced.Why did the error occur?

  1. The current default storage group cannot be dropped.

  2. New storage paths cannot be added to existing storage groups.

  3. The storage group IBMSTOGROUP cannot be dropped because it is a system-defined storage group.

  4. The storage group SG_1 was not the current default storage group at the time a new storage path was being added to it.

Answer: A

Question No: 78 – (Topic 2)

What type of file system is used to store data and logs in a DB2 pureScale environment?

  1. Network File System (NFS)

  2. General Parallel File System (GPFS)

  3. Common Internet File System (CIFS)

  4. Enhanced Journaled File System (JFS2 or EXT4)

Answer: B

Question No: 79 – (Topic 2)

Given the following CREATE TABLE statement:

Dumps4Cert 2018 PDF and VCE

Which statement is correct?

  1. A range-clustered table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.

  2. A range-partitioned table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.

  3. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.

  4. A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.

Answer: C

Question No: 80 – (Topic 2)

Which configuration parameter is used to designate a storage area for archived log files that are retrieved for recovery purposes?

  1. logarchopt1

  2. failarchpath

  3. mirrorlogpath

  4. overflowlogpath

Answer: D

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

Dumps4cert 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

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