C2090-619 IBM Informix 12.10 System Administrator Questions and Answers

oninit

onmode

onspaces

onparams

All DataBlades located in the $INFORMIXDIR/extend are automatically registered.

All built-in extensions are automatically registered when the extension is first accessed.

All built-in extensions are automatically registered each time the database sever is started.

All built-in extensions are automatically registered when the database server is first initialized.

Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.

Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.

Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.

Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

ifxdeploy

genoncfg

dbaccess

onparams

TLITCP

IPCSTR

IPCSHM

SOCSSL

Setting lower value of PDQPRIORITY.

Increasing the number of B-Tree cleaners.

Setting higher value of DS_TOTAL_MEMORY.

Setting value of OPT_GOAL configuration variable to 0.

STATAUTO

STATFORCE

FORCE AUTO

STATCHANGE

A new index can be created compressed.

Attached indexes cannot be compressed.

A compressed index can be uncompressed.

A compressed index cannot be uncompressed.

Backup to cloud

Restartable restore

Backup specific storage spaces

Restore specific storage spaces

Parallel backup of storage spaces

All databases must use logging.

The source server must be a secondary server.

Only one server clone process can occur at a time.

Both the source and target servers must be part of a trusted network environment.

Both the source and target servers must use the same type of disk space (raw or cooked).

Shrink

Repack

Compress

Defragment

The user encounters a lock request error.

More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.

More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.

More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

The command defines a template to be realized on servers serv4 and serv5.

The command defines a template to exclude database testdb from replication.

The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.

The command defines a template to replicate the entire database testdb by defining replicates for each of the views and system tables in

testdb.

Install Informix products.

Start Informix servers in a grid.

Copy external files to grid servers.

Setup replication automatically in a grid.

Modify replication server attributes for grid servers.

You can have more than one target server.

You cannot modify a server to change its mode to send-only.

You cannot use this replicate for tables that include TimeSeries columns.

You need to define a different replicate for each send-only primary server.

You can create audit masks corresponding to row-level events of a specific table.

Selective row-level auditing must be explicitly turned on using the onshowaudit utility.

When you create a table, you can specify if row-level auditing should be enabled for the table.

When you create a database, you can specify if row-level auditing should be enabled for all the tables within the database.