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

What does the following SQL administration command do? EXECUTE FUNCTION task(quot;onmodequot;, quot;wiquot;, quot;/tmp/cfg_20130601quot;);

  1. Apply the new values for all configuration parameters in memory.

  2. Reset the values for dynamically updatable configuration parameters to the default values and save them in onconfig.

  3. Apply the new values for all dynamically updatable configuration parameters from the file quot;/tmp/cfg_20130601quot; in memory.

  4. Apply the new values for all dynamically updatable configuration parameters from the file quot;/tmp/cfg_20130601quot; and save them in onconfig.

Answer: C

Question No: 62

Which Informix utility is used to print information about runtime statistics for all threads in the server?

  1. onstat -g sta

  2. onstat -g act

  3. onstat -g rea

  4. onstat -g cpu

Answer: D

Question No: 63

Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured?

(Choose two.)

  1. Memory page size.

  2. Total number of available semaphores.

  3. Lower-boundary address for shared memory.

  4. Total memory presented to the operating system.

  5. Maximum operating-system shared-memory segment size.

Answer: C,E

Question No: 64

Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

  1. ANSI and non-ANSI

  2. Buffered and Unbuffered

  3. Buffered and Non-logging

  4. Non-logging and Unbuffered

  5. Non-logging and Non-logging

Answer: B,E

Question No: 65

Which statement accurately describes the mapped user functionality in Informix?

  1. The DBSA can control the access to the database at the table level by creating different security labels for each user.

  2. The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessary privileges.

  3. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the host computer.

  4. The DBSA can grant access to the database server to users of the host computer operating system by implementing different authentication mechanisms for each user.

Answer: C

Question No: 66

When configuring Informix server for DRDA connection, which statement is true?

  1. The connection protocol must be drsoctcp.

  2. The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.

  3. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.

  4. The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

Answer: C

Question No: 67

Which two DataBlade extensions can be automatically registered? (Choose two.)

  1. Web DataBlade

  2. Spatial DataBlade

  3. TimeSeries DataBlade

  4. Excalibur Text DataBlade

  5. High Performance Loader DataBlade

Answer: B,C

Question No: 68

Which two parameters are mandatory when running quot;ifxclonequot;? (Choose two.)

  1. Target server instance size.

  2. Target server instance name.

  3. Source server instance sqlhosts.

  4. Target server configuration parameters.

  5. Source server instance TCP/IP address.

Answer: B,E

Question No: 69

Which statement is FALSE?

  1. A new index can be created compressed.

  2. Attached indexes cannot be compressed.

  3. A compressed index can be uncompressed.

  4. A compressed index cannot be uncompressed.

Answer: C

Question No: 70

Which is NOT a valid index fragmentation strategy?

  1. Fragment by Range

  2. Partition by Expression

  3. Fragment by Expression

  4. Fragment by Round Robin

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.