IBM 000-619 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 000-619
Exam Name/Title: IBM Informix 12.10 System Administrator
Certification Provider: IBM
Corresponding Certification: IBM Certified System Administrator

Exam Questions: 130
Updated On: May 29, 2026

Question #25

Which is NOT a feature of onbar backups?

A. The ability to parallelize backups.

B. The ability to do an external backup using a Storage Area Network.

C. The ability to backup without a storage manager.

D. The ability to do a point-in-time restore.

Discussion 0

Correct Answer: C Vote an answer

Question #26

For a query to be processed by the accelerator, the query or query block should meet the certain criteria. Which statement is FALSE?

A. The query or query block must refer to a subset of the tables in the AQT.

B. The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

C. The query or query block must include at least 2 fact tables.

D. The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.

Discussion 0

Correct Answer: C Vote an answer

Question #27

When the server is in administration mode, which users are NOT allowed to connect?

A. Users specified by ADMIN_MODE_USERS

B. Members of the DBSSO group

C. informix

D. Members of the DBSA group

Discussion 0

Correct Answer: B Vote an answer

Question #28

Where are the Primary Storage Manager catalog tables stored?

A. sysadmin database

B. A location as specified by the PSM_CATALOG_PATH configuration parameter

C. sysmaster database

D. sysutils database

Discussion 0

Correct Answer: B Vote an answer

Question #29

Which is NOT a valid index fragmentation strategy?

A. Fragment by Range

B. Fragment by Expression

C. Fragment by Round Robin

D. Partition by Expression

Discussion 0

Correct Answer: C Vote an answer

Question #30

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

A. dbexport

B. ontape -exp

C. onsmsync

D. onbar -E

Discussion 0

Correct Answer: C Vote an answer

Question #31

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

A. Reset the values for dynamically updatable configuration parameters to the default values and save them in onconfig.

B. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" in memory.

C. Apply the new values for all configuration parameters in memory.

D. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" and save them in onconfig.

Discussion 0

Correct Answer: B Vote an answer

Question #32

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_LOG_LAG_ACTION

B. CDR_TSINSTANCEID

C. CDR_MAX_FLUSH_SIZE

D. CDR_MAX_TXNS

Discussion 0

Correct Answer: C Vote an answer

Download Free IBM 000-619 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM 000-619 exam.