P2090-068 Online Practice Questions and Answers

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

A. Applications with variable and dynamic data records.

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

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

D. High-transaction OLTP workloads.

Which of the following is a Database-level privilege?

A. CONNECT

B. EXECUTE

C. SELECT

D. REFERENCES

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. Indexes are now separated from the data.

D. Table fragments are automatically compressed.

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

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 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.

TheXYZ Company's failover recovery strategy requires a backup site; however, they do not have a constant or uninterrupted communication link to that site. What type of high availability configuration should be used?

A. Two Shared Disk Secondary (SDS) servers with hardware disk mirroring

B. A High Availability Data Replication (HDR) secondary server running in SYNC mode

C. Continuous Log Restore (CLR) with backup and recovery

D. Enterprise Replication (ER)

The physical log is usedto do what?

A. Alert the DBA when the system needs maintenance or tuning.

B. Store a copy of a page from the shared-memory buffer pool before it is modified for the first time.

C. Record error information when a severe error is encountered.

D. Store information about the status of used and free space in a dbspace.