Latesttests
2017 Jan IBM Official New Released P2090-068
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/P2090-068.html

IBM Information Management Informix Technical Mastery Test v3

Question No: 11

Which of the following is a key benefit that allows Informix to excel in the small-medium business marketplace?

  1. Itsupports a small number of users.

  2. Data can be exported to flat files.

  3. A single secondary server can be configured as a hot-standby instance.

  4. Autonomic features offer near hands-free administration.

Answer: D

Question No: 12

Which utility is used to debug SPL routines?

  1. OAT (OpenAdmin Tool)

  2. dbaccess.

  3. IBM Optim Data Studio

  4. dbx.

Answer: C

Question No: 13

Which of the following is true of the new Storage Provisioning technology in Informix?

  1. Dbspaces can only contain one or two chunks.

  2. The ability to extend or create new chunks as needed.

  3. Indexes are now separated from the data.

  4. Table fragments are automatically compressed.

Answer: B

Question No: 14

Which statement about the OpenAdmin Tool (OAT) for Informix is TRUE?

  1. It is only available for Informix Ultimate Edition.

  2. It is a separate, add-on feature that is chargeable.

  3. It can manage hundreds of local or remote Informix instances.

  4. It can manage, monitor, and administer local databases only.

Answer: C

Question No: 15

A developer is writing an embedded SQL application written in C. What software does she need to develop and test the application against a remote Informix database?

  1. Informix Client Software Development Kit (CSDK)

  2. IBM Data Server Client

  3. IBM Data Server Driver for ODBC, CLI, and .NET

  4. Informix ODBC Driver

Answer: A

Question No: 16

Which of the following statements about the level of compatibility between the backups produced by ontape and ON-Bar is true?

  1. You can create a backup with ON-Bar and restore it with ontape, but not vice versa.

  2. You can create a backup with ontape and restore it with ON-Bar, but not vice versa.

  3. The respective backups are not compatible; you cannot create a backup with ontape and restore it with ON-Bar, or vice versa.

  4. The respective backup tapes are compatible; you can create a backup with ontape and restore it with ON-Bar, and vice versa.

Answer: C

Question No: 17

What is the primary function of the Informix Connection Manager?

  1. To monitorand direct the connection requests from client applications to the appropriate server in the high availability cluster.

  2. To monitor and maintain the connections between nodes in an Enterprise Replication environment.

  3. To monitor and govern SQL statements submitted by client applications.

  4. To monitor and report the connection status of the High Availability Data Replication (HDR) secondary server.

Answer: A

Question No: 18

Which of the following configurations would suggest that an Informix server is tuned for a DSS workload?

  1. PDQPRIORITY is set to the value quot;HIGHquot;.

  2. There are more transactions than queries.

  3. Database or table logging is turned on.

  4. A task is configured to capture Checkpoint data every two hours.

Answer: A

Question No: 19

Why does a database execute a checkpoint operation?

  1. To ensure that runaway queries are stopped before consuming all the system resources.

  2. To synchronize the pages in a primary dbspace with a mirrored dbspace.

  3. To update statistics for large tables currently being accessed by queries.

  4. To synchronize the pages on disk with the pages in the shared-memory buffers.

Answer: D

Question No: 20

Which type of high availability server does NOT maintain a copy of the entire physical database in its ownisolated disk space?

  1. Remote Primary Server (RPS)

  2. Remote Standalone Secondary (RSS)

  3. Shared-Disk Secondary (SDS)

  4. High Availability Data Replication (HDR) Secondary

Answer: C

100% Free Download!
Download Free Demo:P2090-068 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests P2090-068 Full Exam PDF and VCE

Latesttests 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 Latesttests IT Certification PDF and VCE