Which is a valid Pluggable Authentication Module (PAM) mode in Unix?
A. Login mode
B. Client mode
C. Server mode
D. Password mode
What are two requirements for the "ifxclone" utility? (Choose two.)
A. All databases must use logging.
B. The source server must be a secondary server.
C. Only one server clone process can occur at a time.
D. Both the source and target servers must be part of a trusted network environment.
E. Both the source and target servers must use the same type of disk space (raw or cooked).
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 command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?
A. onbar -E
B. dbexport
C. onsmsync
D. ontape -exp
Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured? (Choose two.)
A. Memory page size.
B. Total number of available semaphores.
C. Lower-boundary address for shared memory.
D. Total memory presented to the operating system.
E. Maximum operating-system shared-memory segment size.
Which is NOT a valid index fragmentation strategy?
A. Fragment by Range
B. Partition by Expression
C. Fragment by Expression
D. Fragment by Round Robin
What is the purpose of the GRANT ADMIN privilege?
A. Grants the admin privilege to create role separation.
B. Grants the admin privilege to perform DBSA functions.
C. Grants the admin privilege to use the Open Admin Tool.
D. Grants the admin privilege to run SQL administration API commands.
Which configuration parameter can be set to quickly return rows to a user while a query continues processing?
A. OPTOFC
B. OPTMSG
C. OPT_GOAL
D. OPTCOMPIND
When the server is in administration mode, which users are NOT allowed to connect?
A. informix
B. Members of the DBSA group
C. Members of the DBSSO group
D. Users specified by ADMIN_MODE_USERS
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
