Which option provides the greatest performance benefit in an Informix warehouse environment?
A. Setting lower value of PDQPRIORITY.
B. Setting higher value of DS_TOTAL_MEMORY.
C. Increasing the number of B-Tree cleaners.
D. Setting value of OPT_GOAL configuration variable to 0.
正解:B
質問 2:
Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer
(customer_num); Which catalog table data is NOT updated?
A. syscolumns
B. sysdistrib
C. systables
D. sysindexes
正解:B
質問 3:
Which two parameters are mandatory when running "ifxclone"? (Choose two.)
A. Source server instance TCP/IP address.
B. Target server instance size.
C. Source server instance sqlhosts.
D. Target server configuration parameters.
E. Target server instance name.
正解:A,E
質問 4:
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?
A. Compress all tables with less than 5000 rows.
B. Compress and defragment tables with more than 5000 uncompressed rows.
C. Do not compress, repack, shrink and defragment any table with more than 5000 rows.
D. Compress, repack and shrink tables with more than 5000 uncompressed rows.
正解:D
質問 5:
Where are the Primary Storage Manager catalog tables stored?
A. sysadmin database
B. A location as specified by the PSM_CATALOG_PATH configuration parameter
C. sysmaster database
D. sysutils database
正解:B
質問 6:
store1, store2, store3 and store4 are defined as four servers participating in a GRID.
Which statement is true?
A. The SELECT query will return results from store3 and store4.
B. The SELECT query will return results from store1 and store2.
C. The SELECT query will return results from all grid servers.
D. The SELECT query is not a GRID query.
正解:A
質問 7:
Which option maximizes performance in an Informix Warehouse (DSS) environment?
A. Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.
B. SHMTOTAL set to 0 to allow Informix to access all available physical memory.
C. Higher value of LOGBUFF.
D. Higher value of PHYSBUFF.
正解:B
質問 8:
Which statement is true about restartable restore?
A. Restartable restore is the ability to restart a failed restore using ontape.
B. ontape can perform restartable restores if a backup is taken to disk.
C. Restartable restore is the ability to restart an instance using a restore from some other computer.
D. Restartable restore is the ability to restart a failed restore using onbar.
正解:D