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

By | February 4, 2018

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

Informix 11.70 System Administrator

Question No: 71 – (Topic 2)

Consider the following selective row-level auditing example:

Dumps4Cert 2018 PDF and VCE

How many entries will be added to the audit file?

  1. 0

  2. 3

  3. 5

  4. 8

Answer: C

Question No: 72 – (Topic 2)

Which is a valid PAM mode supported by Informix in a UNIX platform?

  1. Login mode

  2. Client mode

  3. Server mode

  4. Password mode

Answer: D

Question No: 73 – (Topic 2)

Given the following table, what happens if you insert a row with an id of 450?

Dumps4Cert 2018 PDF and VCE

  1. The new row will be placed in the fragment p1.

  2. An error is returned stating that there is no suitable fragment.

  3. A new fragment is automatically added to store values gt;= 400 and lt; 500.

  4. A new fragment is automatically added to store values gt;= 200 and lt; 500.

Answer: C

Question No: 74 – (Topic 2)

Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?

  1. To avoid LRU flushes.

  2. To ensure the buffer pool is always available.

  3. To ensure the onstat -g ckp report is accurate.

  4. To avoid transaction blocking during checkpoints.

Answer: D

Question No: 75 – (Topic 2)

Given the following statement:

session A:

set lock mode to wait; select * from tab1;

if session A is blocked, which sysmaster table contains the session id holding the lock blocking session A?

  1. syslocks

  2. sysscblst

  3. syssessions

  4. syslockholders

Answer: A

Question No: 76 – (Topic 2)

Which two actions will occur when the following command is executed? (Choose two.) UPDATE STATISTICS HIGH AUTO

  1. Stored Procedures will be recompiled.

  2. Update statistics will run high on the table named AUTO.

  3. Update statistics will run high only on the first column of an index.

  4. Update statistics will run high only after the optimizer decides the statistics are too old.

  5. Update statistics will run high only on columns which meet the STATSCHANGE threshold.

Answer: A,E

Question No: 77 – (Topic 2)

What does the following task function do?

EXECUTE FUNCTION task(quot;storagepool addquot;, quot;/region2/dbspacesquot;, quot;0quot;, quot;0quot;, quot;20000quot;, quot;1quot;);

  1. Creates a second storagepool.

  2. Creates dbspace at /region2/dbspaces.

  3. Invalid offset and total size for storagepool add command.

  4. Add the directory /region2/dbspaces to the storagepool with a beginning offset of 0, a total size of 0, initial chunk size of 20 MB, and a high priority.

Answer: D

Question No: 78 – (Topic 2)

Which role can create, alter, or delete trusted context objects?

  1. DBA

  2. DBSA

  3. DBSSO


Answer: D

Question No: 79 – (Topic 2)

On which node of an Informix H/A cluster can you execute an external backup without disturbing cluster operations?

  1. Primary

  2. Shared disk secondary

  3. Remote standalone secondary

  4. High-availability data replication secondary

Answer: C

Question No: 80 – (Topic 2)

Which of the following schema privileges allows you to rename a fragment?

  1. ALTER

  2. AMEND



Answer: A

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