P2090-068 Online Practice Questions and Answers

Which of the following is a Database-level privilege?

A. CONNECT

B. EXECUTE

C. SELECT

D. REFERENCES

Which utility is used to debug SPL routines?

A. OAT (OpenAdmin Tool)

B. dbaccess.

C. IBM Optim Data Studio

D. dbx.

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

A. It is only available for Informix Ultimate Edition.

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

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

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

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

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

B. There are more transactions than queries.

C. Database or table logging is turned on.

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

Which Informix utility is useful in debugging failedtransactions, the time period of a transaction, and changes that are made to a tablespace?

A. onlog

B. onload

C. onbar

D. onunload

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

A. Set-column level encryption

B. Cell-level encryption

C. Column-level encryption

D. Network data encryption

Which Informix utility can be used to create a snapshot of an instance, including the data?

A. dbaccess

B. onspaces

C. onbar

D. ifxdeploy

What isthe purpose of the sysmaster database?

A. To provide information about the current state of the database server.

B. To provide an entry point so you can change tablespaces.

C. To allow you to modify data within tables.

D. To allow you to drop a database or any of its tables.

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. The Linux operating system is being used.

D. An entire database needs to be replicated.

What size of business does Informix target?

A. Medium-sized businesses only

B. Small, medium, and large businesses

C. Small businesses only

D. Small businesses with a team of database administrators