P2090-068 Online Practice Questions and Answers

The Flexible Grid technology of Informix offers which of the following benefits?

A. The ability to communicate with other non-IBM products.

B. The ability to perform administrative tasks on multiple sites from a single server with no downtime.

C. The ability to replicate data between different versions and editions of Informix.

D. Theability to achieve redundancy using expensive hardware and third party software.

Which disposition type is not allowed withthe ifxclone utility?

A. rss

B. er

C. Blank.

D. sds

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

A. Itsupports a small number of users.

B. Data can be exported to flat files.

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

D. Autonomic features offer near hands-free administration.

Which utility is used to debug SPL routines?

A. OAT (OpenAdmin Tool)

B. dbaccess.

C. IBM Optim Data Studio

D. dbx.

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. Informix Client Software Development Kit (CSDK)

B. IBM Data Server Client

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

D. Informix ODBC Driver

Which of the following components is used to create, schedule, and execute maintenance,monitoring and administrative tasks?

A. Scheduler

B. Optimizer

C. PDQ

D. ON-Bar

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

A. dbaccess

B. onspaces

C. onbar

D. ifxdeploy

In which segment of database shared memory are bufferpools created by default?

A. Resident portion

B. Flash portion

C. Extended portion

D. Volatile portion

Which of the following is a key benefit of Informix?

A. Database extensions can be added to supportnew business problem domains.

B. Chunks can be two gigabytes in size.

C. Uptime of at most 80% can be achieved using continuous availability features.

D. Databases can be administered by a local database administrator.

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.

Which of the following statements aboutFlexible Grid technology is TRUE?

A. It requires high speed interconnect technology between nodes.

B. It works only in a shared disk environment.

C. It requires additional technology for disaster recovery.

D. Both DDL and DML can be performed dynamicallyon all grid nodes from a single server.

Which Informix edition, at a minimum, would permit a Global company to deploy multiple database backup sites for protection against man-made or natural disasters? They want to include oneshared disk secondary, as well as one Remote Secondary Server in their plan.

A. Informix Ultimate-C Edition

B. Informix Growth Edition

C. Informix Ultimate Edition

D. Informix Innovator-C Edition

What is the smallest unit ofphysical I/O in an Informix server?

A. Chunk

B. Extent

C. Page

D. Dbspace

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

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

A. It cannot be used to retrieve locking information.

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

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

D. It can be used to view table data.