Which statement about Storage Provisioning is true?

A. Only raw devices can be extended.

B. Only cooked devices can be extended.

C. Only unmirrored spaces can be extended.

D. Mirrored and unmirrored spaces can be extended.

Which fragmentation strategy is capable of generating new fragments automatically?

A. Fragment by List

B. Fragment by Range

C. Fragment By Expression

D. Fragment by Round Robin

Which Informix utility is used to print information about runtime statistics for all threads in the server?

A. onstat -g sta

B. onstat -g act

C. onstat -g rea

D. onstat -g cpu

How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

A. Use the 'Committed Read' isolation level.

B. Use the RETAIN UPDATE LOCKS clause with isolation level.

C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.

D. Use the SET TRANSACTION command to with SERIALIZABLE clause.

Which two statements are true?

A. Temporary dbspaces can have different page sizes.

B. Separate temporary dbspaces are required for each buffer pool.

C. DBSPACETEMP dbspaces can be temporary or standard dbspaces.

D. If rootdbs is mirrored then all the temporary spaces must be mirrored.

E. If DBSPACETEMP is not configured then temporary space will never be used.

Which two statements are true about Informix OpenAdmin Tool? (Choose two.)

A. Informix OpenAdmin Tool does not support multiple languages.

B. Ontape backup can be taken using Informix OpenAdmin Tool.

C. Informix cluster cannot be managed using Informix OpenAdmin Tool.

D. Informix OpenAdmin Tool cannot be used to run the equivalent of onstat commands.

E. SQL explorer feature provides Query Drill Down functionality to analyze SQL statements.

Which two actions can you perform with ontape? (Choose two.)

A. Backup to cloud

B. Restartable restore

C. Backup specific storage spaces

D. Restore specific storage spaces

E. Parallel backup of storage spaces

Which threshold setting applies when configuring automatic memory management?

A. SHMTOTAL

B. BUFFERPOOL

C. SHMVIRTSIZE

D. DS_TOTAL_MEMORY

Which SQL statement is valid to monitor database server sessions?

A. EXECUTE FUNCTION task ("onstat","-g ses");

B. EXECUTE FUNCTION task ("view sessions","all");

C. EXECUTE FUNCTION task ("check sessions","all");

D. EXECUTE FUNCTION task ("check server","sessions");

Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.

A. All users with the EXTEND role can grant it to other users.

B. All users with the default role can register external routines.

C. All users can create external routines in the database server.

D. All users with the EXTEND role can register external routines.