IBM Information Mgmt Informix Technical Mastery Test v3 (P2090-068) Free Practice Test

Question 1

Which of the following statements is True about the Onstat utility?

A. It cannot be used to retrieve locking information.

B. It doesn't place any locks on shared memory.

C. It can be used to view table data.

D. It consume a lot of the system's resources andshould be used infrequently.

Correct Answer: B

Question 2

Which of the following Informix security methods protects network data transmitted between a server and a client?

A. Cell-level encryption

B. Network data encryption

C. Set-column level encryption

D. Column-level encryption

Correct Answer: B

Question 3

In which of the following scenarios is Informix the best fit?

A. Large data warehouses requiring cubing and complex multi-dimensional queries.

B. High-transaction OLTP workloads.

C. Applications requiring dedicated hardware as part of the solution.

D. Applications with variable and dynamic data records.

Correct Answer: B

Question 4

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

A. Data can be exported to flat files.

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

C. Autonomic features offer near hands-free administration.

D. Itsupports a small number of users.

Correct Answer: C

Question 5

Which type of high availability server maintains a backup copy of the entire database that applications can access immediately in the event of a catastrophic failure of the primary server?

A. Remote Standalone Secondary (RSS)

B. High Availability Data Replication (HDR) Secondary

C. Remote Primary Server (RPS)

D. Continuous Log Restore (CLR)

Correct Answer: B

Welcome to TestSimulate

IBM Information Mgmt Informix Technical Mastery Test v3 (P2090-068) Free Practice Test