C2090-619 Exam Questions

Which statement accurately describes the selective row-level auditing feature in Informix?

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

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...

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?

Which of the following is NOT possible during a non-root Informix Server installation?

Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?

Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)

Which threshold setting applies when configuring automatic memory management?

store1, store2, store3 and store4 are defined as four servers participating in a GRID. Which statement is true?

When KAIO is available and raw disk is used, which statement is true?

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...

Which two statements are true about Enterprise Replication of TimeSeries data types? (Choose two.)

Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.

What does the following SQL administration command do? EXECUTE FUNCTION task("onmode", "wi", "/tmp/cfg_20130601");

Which two statements are true about blobspace? (Choose two.)

Which object can be compressed?

Which two statements are true about Informix OpenAdmin Tool? (Choose two.)

Which option maximizes performance in an Informix Warehouse (DSS) environment?

The DBA wants to define a replicate as follows: Which condition must be true for the command to execute successfully?

Which statement is true about restartable restore?

An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock cont...

Consider the following Enterprise Replication command: cdr define template temp1 -c g_serv1 -C ignore -a -d testdb. Which statement is TRUE?

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

Which two actions can you perform with ontape? (Choose two.)

Which command line utility does NOT have the equivalent functionality using the SQL Administration API?

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

Which two statements are true? (Choose two.)

Which statement is FALSE regarding SBSPACES?

Which fragmentation strategy is capable of generating new fragments automatically?

Which option is available through ifx_grid_connect()?

Which statement is true regarding the selective row-level auditing feature in Informix?

Which action can be taken if an instance is down?

Which is NOT a valid index fragmentation strategy?

What is the purpose of the ifx_getMartStat() function?

Which feature can be enabled in Informix?

The DBA has defined the following configuration parameters in the onconfig file: What are the actual values for LMM START THRESHOLD and LMM STOP THRESHOLD computed internally by th...

Which statement about Storage Provisioning is true?

Assuming network connectivity between two Informix instances, which file may need additional configuration to allow distributed queries?

During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?

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?

When configuring Informix server for DRDA connection, which statement is true?

What is the purpose of the GRANT ADMIN privilege?

Which statement is FALSE about dbspace configurable page sizes?

Which two DataBlade extensions can be automatically registered? (Choose two.)

Given these statements are executed: which statement is true?

Which type of device does Primary Storage Manager support?

Which Informix utility can be used to customize the onconfig file?

When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?