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: 81

Which feature can be enabled in Informix?

  1. Automatic addition of a CPU VP.

  2. Automatic addition of an ADM VP.

  3. Automatic extension of storage spaces.

  4. Automatic addition of message log files.

Answer: C

Question No: 82

Which threshold setting applies when configuring automatic memory management?

  1. SHMTOTAL

  2. BUFFERPOOL

  3. SHMVIRTSIZE

  4. DS_TOTAL_MEMORY

Answer: A

Question No: 83

Which option provides the greatest performance benefit in an Informix warehouse environment?

  1. Setting lower value of PDQPRIORITY.

  2. Increasing the number of B-Tree cleaners.

  3. Setting higher value of DS_TOTAL_MEMORY.

  4. Setting value of OPT_GOAL configuration variable to 0.

Answer: C

Question No: 84

Which option maximizes performance in an Informix Warehouse (DSS) environment?

  1. Higher value of LOGBUFF.

  2. Higher value of PHYSBUFF.

  3. Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.

  4. SHMTOTAL set to 0 to allow Informix to access all available physical memory.

Answer: D

Question No: 85

Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)

  1. Byte

  2. Shared

  3. Update

  4. Exclusive

  5. Promotable

Answer: B,D

Question No: 86

For a query to be processed by the accelerator, the query or query block should meet the certain criteria. Which statement is FALSE?

  1. The query or query block must include at least 2 fact tables.

  2. The query or query block must refer to a subset of the tables in the AQT.

  3. The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.

  4. The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

Answer: A

Question No: 87

Which communication protocol needs additional configuration besides onconfig and sqlhosts?

  1. TLITCP

  2. IPCSTR

  3. IPCSHM

  4. SOCSSL

Answer: D

Question No: 88

Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)

  1. On-disk encryption

  2. Enterprise Replication

  3. Column level encryption

  4. High-Availability Data Replication

  5. Server-to-server distributed query communication

Answer: B,D

Question No: 89

Which is a valid Pluggable Authentication Module (PAM) mode in Unix?

  1. Login mode

  2. Client mode

  3. Server mode

  4. Password mode

Answer: D

Question No: 90

During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?

  1. User local shell, system global

  2. System global, user local shell

  3. System global, user local shell, onconfig file

  4. Onconfig file, user local shell, system global

Answer: D

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.