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

IBM Informix 12.10 System Administrator

Question No: 91

Which of the following is NOT possible during a non-root Informix Server installation?

  1. Role Separation

  2. Create users and groups

  3. Create a database server instance

  4. Secure the Informix installation directory

Answer: B

Question No: 92

The #39;onstat -k#39; output is showing #39;56 lock table overflows#39;. Which catalog table can be used to display the relevant lock statistics?

  1. syslocks

  2. systables

  3. sysprofile

  4. sysoverflow

Answer: C

Question No: 93

What is the primary benefit of a Storage Pool?

  1. It allows data to be shared across instances.

  2. It allows data to be shared across dbspaces.

  3. It allows space to automatically be added to dbspaces.

  4. It allows space to be reserved for critical database operations.

Answer: C

Question No: 94

Which fragmentation strategy is capable of generating new fragments automatically?

  1. Fragment by List

  2. Fragment by Range

  3. Fragment By Expression

  4. Fragment by Round Robin

Answer: B

Question No: 95

Which two statements are true about blobspace? (Choose two.)

  1. The TEXT or BYTE objects are stored in the logical log files.

  2. A blobspace is a logical storage unit that stores only TEXT and BYTE data.

  3. The TEXT or BYTE objects that are assigned to a blobspace are physically logged.

  4. A newly created blobspace is immediately available for storage of TEXT or BYTE data.

  5. The database server writes data stored in a blobspace directly to disk without passing it through the bufferpool.

Answer: B,E

Question No: 96

When KAIO is available and raw disk is used, which statement is true?

  1. Logical Log IO is performed by the LIO VP.

  2. Physical Log IO is performed by the PIO VP.

  3. Logical Log IO is performed by the KAIO VP.

  4. Physical Log IO is performed by the CPU VP.

Answer: D

Question No: 97

The DBA wants to define a replicate as follows:

Ensurepass 2018 PDF and VCE

Which condition must be true for the command to execute successfully?

  1. The table table1 should have col1 as its primary key.

  2. The table table1 should have CRCOLS shadow columns.

  3. The table table1 should have a constraint on column col1.

  4. The table table1 should have an unique index on column col2.

Answer: D

Question No: 98

Which two tasks can be performed through an Informix Grid? (Choose two.)

  1. Install Informix products.

  2. Start Informix servers in a grid.

  3. Copy external files to grid servers.

  4. Setup replication automatically in a grid.

  5. Modify replication server attributes for grid servers.

Answer: C,D

Question No: 99

Which two statements are true?

  1. Temporary dbspaces can have different page sizes.

  2. Separate temporary dbspaces are required for each buffer pool.

  3. DBSPACETEMP dbspaces can be temporary or standard dbspaces.

  4. If rootdbs is mirrored then all the temporary spaces must be mirrored.

  5. If DBSPACETEMP is not configured then temporary space will never be used.

Answer: A,C

Question No: 100

Which two statements are true about archecker utility? (Choose two.)

  1. Archecker can help developers team to debug procedures.

  2. Archecker can do backup testing, fully integrated with onbar and ontape utilities.

  3. Archecker can copy data from different servers, even restoring from a remote device.

  4. Archecker can use all kind of connections protocols, including shared memory connections.

  5. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.

Answer: B,E

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

Leave a Reply

Your email address will not be published. Required fields are marked *

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