C2090-619

Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?A . sysdistribB . systablesC . sysindexesD . syscolumnsView AnswerAnswer: A

Which statement is FALSE about Informix Automatic checkpoint Feature?A . Automatic checkpoints cause less logical log activity.B . Automatic checkpoints try to avoid transaction blocking.C . Automatic checkpoints cause the database server to trigger more frequent checkpoints.D . Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm...

Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)A . On-disk encryptionB . Enterprise ReplicationC . Column level encryptionD . High-Availability Data ReplicationE . Server-to-server distributed query communicationView AnswerAnswer: B,D

Which option maximizes performance in an Informix Warehouse (DSS) environment?A . Higher value of LOGBUFC . Higher value of PHYSBUFE . Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORG . SHMTOTAL set to 0 to allow Informix to access all available physical memory.View AnswerAnswer: D

Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?A . DIRECT_IOB . DBUPSPACEC . AUTO_AIOVPSD . AUTO_READAHEADView AnswerAnswer: D

Which threshold setting applies when configuring automatic memory management?A . SHMTOTALB . BUFFERPOOLC . SHMVIRTSIZED . DS_TOTAL_MEMORYView AnswerAnswer: A

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.View AnswerAnswer: D

For a query to be processed by the accelerator, the query or query block should meet the certain criteria. Which statement is FALSE?A . The query or query block must include at least 2 fact tables.B . The query or query block must refer to a subset of the tables...

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.View AnswerAnswer: D

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_CONNECTIONC . Increase the value of NUMFDSERVERS and add more poll threads.D . Increase...