What can be used to generate a custom configuration for DSS and/or OLTP environments?
A. onconfig
B. onstat
C. ifxclone
D. genoncfg
Which of the following statements about the ontape utility is TRUE?
A. Itcan be used to backup a database to a tape device or file system, or directory.
B. It can be used to backup operating system files in addition to databases.
C. It can be used to backup and restore different storage spaces in parallel.
D. It can be used tobackup a database to tape devices only.
Why does a database execute a checkpoint operation?
A. To ensure that runaway queries are stopped before consuming all the system resources.
B. To synchronize the pages in a primary dbspace with a mirrored dbspace.
C. To update statistics for large tables currently being accessed by queries.
D. To synchronize the pages on disk with the pages in the shared-memory buffers.
Which type of high availability server does NOT maintain a copy of the entire physical database in its ownisolated disk space?
A. Remote Primary Server (RPS)
B. Remote Standalone Secondary (RSS)
C. Shared-Disk Secondary (SDS)
D. High Availability Data Replication (HDR) Secondary
What is the primary function of the Informix Connection Manager?
A. To monitorand direct the connection requests from client applications to the appropriate server in the high availability cluster.
B. To monitor and maintain the connections between nodes in an Enterprise Replication environment.
C. To monitor and govern SQL statements submitted by client applications.
D. To monitor and report the connection status of the High Availability Data Replication (HDR) secondary server.
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.
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 statements about the level of compatibility between the backups produced by ontape and ON-Bar is true?
A. You can create a backup with ON-Bar and restore it with ontape, but not vice versa.
B. You can create a backup with ontape and restore it with ON-Bar, but not vice versa.
C. The respective backups are not compatible; you cannot create a backup with ontape and restore it with ON-Bar, or vice versa.
D. The respective backup tapes are compatible; you can create a backup with ontape and restore it with ON-Bar, and vice versa.
Which utility is used to debug SPL routines?
A. OAT (OpenAdmin Tool)
B. dbaccess.
C. IBM Optim Data Studio
D. dbx.
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.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-068 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.