2017 Nov IBM Official New Released C2090-919
100% Free Download! 100% Pass Guaranteed!

Informix 11.70 System Administrator

Question No: 81 – (Topic 2)

Which statement regarding the Single Sign-On (SSO) feature is correct?

  1. You cannot use the Informix DB-Access client with SSO.

  2. The Informix implementation of SSO does not support PAM.

  3. Authentication for the DBMS happens when a user first logs in to the client computer or domain.

  4. The user is prompted for a password every time a user action tries to access an Informix database.

Answer: C

Question No: 82 – (Topic 2)

What is used during Fast Recovery to return pages to the original state?

  1. Logical Log

  2. Physical Log

  3. External Tables

  4. Temporary DBSpaces

Answer: B

Question No: 83 – (Topic 2)

Which user isolation level may cause concurrency problems with SELECT statements?

  1. Dirty Read

  2. Committed Read

  3. Dirty Read Last Committed

  4. Committed Read Last Committed

Answer: B

Question No: 84 – (Topic 2)

Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary tables be created by default? (Choose three.)

  1. The root dbspace.

  2. The users#39; home directory.

  3. The $INFORMIXDIR/tmp directory.

  4. The dbspace in which the active database was created.

  5. The /tmp directory or PSORT_DBTEMP.

Answer: A,D,E

Question No: 85 – (Topic 2)

What two parameters can affect how often checkpoints occur? (Choose two.)






Answer: A,B

Question No: 86 – (Topic 2)

Given the following SQL statement:

Ensurepass 2017 PDF and VCE

WHEN MATCHED THEN DELETE What does the merge statement do?

  1. Deletes rows in tab2 that match the condition col1 = c1.

  2. Deletes rows in tab1 that match the condition col1 = c1.

  3. Deletes rows in tab1 that match the condition col1 = c1 and deletes rows in tab2 that do not match the condition col1 = c1.

  4. Deletes rows in tab1 that match the condition col1 = c1 and insert rows in tab1 from those in tab2 that do not match the condition.

Answer: B

Question No: 87 – (Topic 2)

Which statement about compression is NOT true?

  1. If you use High-Availability clusters, data that is compressed on the primary will not be compressed on the secondary(s).

  2. If you use Enterprise Replication, compressing data on one replication server does not affect the data on any other replication server.

  3. You cannot perform compression operations on a High-Availability cluster secondary.

  4. The query optimizer may choose different query plans because compressed data covers fewer pages and has more rows per page than

uncompressed data.

Answer: A

Question No: 88 – (Topic 2)

What two onconfig parameters will help improve performance of new network connections? (Choose two.)






Answer: C,E

Question No: 89 – (Topic 2)

What two conditions must be met for direct I/O to occur? (Choose two.)

  1. When the I/O is to raw disk space.

  2. When the I/O is to cooked disk space.

  3. When the table is too big to fit in the bufferpool.

  4. When doing I/O operations on temporary dbspaces.

  5. When the DIRECT_IO configuration parameter is set to 1.

Answer: B,E

Question No: 90 – (Topic 2)

What does the following SQL statement do? execute function task(quot;reset sysadminquot;, quot;admindbsquot;);

  1. Renames sysadmin database to admindbs.

  2. Purges all quot;mon_*quot; tables in sysadmin database as user admindbs.

  3. Turns the whole Database Scheduler off and finally drops sysadmin database.

  4. Locks sysadmin database in exclusive mode and recreates it in dbspace admindbs.

Answer: D

100% Free Download!
Download Free Demo:C2090-919 Demo PDF
100% Pass 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
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE