Free C2090-619 Exam Dumps

Question 11

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?

Correct Answer:C

Question 12

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

Correct Answer:C

Question 13

Role separation provides checks and balances to improve the security of your event- auditing procedures. Which two roles must be associated with group IDs to enable role separation? (Choose two.)

Correct Answer:BE

Question 14

Which configuration parameter can be set to quickly return rows to a user while a query continues processing?

Correct Answer:C

Question 15

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

Correct Answer:C