[Free] 2018(Jan) Dumps4cert Pass4sure IBM C2090-619 Dumps with VCE and PDF 81-90

By | February 3, 2018

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

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?





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?





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