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

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!
http://www.Dumps4cert.com/C2090-619.html

IBM Informix 12.10 System Administrator

Question No: 71

The DBA updated the uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands:The DBA updated the ?uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands: UPDATE ph_task SET tk_enable

= ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name =

?uto_crsd? UPDATE ph_threshold SET value = ?WHERE name = UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name =

?UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name = UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name =

?UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?

  1. Compress all tables with less than 5000 rows.

  2. Compress and defragment tables with more than 5000 uncompressed rows.

  3. Compress, repack and shrink tables with more than 5000 uncompressed rows.

  4. Do not compress, repack, shrink and defragment any table with more than 5000 rows.

Answer: C

Question No: 72

You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?

  1. stores:sysusers

  2. sysmaster:sysroles

  3. sysuser:sysroleauth

  4. sysmaster:sysusers

Answer: A

Question No: 73

Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

  1. STATAUTO

  2. STATFORCE

  3. FORCE AUTO

  4. STATCHANGE

Answer: D

Question No: 74

Which statement is true about log salvaging?

  1. ontape cannot perform salvage of logs.

  2. Log salvaging cannot be avoided if onbar is used for restore.

  3. Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.

  4. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.

Answer: D

Question No: 75

The DBA has defined the following configuration parameters in the onconfig file:

Dumps4Cert 2018 PDF and VCE

What are the actual values for LMM START THRESHOLD and LMM STOP THRESHOLD computed internally by the database server?

  1. LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB

  2. LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB

  3. LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB

  4. LMM START THRESHOLD = 2% and LMM STOP THRESHOLD = 3% of physical memory in the system

Answer: B

Question No: 76

How do the MAX_PDQPRIORITY onconfig parameter and the PDQPRIORITY environment variable work together to constrain access to PDQ resources?

  1. PDQPRIORITY is the only constraint.

  2. MAX_PDQPRIORITY is the only constraint.

  3. The minimum of the two values is the actual constraint.

  4. The constraint is MAX_PDQPRIORITY / 100 * PDQPRIORITY / 100.

Answer: D

Question No: 77

Which storage manager allows specification of a larger size than others for BAR_XFER_BUF_SIZE?

  1. Informix Storage Manager (ISM)

  2. Informix Primary Storage Manager (PSM)

  3. Informix Secondary Storage Manager (ISSM)

  4. Informix Archive Restore Storage Environment (IARSE)

Answer: B

Question No: 78

An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?

  1. Increase the value of MAX_INCOMPLETE_CONNECTIONS.

  2. Increase the value of NUMFDSERVERS and add more poll threads.

  3. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.

  4. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.

Answer: B

Question No: 79

Where are the Primary Storage Manager catalog tables stored?

  1. sysutils database

  2. sysadmin database

  3. sysmaster database

  4. A location as specified by the PSM_CATALOG_PATH configuration parameter

Answer: D

Question No: 80

Assuming network connectivity between two Informix instances, which file may need additional configuration to allow distributed queries?

  1. sqlhosts

  2. /etc/services

  3. $ONCONFIG

  4. /etc/hosts.equiv

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
PDF VCE 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.