IBM Assessment: System Administrator for Informix Server 11.70 - A2090-919 Exam Practice Test

A. sysdb

B. sysdblog

C. sysdatabases

D. sysdblogstatus

A. Short checkpoint durations.

B. Optimize decision support memory.

C. Large number of bufferpool buffers.

D. Indexes on searched data.

A. Execute a physical restore on the secondary.

B. Use onmode -d to specify the secondary instance name.

C. Use oninit -v to bring up the secondary.

D. Take a level 0 backup of the primary.

A. I/O-bound tables, for example, those with bad cache hit ratios, are good candidates for compression.

B. Compression operations can be executed on a HDR secondary, RS secondary, or SD secondary server.

C. Compressing data on one Enterprise Replication (ER) node affects the data on the other ER nodes.

D. Compressing data on a primary instance will not compress data on the High-Availability Data Replication (HDR) secondary instance.

A. cdr define onconfig

B. cdr tune onconfig

C. cdr set onconfig

D. cdr change onconfig

A. High-Performance Loader

B. onunload

C. dbload

D. dbexport

A. It can restore data to a given point in time (PIT).

B. It can restart a restore from the place it failed.

C. It can execute an external backup and restore.

D. It can back up to or restore from cloud storage.

E. It can apply external programs using filters.

A. The number and duration of the locks is dependent on the ISOLATION LEVEL.

B. If COMMITTED READ isolation is in place then the SELECT will never encounter any locking errors.

C. Within a transaction the database server will place row or page locks on a nonlogging table.

D. If the SELECT is part of an UPDATE cursor then the database server will place an exclusive lock on the entire dataset.

A. Only for events with Severity code greater than 1.

B. All events.

C. Only for events with Severity code 1.

D. Only for events with Severity code 5.