C2090-619 Online Practice Questions and Answers

Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?

A. DIRECT_IO

B. DBUPSPACE

C. AUTO_AIOVPS

D. AUTO_READAHEAD

Which configuration parameter locks the resident and virtual segments of shared memory in operating-system physical memory?

A. SHMSEG

B. SHMBASE

C. RESIDENT

D. INFORMIXSHMLCK

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.

Given the following:

How many locks will be used on tab1 to run the query?

A. 0

B. 1

C. 2

D. Depends on the number of index pages accessed

Given these statements are executed: which statement is true?

A. The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.

B. The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator(IWA).

C. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and OLAP expressions are evaluated by Informix database server.

D. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAPexpressions are evaluated by Informix Warehouse Accelerator (IWA).

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

A. Login mode

B. Client mode

C. Server mode

D. Password mode

Which OpenAdmin Tool feature is used to analyze the state of the Informix database server and can alert the DBA through email?

A. SQL Toolbox

B. Health Advisor

C. Server Administration

D. Performance Analysis

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 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 step must be performed to enable Secure Socket Layer (SSL) connections to Informix?

A. Configure encrypt virtual processors in the ONCONFIG file.

B. Configure poll threads for SSL connections in the ONCONFIG file.

C. Specify the SSL connection protocol in the sqlhosts file or registry entry.

D. Specify the name of the label of the server digital certificate in the ONCONFIG file.