NEW QUESTION 1
Which is NOT a component of the IBM Mobile Database offering?

• A. IBM DB2
• B. IBM Informix
• C. IBM solidDB
• D. IBM InfoSphere Warehouse

Answer: D

NEW QUESTION 2
Which statement is FALSE regarding SBSPACES?

• A. They are recoverable.
• B. They do not obey transaction isolation modes.
• C. They have read, write, and seek properties similar to a standard UNIX file.
• D. Smart large objects within table rows are not required to be retrieved in one statement.

Answer: B

NEW QUESTION 3
Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

• A. STATAUTO
• B. STATFORCE
• C. FORCE AUTO
• D. STATCHANGE

Answer: D

NEW QUESTION 4
Which is a valid Pluggable Authentication Module (PAM) mode in Unix?

• A. Login mode
• B. Client mode
• C. Server mode
• D. Password mode

Answer: D

NEW QUESTION 5
The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

• A. The user encounters a lock request error.
• B. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.
• C. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.
• D. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

Answer: C

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

• A. Shrink
• B. Repack
• C. Compress
• D. Defragment

Answer: D

NEW QUESTION 7
Which configuration parameter can toggle the automatic expansion of storage spaces?

• A. SP_AUTOGROW
• B. SP_AUTO_SPACE
• C. SP_AUTOEXPAND
• D. SP_EXPAND_ENABLE

Answer: C

NEW QUESTION 8
The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

• A. The table has a ROWID shadow column.
• B. The table has a Fragment By Range index.
• C. The table has a Unique Key being used by ER.
• D. The Fragment Key is defined with multiple columns.
• E. The Primary Key for the table is referenced by a foreign key constraint.

Answer: AE

NEW QUESTION 9
Which two statements are true about archecker utility? (Choose two.)

• A. Archecker can help developers team to debug procedures.
• B. Archecker can do backup testing, fully integrated with onbar and ontape utilities.
• C. Archecker can copy data from different servers, even restoring from a remote device.
• D. Archecker can use all kind of connections protocols, including shared memory connections.
• E. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.

Answer: BE

NEW QUESTION 10
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. Compress, repack and shrink tables with more than 5000 uncompressed rows.
• D. Do not compress, repack, shrink and defragment any table with more than 5000 rows.

Answer: C

NEW QUESTION 11
Which log file CANNOT be rotated using the default "message log rotate" SQL admin command?

• A. audit log
• B. message log
• C. onbar debug log
• D. onbar activity log

Answer: A

NEW QUESTION 12
Which objects can be compressed?

• A. CLOBs
• B. smart BLOBs
• C. partition BLOBs
• D. blobspace BLOBs

Answer: C

NEW QUESTION 13
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_IO
• B. DBUPSPACE
• C. AUTO_AIOVPS
• D. AUTO_READAHEAD

Answer: D

NEW QUESTION 14
Which statement is true regarding default roles?

• A. The DBSA can define a default role to assign only to the PUBLIC group for a particular database.
• B. The privileges associated with a default role takes precedence over the privileges granted to an individual user.
• C. The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.
• D. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

Answer: C

NEW QUESTION 15
Which two tasks can be performed through an Informix Grid? (Choose two.)

• A. Install Informix products.
• B. Start Informix servers in a grid.
• C. Copy external files to grid servers.
• D. Setup replication automatically in a grid.
• E. Modify replication server attributes for grid servers.

Answer: CD

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

• A. onstat
• B. onmode
• C. oncmsm
• D. onmonitor
• E. OpenAdmin Tool

Answer: AE

NEW QUESTION 17
When you take a level 2 backup, what data is backed up?

• A. All new data since the last level 1 backup.
• B. All new data since the last level 2 backup.
• C. All logical logs which have not previously been backed up.
• D. All new data since the last level 0, level 1 or level 2 backup.

Answer: A

NEW QUESTION 18
What does the following SQL administration command do? EXECUTE FUNCTION task("onmode", "wi", "/tmp/cfg_20130601");

• A. Apply the new values for all configuration parameters in memory.
• B. Reset the values for dynamically updatable configuration parameters to the default values and save them in onconfig.
• C. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" in memory.
• D. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" and save them in onconfig.

Answer: C

NEW QUESTION 19
Which statement is true for starting Connection Manager?

• A. Only user root and informix.
• B. Any user of the DBSA group.
• C. Any user who is granted privileges to connect to the sysadmin database.
• D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

Answer: D

NEW QUESTION 20
When configuring Informix server for DRDA connection, which statement is true?

• A. The connection protocol must be drsoctcp.
• B. The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.
• C. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.
• D. The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

Answer: C

NEW QUESTION 21
Which option maximizes performance in an Informix Warehouse (DSS) environment?

• A. Higher value of LOGBUFF.
• B. Higher value of PHYSBUFF.
• C. Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.
• D. SHMTOTAL set to 0 to allow Informix to access all available physical memory.

Answer: D

NEW QUESTION 22
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?

• A. Using dbschema utility
• B. Using 'oncheck -pT' command
• C. Querying sysdepends system catalog table
• D. Querying sysviolations system catalog table

Answer: D

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

• A. onbar -E
• B. dbexport
• C. onsmsync
• D. ontape -exp

Answer: C

NEW QUESTION 24
Which statement about Storage Provisioning is true?

• A. Only raw devices can be extended.
• B. Only cooked devices can be extended.
• C. Only unmirrored spaces can be extended.
• D. Mirrored and unmirrored spaces can be extended.

Answer: C

NEW QUESTION 25
......