IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 81:

  Which connection type can be used for network connections?

  A. Sockets
  B. Named Pipes
  C. Stream Pipes
  D. Shared memory
  A. Sockets

• Question 82:

  Which Windows utility is used to configure the SQLHOSTS registry key?

  A. ilogin
  B. instmgr
  C. setnet32
  D. oncmsm
  C. setnet32

• Question 83:

  Which of the following privileges is NOT valid for a table fragment?

  A. ALL
  B. INSERT
  C. UPDATE
  D. CREATE INDEX
  D. CREATE INDEX

• Question 84:

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

  A. ALTER
  B. AMEND
  C. MODIFY
  D. RENAME
  A. ALTER

• Question 85:

  Which statement is NOT true for interval fragmentation?

  A. A NULL fragment is allowed.
  B. A remainder fragment is allowed.
  C. Fragments cannot be overlapping.
  D. A fragment key can have only a single column.
  B. A remainder fragment is allowed.

• Question 86:

  A Connection Manager is started with the following Service Level Agreement: SLA report=(SDS+report_server)

  Where will a connection to the report SLA be redirected?

  A. Any available SDS (Shared Disk Secondary) server, thenreport_server.
  B. Report_server, then any available SDS server.
  C. Report_server, then the SDS server with most available resources.
  D. The server with the most available resources in the SLA list, including all SDS servers andreport_server.
  D. The server with the most available resources in the SLA list, including all SDS servers andreport_server.

• Question 87:

  To maximize the performance of your OnBar backup and recovery operations, what should you do?

  A. Use a commercial storage manager.
  B. Use the bundled Informix Storage Manager (ISM).
  C. Use a combination of disk-based and tape-based backup devices.
  D. Use separate storage devices for instance spaces and logical logs.
  D. Use separate storage devices for instance spaces and logical logs.

• Question 88:

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

  

  A. The new row will be placed in the fragment p1.
  B. An error is returned stating that there is no suitable fragment.
  C. A new fragment is automatically added to store values >= 400 and < 500.
  D. A new fragment is automatically added to store values >= 200 and < 500.
  C. A new fragment is automatically added to store values >= 400 and < 500.

• Question 89:

  What statement about users accessing a Flexible Grid is true?

  A. Every user can execute commands on the Flexible Grid.
  B. Only userinformix can execute commands on a Flexible Grid.
  C. Users have to be authorized to execute Flexible Grid commands.
  D. Commands can only be executed from the node on which the Flexible Grid was created.
  C. Users have to be authorized to execute Flexible Grid commands.

• Question 90:

  Which statement about compression is NOT true?

  A. If you use High-Availability clusters, data that is compressed on the primary will not be compressed on the secondary(s).
  B. If you use Enterprise Replication, compressing data on one replication server does not affect the data on any other replication server.
  C. You cannot perform compression operations on a High-Availability cluster secondary.
  D. The query optimizer may choose different query plans because compressed data covers fewer pages and has more rows per page than uncompresseddata.
  A. If you use High-Availability clusters, data that is compressed on the primary will not be compressed on the secondary(s).