最新的IBM Informix 11.70 System Administrator - C2090-919免費考試真題

A. Raw devices only.

B. Cooked files, Raw devices and Directories.

C. Cooked file only.

D. Cooked files and Raw devices only.

A. To avoid LRU flushes.

B. To avoid transaction blocking during checkpoints.

C. To ensure the onstat -g ckp report is accurate.

D. To ensure the buffer pool is always available.

A. Locks the table in exclusive mode and releases all free space at the end of the table.

B. Locks the table in exclusive mode and moves all rows to the beginning of the table.

C. Moves all rows to the beginning of the table while users can modify the table.

D. Releases all free space at the end of the table to the dbspace while users can modify the table.

A. It allows a fragment to be defined as a remainder.

B. It cannot be used for indexes.

C. It allows overlapping fragments.

D. It can only be used for numeric columns.

A. Temporary dbspaces can have non-default page sizes.

B. A raw table can be created in a temporary dbspace.

C. Temporary dbspaces are not backed up.

D. Tables stored in temporary dbspaces are not logged.

A. Task that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday.

B. Sensor that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday.

C. Task that forces a checkpoint every 20 minutes from 10am to 10pm, Monday to Friday.

D. Sensor that stores checkpoint information (onstat -g ckp) in the system.

A. The database server will stop processing, then start an automatic backup of the logical-log file and resume normal processing once the automatic back up of the logical-log files is completed.

B. The database server will automatically execute a checkpoint and flush the oldest update to disk.

C. The instance suspends all processing until the next logical-log file is manually added.

D. The database server will make use of any logical-log file available regardless of whether the available file is in sequence or not.