Up To Date C2090-619 Testing Bible 2021

NEW QUESTION 1
Which Informix utility is used to print information about runtime statistics for all threads in the server?

• A. onstat -g sta
• B. onstat -g act
• C. onstat -g rea
• D. onstat -g cpu

Answer: D

NEW QUESTION 2
When you take a level 2 backup, what data is backed up?

• A. All new data since the last level 1 backup.
• B. All new data since the last level 2 backup.
• C. All logical logs which have not previously been backed up.
• D. All new data since the last level 0, level 1 or level 2 backup.

Answer: A

NEW QUESTION 3
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 4
Which statement is true about restartable restore?

• A. ontape can perform restartable restores if a backup is taken to disk.
• B. Restartable restore is the ability to restart a failed restore using onbar.
• C. Restartable restore is the ability to restart a failed restore using ontape.
• D. Restartable restore is the ability to restart an instance using a restore from some other computer.

Answer: B

NEW QUESTION 5
Which option provides the greatest performance benefit in an Informix warehouse environment?

• A. Setting lower value of PDQPRIORITY.
• B. Increasing the number of B-Tree cleaners.
• C. Setting higher value of DS_TOTAL_MEMORY.
• D. Setting value of OPT_GOAL configuration variable to 0.

Answer: C

NEW QUESTION 6
Click on the exhibit. Which type of join is occurring?

• A. Star Join
• B. ANSI Join
• C. Index Self-Join
• D. Multi Index Join

Answer: A

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

Answer: D

NEW QUESTION 8
Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

• A. AUTO_PERF
• B. AUTO_TUNE
• C. AUTO_CONFIG
• D. AUTO_ENABLE

Answer: B

NEW QUESTION 9
Which parameter is used to enable transactions to complete after failover of the primary server?

• A. HA_FOC_ORDER
• B. FAILOVER_CALLBACK
• C. CLUSTER_TXN_SCOPE
• D. FAILOVER_TX_TIMEOUT

Answer: D

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

• A. Logical Log IO is performed by the LIO VP.
• B. Physical Log IO is performed by the PIO VP.
• C. Logical Log IO is performed by the KAIO VP.
• D. Physical Log IO is performed by the CPU VP.

Answer: D

NEW QUESTION 11
Which type of device does Primary Storage Manager support?

• A. File
• B. Tape
• C. Directory
• D. Named pipe

Answer: A

NEW QUESTION 12
Which operation can benefit from PDQ?

• A. Checkpoints
• B. Data replication
• C. DML Statement
• D. Login Log flushing

Answer: C

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

• A. Dynamically convert ER cluster instances in order to perform rolling upgrades.
• B. Dynamically convert H/A cluster instances in order to perform rolling upgrades.
• C. Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform rolling upgrades.
• D. Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.

Answer: B

NEW QUESTION 14
You have started a violations table for a target table with a non default name. (For example: "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;"). How can you determine the relationship between the violations table and the target table later?

• A. Using dbschema utility
• B. Using 'oncheck -pT' command
• C. Querying sysdepends system catalog table
• D. Querying sysviolations system catalog table

Answer: D

NEW QUESTION 15
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 16
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?

• A. DBUPSPACE
• B. DS_POOLSIZE
• C. VP_MEMORY_CACHE_KB
• D. DS_NONPDQ_QUERY_MEM

Answer: D

NEW QUESTION 17
How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

• A. Use the 'Committed Read' isolation level.
• B. Use the RETAIN UPDATE LOCKS clause with isolation level.
• C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.
• D. Use the SET TRANSACTION command to with SERIALIZABLE clause.

Answer: B

NEW QUESTION 18
Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to- end secure connection?

• A. On-disk encryption
• B. Enterprise Replication
• C. High-Availability Data Replication
• D. Server-to-server distributed query communication

Answer: A

NEW QUESTION 19
The 'onstat -k' output is showing '56 lock table overflows'. Which catalog table can be used to display the relevant lock statistics?

• A. syslocks
• B. systables
• C. sysprofile
• D. sysoverflow

Answer: C

NEW QUESTION 20
Which statement is true for starting Connection Manager?

• A. Only user root and informix.
• B. Any user of the DBSA group.
• C. Any user who is granted privileges to connect to the sysadmin database.
• D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

Answer: D

NEW QUESTION 21
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 22
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

Answer: D

NEW QUESTION 23
......