C2090-619 Online Practice Questions and Answers

Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?

A. The temp table will be created in datadbs1.

B. The temp table will be created in root dbspace.

C. The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.

D. The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

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

A. Login mode

B. Client mode

C. Server mode

D. Password mode

Which statement is true for starting Connection Manager?

A. Only user root and informix.

B. Any user of the DBSA group.

C. Any user who is granted privileges to connect to the sysadmin database.

D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

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.

An Enterprise Replication server is a primary server for shared-disk secondary servers. The DBA wants to reduce the replication latency by reducing the number of transactions that are applied before the logs are flushed to disk. What configuration parameter should the DBA modify?

A. CDR_MAX_TXNS

B. CDR_TSINSTANCEID

C. CDR_MAX_FLUSH_SIZE

D. CDR_LOG_LAG_ACTION

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.

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

A. Star Join

B. ANSI Join

C. Index Self-Join D. Multi Index Join

The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

A. The table has a ROWID shadow column.

B. The table has a Fragment By Range index.

C. The table has a Unique Key being used by ER.

D. The Fragment Key is defined with multiple columns.

E. The Primary Key for the table is referenced by a foreign key constraint.

What is the primary benefit of a Storage Pool?

A. It allows data to be shared across instances.

B. It allows data to be shared across dbspaces.

C. It allows space to automatically be added to dbspaces.

D. It allows space to be reserved for critical database operations.

The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

A. The user encounters a lock request error.

B. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.

C. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.

D. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.