[Free] 2018(Jan) Dumps4cert Braindumps IBM C2090-919 Dumps with VCE and PDF Download 31-40

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

Informix 11.70 System Administrator

Question No: 31 – (Topic 1)

How is the DBSSO group determined on a Unix system with role separation?

  1. It is always the group informix.

  2. It is set using the onsecurity command line tool.

  3. It is the group that owns $INFORMIXDIR/dbssodir.

  4. It is the group specified in the DBSSO onconfig parameter.

Answer: C

Question No: 32 – (Topic 1)

Which two corrective actions may be taken if following message is logged in the online message log during a failed attempt to bring an instance online? (Choose two)

18:15:44 Size of resident virtual segments 100000KB 60000KB gt; 150000KB 18:15:44 total allowed by configuration parameter SHMTOTAL

  1. Decrease SHMADD

  2. Increase SHMTOTAL

  3. Decrease SHMBASE

  4. Increase SHMVIRTSIZE

  5. Decrease buffer pool size

Answer: B,E

Question No: 33 – (Topic 1)

Which option would be used with quot;cdr define replicatequot; to create a shadow replicate?

  1. -backup

  2. -mirrors

  3. -shadow

  4. -synchronize

Answer: B

Question No: 34 – (Topic 1)

Which of the following activities does the Secure-Auditing Facility NOT monitor and record?

  1. Specific rows.

  2. Specific users.

  3. Specific tables.

  4. Specific DML operations.

Answer: A

Question No: 35 – (Topic 1)

Which command line utility displays real time statistics about the instance?

  1. dbinfo

  2. onstat

  3. dbschema

  4. onmachinfo

Answer: B

Question No: 36 – (Topic 1)

Fragment level statistics are NOT supported with which fragmentation strategy?

  1. List fragmentation.

  2. Interval fragmentation.

  3. Expression fragmentation.

  4. Round-robin fragmentation.

Answer: D

Question No: 37 – (Topic 1)

Which statement about updating statistics is NOT true?

  1. UPDATE STATISTICS HIGH scans the entire table.

  2. Data distributions are updated every time UPDATE STATISTICS LOW is executed.

  3. UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable.

  4. An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE.

Answer: B

Question No: 38 – (Topic 1)

Which statement regarding default roles is true?

  1. An administrator can define a default role to assign only to the PUBLIC group for a particular database.

  2. The privileges associated with a default role takes precedence over the privileges granted to an individual user.

  3. An administrator can define a default role to assign to individual users or to the PUBLIC group for a particular database.

  4. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

Answer: C

Question No: 39 – (Topic 1)

Which statement about Informix data compression is true?

  1. Compressing data on one Enterprise Replication (ER) node affects the data on the other ER nodes.

  2. I/O-bound tables, for example, those with bad cache hit ratios, are good candidates for compression.

  3. Compression operations can be executed on a HDR secondary, RS secondary, or SD secondary server.

  4. Compressing data on a primary instance will not compress data on the High-Availability Data Replication (HDR) secondary instance.

Answer: B

Question No: 40 – (Topic 1)

Which of the following gives a good initial estimate for the physical log size?

  1. 110% of rootdbs.

  2. 110% the default buffer pool.

  3. 110% of the logical log space.

  4. 110% of combined buffer pool.

Answer: D

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