IBM 000-619 Actual Free Exam Questions & Community Discussion

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 following SQL commands: UPDATE ph_task SET tk_enable
= ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name =
? uto_crsd? UPDATE ph_threshold SET value = ?WHERE name =
UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name =
? UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name =
UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name =
? UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?

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

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?

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

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

Which two statements are true?

Which statement is true for starting Connection Manager?

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?