A2090-619 Online Practice Questions and Answers

How do the MAX_PDQPRIORITY onconfig parameter and the PDQPRIORITY environment variable work together to constrain access to PDQ resources?

A. PDQPRIORITY is the only constraint.

B. MAX_PDQPRIORITY is the only constraint.

C. The minimum of the two values is the actual constraint.

D. The constraint is MAX_PDQPRIORITY / 100 * PDQPRIORITY / 100.

The DBA updated the uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands:The DBA updated the ?uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands: UPDATE ph_task SET tk_enable = ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name = ?uto_crsd? UPDATE ph_threshold SET value = ?WHERE name = UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name = ? UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name = UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name = ? UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?

A. Compress all tables with less than 5000 rows.

B. Compress and defragment tables with more than 5000 uncompressed rows.

C. Compress, repack and shrink tables with more than 5000 uncompressed rows.

D. Do not compress, repack, shrink and defragment any table with more than 5000 rows.

Which is a valid Pluggable Authentication Module (PAM) mode in Unix?

A. Login mode

B. Client mode

C. Server mode

D. Password mode

To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?

A. Shrink

B. Repack

C. Compress

D. Defragment

What security role is required for you to create trusted-context objects?

A. AAO

B. DBSA

C. DBSSO

D. DBSECADM

The sector option for cdr utility is used to perform what operation?

A. Dynamically convert ER cluster instances in order to perform rolling upgrades.

B. Dynamically convert H/A cluster instances in order to perform rolling upgrades.

C. Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform rolling upgrades.

D. Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.

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

The following message is received: Lock table overflow - user id user32, session id 54. What action should be taken to prevent this problem in the future?

A. Run onclean utility to clear the lock table.

B. Increase the LOCKS configuration parameter.

C. Turn on the AUTO_TUNE configuration parameter.

D. Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.

Which two parameters are mandatory when running "ifxclone"? (Choose two.)

A. Target server instance size.

B. Target server instance name.

C. Source server instance sqlhosts.

D. Target server configuration parameters.

E. Source server instance TCP/IP address.

Click on the exhibit. Which type of join is occurring?

A. Star Join

B. ANSI Join

C. Index Self-Join

D. Multi Index Join