C2090-919 Online Practice Questions and Answers

For a given procedure name, what is the objective of the SQL query shown below?

A. The query returns the ordered text form of the specified procedure body.

B. The query returns the ordered compiled form of the specified procedure body.

C. The query returns both ordered text and ordered compiled form of the specified procedure body.

D. The query returns neither the ordered text nor the ordered compiled form of the specified procedure body.

Which role can create, alter, or delete trusted context objects?

A. DBA

B. DBSA

C. DBSSO

D. DBSECADM

Which statement about updating statistics is NOT true?

A. UPDATE STATISTICS HIGH scans the entire table.

B. Data distributions are updated every time UPDATE STATISTICS LOW is executed.

C. UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable.

D. An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE.

Given the SQL explain output of this star join query, which is the fact table?

A. sales

B. product

C. region

D. customer

Which statement about automatic space management is true?

A. Spaces cannot be extended manually.

B. Onlyunmirrored spaces can be extended.

C. Mirrored andunmirrored spaces can be extended.

D. The time interval for low storage space checks is not user configurable.

Which Windows utility is used to configure the SQLHOSTS registry key?

A. ilogin

B. instmgr

C. setnet32

D. oncmsm

What two conditions must be met for direct I/O to occur? (Choose two.)

A. When the I/O is to raw disk space.

B. When the I/O is to cooked disk space.

C. When the table is too big to fit in thebufferpool.

D. When doing I/O operations on temporarydbspaces.

E. When the DIRECT_IO configuration parameter is set to 1.

What does this user-defined task/sensor do?

A. Sensor that stores checkpoint information (onstat -g ckp) in the system.

B. Task that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday.

C. Task that forces a checkpoint every 20 minutes from 10am to 10pm, Monday to Friday.

D. Sensor that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday.

Which onstat command returns an accurate free count of blobspace pages?

A. onstat -d

B. onstat -g blb

C. onstat -d update

D. onstat -d blobinfo

What is used during Fast Recovery to return pages to the original state?

A. Logical Log

B. Physical Log

C. External Tables

D. TemporaryDBSpaces

Which statement regarding the Single Sign-On (SSO) feature is correct?

A. You cannot use the Informix DB-Access client with SSO.

B. The Informix implementation of SSO does not support PAM.

C. Authentication for the DBMS happens when a user first logs in to the client computer or domain.

D. The user is prompted for a password every time a user action tries to access an Informix database.

Which is a valid PAM mode supported by Informix in a UNIX platform?

A. Login mode

B. Client mode

C. Server mode

D. Password mode

Which statement is true when creating a table through a Grid operation with the replication option enabled?

A. A separate replicate set is created for each table.

B. ERKEY shadow columns are automatically added to the table.

C. The replication for the table is defined with the always apply conflict resolution rule.

D. All servers in the Enterprise Replication domain are included as participants in the replicate created.

Which would provide the greatest performance benefit in a warehousing environment?

A. Indexes on searched data.

B. Short checkpoint durations.

C. Large number ofbufferpool buffers.

D. Optimize decision support memory.

Given the following customer table:

A. 1

B. 2

C. 3

D. 4