[Free] 2018(Jan) EnsurePass Passguide IBM C2090-919 Dumps with VCE and PDF 81-90

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan 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 2018 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% Ensurepass Free Download!
Download Free Demo:C2090-919 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-919 Dumps

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.