C2090-919 Online Practice Questions and Answers

Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?

A. To avoid LRU flushes.

B. To ensure the buffer pool is always available.

C. To ensure theonstat -g ckp report is accurate.

D. To avoid transaction blocking during checkpoints.

Which list fragmentation statement is true?

A. It cannot be used for indexes.

B. It allows overlapping fragments.

C. It can only be used for numeric columns.

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

Which connection type can be used for network connections?

A. Sockets

B. Named Pipes

C. Stream Pipes

D. Shared memory

Given the two indexes defined on table tab1:

Which optimization method may be used?

A. STAR_JOIN

B. MULTI_INDEX

C. OUTER_INDEX

D. INDEX_SELFJOIN

What does the following SQL statement do? execute function task("reset sysadmin", "admindbs");

A. Renamessysadmin database to admindbs.

B. Purges all "mon_*" tables in sysadmin database as user admindbs.

C. Turns the whole Database Scheduler off and finally dropssysadmin database.

D. Lockssysadmin database in exclusive mode and recreates it in dbspace admindbs.

Which two statements are true for onbar only but not for ontape? (Choose two.)

A. It can apply external programs using filters.

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

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

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

E. It can execute an external backup and restore.

The ability for Informix to allow database access to users without a local operating system account is:

A. Not allowed.

B. Allowed and calledefault role-Allowed and called default role.

C. Allowed and calledapped users-Allowed and called dapped users.

D. Allowed and calledurrogate users-Allowed and called currogate users.

Which role can create, alter, or delete trusted context objects?

A.DBA

B. DBSA

C. DBSSO

D. DBSECADM

Which statement about Informix data compression is NOT true?

A. It can compress, repack and shrink a table in one command.

B. There is no Admin API (sysadmin) interface to automatically compress tables.

C. The 'onstat -g dsk' command can be used to find the progress of currently running compression operations.

D. The compress, repack,repack_offline, uncompress, and uncompress_offline operations can consume large amounts of logs.

What statement about users accessing a Flexible Grid is true?

A. Every user can execute commands on the Flexible Grid.

B. Only userinformix can execute commands on a Flexible Grid.

C. Users have to be authorized to execute Flexible Grid commands.

D. Commands can only be executed from the node on which the Flexible Grid was created.