IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 111:

  When executing the following command: execute function sysadmin task("table compress", "customer") what will happen to the customer table?

  A. Only newly added rows will be compressed.

  B. Only existing data will be compressed, new data will remain uncompressed.

  C. Row data and partition blobs will be compressed and any free table space will be released.

  D. Row data and partition blobs will be compressed and the space allocated to the table will remain.

  Correct Answer: C

• Question 112:

  Which statement about DataBlade modules is true?

  A. All DataBlades located in the $INFORMIXDIR/extend are automatically registered.

  B. All built-in extensions are automatically registered when the extension is first accessed.

  C. All built-in extensions are automatically registered each time the database sever is started.

  D. All built-in extensions are automatically registered when the database server is first initialized.

  Correct Answer: B

• Question 113:

  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 in the AQT.

  C. The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.

  D. The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

  Correct Answer: A

• Question 114:

  Which statement is NOT true about a Storage Pool?

  A. You can create multiple storage pools per database server.

  B. You can add, modify, delete, and purge storage pool entries.

  C. Priorities can be used to determine space allocation order.

  D. It consists of any combination of a raw device, a cooked file, or a directory.

  Correct Answer: A

• Question 115:

  Which operation can benefit from PDQ?

  A. Checkpoints

  B. Data replication

  C. DML Statement

  D. Login Log flushing

  Correct Answer: C

• Question 116:

  You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?

  A. stores:sysusers

  B. sysmaster:sysroles

  C. sysuser:sysroleauth

  D. sysmaster:sysusers

  Correct Answer: A

• Question 117:

  Which feature can be enabled in Informix?

  A. Automatic addition of a CPU VP.

  B. Automatic addition of an ADM VP.

  C. Automatic extension of storage spaces.

  D. Automatic addition of message log files.

  Correct Answer: C

• Question 118:

  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.

  Correct Answer: C

• Question 119:

  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.

  Correct Answer: C

• Question 120:

  store1, store2, store3 and store4 are defined as four servers participating in a GRID.

  

  Which statement is true?

  A. The SELECT query is not a GRID query.

  B. The SELECT query will return results from all grid servers.

  C. The SELECT query will return results from store1 and store2.

  D. The SELECT query will return results from store3 and store4.

  Correct Answer: D