IBM Informix 12.10 System Administrator - C2090-619 Exam Practice Test
Which two parameters are mandatory when running "ifxclone"? (Choose two.)
Correct Answer: A,C
Vote an answer
When using the deployment assistant, which two statements are true? (Choose two.)
Correct Answer: C,D
Vote an answer
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?
Correct Answer: C
Vote an answer
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?
Correct Answer: A
Vote an answer
Which SQL statement is used to remove detailed statistical information from the sysdistrib catalog table?
Correct Answer: C
Vote an answer
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?
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?
Correct Answer: B
Vote an answer
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?
How can you determine the relationship between the violations table and the target table later?
Correct Answer: B
Vote an answer
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?
CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?
Correct Answer: D
Vote an answer
In which table can you find a history of all SQL Administration API functions executed in the last 30 days?
Correct Answer: A
Vote an answer