A2090-619 Online Practice Questions and Answers

What command unlocks the storage catalogs when using the Primary Storage Manager?

A. onbar -d unlock

B. onpsm -C unlock

C. onmode -C unlock

D. onsmsync -c unlock

Which statement is FALSE regarding SBSPACES?

A. They are recoverable.

B. They do not obey transaction isolation modes.

C. They have read, write, and seek properties similar to a standard UNIX file.

D. Smart large objects within table rows are not required to be retrieved in one statement.

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

A. sqlhosts

B. /etc/services

C. $ONCONFIG

D. /etc/hosts.equiv

Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

A. STATAUTO

B. STATFORCE

C. FORCE AUTO

D. STATCHANGE

You are running an UPDATE statement on a table using dbaccess. What kind of lock type is expected?

A. Byte

B. Update

C. Shared

D. Exclusive

"informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear", "informix_stores");

A. Shuts down the primary server and converts the secondary server to be the primary.

B. Clears the log position of the SDS servers and restarts replication.

C. Converts the shared disk secondary server to a standard server and shuts down the primary server.

D. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

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

A. DELAY_APPLY

B. HDR_TXN_SCOPE

C. LOG_INDEX_BUILDS

D. FAILOVER_TX_TIMEOUT

What kinds of Table Level Restores can be done by the archecker utility?

A. Only logical restore.

B. Only physical restore.

C. Only point in time restore.

D. Physical, logical, and point in time restores.

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 two parameters must be set to a valid value before starting a Shared Disk (SD) Secondary server? (Choose two.)

A. SDS_PAGING

B. SDS_TIMEOUT

C. SDS_TEMPDBS

D. SDS_LOGCHECK

E. SDS_ALTERNATE

Which statement is FALSE?

A. A new index can be created compressed.

B. Attached indexes cannot be compressed.

C. A compressed index can be uncompressed.

D. A compressed index cannot be uncompressed.

Which two statements are true about archecker utility? (Choose two.)

A. Archecker can help developers team to debug procedures.

B. Archecker can do backup testing, fully integrated with onbar and ontape utilities.

C. Archecker can copy data from different servers, even restoring from a remote device.

D. Archecker can use all kind of connections protocols, including shared memory connections.

E. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.

In addition to examining the Connection Manager log file, what are two ways to monitor the Connection Manager status? (Choose two.)

A. onstat

B. onmode

C. oncmsm

D. onmonitor

E. OpenAdmin Tool

Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?

A. sysdistrib

B. systables

C. sysindexes

D. syscolumns

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

A. ATS and RIS files must be in XML format.

B. The replicate must be a mastered replicate.

C. The conflict resolution rule must be always-apply.

D. The WHERE clause in the participant definition must include a TimeSeries column.

E. CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server.