Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-919
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-919.html

Informix 11.70 System Administrator

Question No: 71 – (Topic 2)

Consider the following selective row-level auditing example:

Ensurepass 2017 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?

Ensurepass 2017 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

  4. DBSECADM

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

  3. MODIFY

  4. RENAME

Answer: A

100% Ensurepass Free Download!
Download Free Demo:C2090-919 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-919 Full Exam PDF and VCE

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

2017 EnsurePass IT Certification PDF and VCE