IBM Information Mgmt Informix Technical Mastery Test v3 (000-M68) Free Practice Test

Question 1

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

A. Dbspaces can only contain one or two chunks.

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

C. Table fragments are automatically compressed.

D. Indexes are now separated from the data.

Correct Answer: B

Question 2

In which case would an Enterprise Replication (ER) solution be needed over a High Availability Cluster?

A. Servers are running different versions of Informix.

B. Data is being replicated between more than two locations.

C. An entire database needs to be replicated.

D. The Linux operating system is being used.

Correct Answer: A

Question 3

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?

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

B. Informix ODBC Driver

C. Informix Client Software Development Kit (CSDK)

D. IBM Data Server Client

Correct Answer: C

Question 4

What is an advantage of using a SPL routine?

A. Increased efficiency since business logic can be centrally maintained and managed on the server.

B. Increased performance because additional indexes can be selected by the optimizer for
complex queries.

C. Increased network utilization since more data is passed between client and server.

D. Increased security because SPL routines can only be invoked by Java applications.

Correct Answer: A

Question 5

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

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

B. There are more transactions than queries.

C. PDQPRIORITY is set to the value "HIGH".

D. Database or table logging is turned on.

Correct Answer: C

Welcome to TestSimulate

IBM Information Mgmt Informix Technical Mastery Test v3 (000-M68) Free Practice Test