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

IBM Informix 12.10 System Administrator

Question No: 21

Which option is available through ifx_grid_connect()?

  1. Rename a replicated database.

  2. Enable use of TimeSeries columns in tables.

  3. Enable automatic creation of templates in a grid.

  4. Defer propagation of DDL statements to other servers in the grid.

Answer: D

Question No: 22

Which parameter can automatically adjust other configuration parameters that are not

present in the configuration file?

  1. AUTO_PERF

  2. AUTO_TUNE

  3. AUTO_CONFIG

  4. AUTO_ENABLE

Answer: B

Question No: 23

Which configuration parameter can toggle the automatic expansion of storage spaces?

  1. SP_AUTOGROW

  2. SP_AUTO_SPACE

  3. SP_AUTOEXPAND

  4. SP_EXPAND_ENABLE

Answer: C

Question No: 24

Where must the HA_FOC_ORDER configuration parameter be set?

  1. Any server in the cluster.

  2. The primary server only.

  3. The SDS secondary only.

  4. The HDR secondary only.

Answer: B

Question No: 25

Which objects can be compressed?

  1. CLOBs

  2. smart BLOBs

  3. partition BLOBs

  4. blobspace BLOBs

Answer: C

Question No: 26

Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG(SUM(dollars)) OVER() FROM sales;

  1. SUM

  2. OVER

  3. FROM

  4. AVG (SUM(dollars))

Answer: B

Question No: 27

What security role is required for you to create trusted-context objects?

  1. AAO

  2. DBSA

  3. DBSSO

  4. DBSECADM

Answer: D

Question No: 28

When the server is in administration mode, which users are NOT allowed to connect?

  1. informix

  2. Members of the DBSA group

  3. Members of the DBSSO group

  4. Users specified by ADMIN_MODE_USERS

Answer: C

Question No: 29

Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

  1. DBUPSPACE

  2. DS_POOLSIZE

  3. VP_MEMORY_CACHE_KB

  4. DS_NONPDQ_QUERY_MEM

Answer: D

Question No: 30

Which configuration parameter locks the resident and virtual segments of shared memory in operating-system physical memory?

  1. SHMSEG

  2. SHMBASE

  3. RESIDENT

  4. INFORMIXSHMLCK

Answer: C

100% Ensurepass Free Download!
Download Free Demo:C2090-619 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-619 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.