An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?

A. Increase the value of MAX_INCOMPLETE_CONNECTIONS.

B. Increase the value of NUMFDSERVERS and add more poll threads.

C. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.

D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.

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");

Role separation provides checks and balances to improve the security of your event-auditing procedures. Which two roles must be associated with group IDs to enable role separation? (Choose two.)

A. DBSEC: DB Security Officer

B. AAO: Auditing Analysis Officer

C. DBASO: DB Audit and Security Officer

D. DBAMO: DB Audit Management Officer

E. DBSSO: Database System Security Officer

Which two statements are true? (Choose two.)

A. Logical log files must always reside in rootdbs.

B. Having too little log space does not affect performance.

C. Having too much log space does not affect performance.

D. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.

E. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.

After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?

A. sarah

B. karin and dave

C. karin and sarah

D. karin, dave and sarah

Which approach is always valid when migrating data across differing hardware and operating system architectures?

A. dbexport source system then dbimport into target.

B. ontape backup from source then restore backup onto target.

C. onunload the source to tape and onload the tape to the target.

D. Set up HDR primary and secondary between source and target.

Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator? SELECT AVG(SUM(dollars)) OVER() FROM sales;

A. SUM

B. OVER

C. FROM

D. AVG(SUM(dollars))

"informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear", "informix_stores");

A. Shuts down the primary server and converts the secondary server to be the primary.

B. Clears the log position of the SDS servers and restarts replication.

C. Converts the shared disk secondary server to a standard server and shuts down the primary server.

D. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

A. cdr start

B. cdr sync

C. cdr realize

D. cdr remaster

Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

A. DBUPSPACE

B. DS_POOLSIZE

C. VP_MEMORY_CACHE_KB

D. DS_NONPDQ_QUERY_MEM