IBM C2090-619 Pack 2021

NEW QUESTION 1
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

Answer: D

NEW QUESTION 2
What is the purpose of the ifx_getMartStat() function?

• A. To display status information about the data mart.
• B. To display update statistics information about the data mart and its tables.
• C. To display statistics about the workers and coordinators defined for the accelerator.
• D. To display status information about the Informix Warehouse Accelerator and all the data marts.

Answer: A

NEW QUESTION 3
What is the earliest version you can migrate / upgrade directly to Informix 12.10?

• A. 7.30
• B. 8.0
• C. 9.40
• D. 10.0

Answer: D

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

• A. Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.
• B. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.
• C. Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.
• D. Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

Answer: B

NEW QUESTION 5
Which communication protocol needs additional configuration besides onconfig and sqlhosts?

• A. TLITCP
• B. IPCSTR
• C. IPCSHM
• D. SOCSSL

Answer: D

NEW QUESTION 6
Which option is available through ifx_grid_connect()?

• A. Rename a replicated database.
• B. Enable use of TimeSeries columns in tables.
• C. Enable automatic creation of templates in a grid.
• D. Defer propagation of DDL statements to other servers in the grid.

Answer: D

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

• A. Web DataBlade
• B. Spatial DataBlade
• C. TimeSeries DataBlade
• D. Excalibur Text DataBlade
• E. High Performance Loader DataBlade

Answer: BC

NEW QUESTION 8
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 contention?

• A. Increase the value of MAX_INCOMPLETE_CONNECTIONS.
• B. Increase the value of NUMFDSERVERS and add more poll threads.
• C. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.
• D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.

Answer: B

NEW QUESTION 9
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

Answer: B

NEW QUESTION 10
Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

• A. ANSI and non-ANSI
• B. Buffered and Unbuffered
• C. Buffered and Non-logging
• D. Non-logging and Unbuffered
• E. Non-logging and Non-logging

Answer: BE

NEW QUESTION 11
Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?

• A. -1
• B. 1
• C. 30

Answer: B

NEW QUESTION 12
To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?

• A. Shrink
• B. Repack
• C. Compress
• D. Defragment

Answer: D

NEW QUESTION 13
What data migration tool(s) should be used to load data from a non-Informix data source?

• A. dbimport
• B. onload and dbload
• C. dbload and High Performance Loader
• D. onload and High Performance Loader

Answer: C

NEW QUESTION 14
The IBM Mobile Database is a mobile-optimized version of which IBM product?

• A. IBM DB2
• B. IBM Informix
• C. IBM solidDB
• D. IBM Cloudscape

Answer: C

NEW QUESTION 15
The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

• A. The user encounters a lock request error.
• B. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.
• C. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.
• D. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

Answer: C

NEW QUESTION 16
What security role is required for you to create trusted-context objects?

• A. AAO
• B. DBSA
• C. DBSSO
• D. DBSECADM

Answer: D

NEW QUESTION 17
The purge policy CANNOT be executed for a rolling window table utilizing which method?

• A. By calling the syspurge function.
• B. By the purge_tables task of the Scheduler.
• C. By setting up the server to automatically run the purge policy.
• D. By running ALTER FRAGMENT with the PURGE NOW predicate.

Answer: D

NEW QUESTION 18
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.

Answer: C

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

• A. You can create audit masks corresponding to row-level events of a specific table.
• B. Selective row-level auditing must be explicitly turned on using the onshowaudit utility.
• C. When you create a table, you can specify if row-level auditing should be enabled for the table.
• D. When you create a database, you can specify if row-level auditing should be enabled for all the tables within the database.

Answer: C

NEW QUESTION 20
Which SQL statement is valid to monitor database server sessions?

• A. EXECUTE FUNCTION task ("onstat","-g ses");
• B. EXECUTE FUNCTION task ("view sessions","all");
• C. EXECUTE FUNCTION task ("check sessions","all");
• D. EXECUTE FUNCTION task ("check server","sessions");

Answer: A

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

• A. Target server instance size.
• B. Target server instance name.
• C. Source server instance sqlhosts.
• D. Target server configuration parameters.
• E. Source server instance TCP/IP address.

Answer: BE

NEW QUESTION 22
Which ONCONFIG parameter would you use to disable the automatic creation or extension of chunks?

• A. SP_WAITTIME
• B. SP_THRESHOLD
• C. SP_AUTOEXPAND
• D. SP_CHUNKEXTEND

Answer: C

NEW QUESTION 23
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

Answer: AE

NEW QUESTION 24
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.

Answer: B

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

• A. Backup to cloud
• B. Restartable restore
• C. Backup specific storage spaces
• D. Restore specific storage spaces
• E. Parallel backup of storage spaces

Answer: AD

NEW QUESTION 26
......