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

A. DBA

B. DBSA

C. DBSSO

D. DBSECADM

Which of the following privileges is NOT valid for a table fragment?

A. ALL

B. INSERT

C. UPDATE

D. CREATE INDEX

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.

Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary tables be created by default? (Choose three.)

A. The rootdbspace.

B. The users' home directory.

C. The $INFORMIXDIR/tmp directory.

D. Thedbspace in which the active database was created.

E. The /tmp directory or PSORT_DBTEMP.

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.

Which statement about Informix data compression is true?

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

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

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

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

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 task function do?

EXECUTE FUNCTION task("storagepool add", "/region2/dbspaces", "0", "0", "20000", "1");

A. Creates a secondstoragepool.

B. Createsdbspace at /region2/dbspaces.

C. Invalid offset and total size forstoragepool add command.

D. Add the directory /region2/dbspaces to the storagepool with a beginning offset of 0, a total size of 0, initial chunk size of 20 MB, and a high priority.

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.

Which of the following gives a good initial estimate for the physical log size?

A. 110% ofrootdbs.

B. 110% the default buffer pool.

C. 110% of the logical log space.

D. 110% of combined buffer pool.