[Free] 2018(Jan) Dumps4cert Braindumps IBM C2090-919 Dumps with VCE and PDF Download 11-20

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

Informix 11.70 System Administrator

Question No: 11 – (Topic 1)

What ONCONFIG parameter can be tuned to increase memory for hash joins?

  1. RESIDENT

  2. EXTSHMADD

  3. VP_MEMORY_CACHE_KB

  4. DS_NONPDQ_QUERY_MEM

Answer: D

Question No: 12 – (Topic 1)

Given the following SQL statement:

Dumps4Cert 2018 PDF and VCE

What does the merge statement do?

  1. For each row that matches the condition col1 = c1, it inserts a new row in tab1 with the sum of corresponding c2 and col2 column values.

  2. For the rows that match the condition col1 = c1, it adds the the c2 column value to the col2 column value and updates corresponding rows in tab1.

  3. For the rows that match the condition, col1 = c1, it adds the col2 column value to the c2 column value and updates corresponding rows in tab2.

  4. Deletes rows from tab2 and updates rows in tab1 that match the condition col1 = c1 by adding the c2 column value to the col2 column value of corresponding rows in tab1.

Answer: B

Question No: 13 – (Topic 1)

Given the following SQL command where the DBSPACETEMP onconfig and environment variables are set to valid dbspaces:

create temp table mytemp (columns) with no log;

in what order will the instance evaluate where to place this table?

  1. DBSPACETEMP environment variable, root dbspace, dbspace where the database was created, DBSPACETEMP onconfig parameter.

  2. DBSPACETEMP environment variable, DBSPACETEMP onconfig parameter, dbspace where the database was created, root dbspace.

  3. DBSPACETEMP onconfig parameter variable, DBSPACETEMP environment variable, root dbspace, dbspace where the database was created.

  4. DBSPACETEMP onconfig parameter variable, root dbspace, dbspace where the database was created, DBSPACETEMP environment variable.

Answer: B

Question No: 14 – (Topic 1)

What two conditions must be met in order to use Kernel-asynchronous I/O (KAIO)? (Choose two.)

  1. When AIO is not available.

  2. When the I/O is to raw disk space.

  3. When the I/O is to buffered file chunks.

  4. When the operating system supports it.

  5. When the KAIOON parameter in ONCONFIG file is set to 1.

Answer: B,D

Question No: 15 – (Topic 1)

What two onconfig parameters will help improve performance of new network connections? (Choose two.)

  1. NETTYPE

  2. VPCLASS

  3. NS_CACHE

  4. FET_BUF_SIZE

  5. NUMFDSERVERS

Answer: C,E

Question No: 16 – (Topic 1)

What is used during Fast Recovery to return pages to the original state?

  1. Logical Log

  2. Physical Log

  3. External Tables

  4. Temporary DBSpaces

Answer: B

Question No: 17 – (Topic 1)

Which of the following is NOT a step in setting up HDR for the first time?

  1. Take a level 0 backup of the primary.

  2. Use oninit -v to bring up the secondary.

  3. Execute a physical restore on the secondary.

  4. Use onmode -d to specify the secondary instance name.

Answer: B

Question No: 18 – (Topic 1)

To enable network encryption, what two steps must the administrator complete? (Choose two.)

  1. Enter the CSM name in the sqlhosts file.

  2. Set the IFX_ENCCSM onconfig parameter to 1.

  3. Define the CSM in the concsm.cfg configuration file.

  4. Enter the CSM name in the onconfig NETTYPE parameter.

  5. Set the environment variable ENCCSMCFG to the name of the CSM.

Answer: A,C

Question No: 19 – (Topic 1)

Under which condition can table fragments NOT be eliminated during query processing?

  1. Tables with non-overlapping fragments and an equality query predicate.

  2. Tables with round-robin distribution scheme and a range query predicate.

  3. Tables with non-overlapping fragments on a single column and a range query predicate.

  4. Tables with overlapping or non-contiguous fragments on a single column and an

equality query predicate.

Answer: B

Question No: 20 – (Topic 1)

By default, the alarm program gets executed for which event(s)?

  1. All events.

  2. Only for events with Severity code 1.

  3. Only for events with Severity code 5.

  4. Only for events with Severity code greater than 1.

Answer: D

100% Dumps4cert Free Download!
Download Free Demo:C2090-919 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-919 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