IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 91:

  Which threshold setting applies when configuring automatic memory management?

  A. SHMTOTAL
  B. BUFFERPOOL
  C. SHMVIRTSIZE
  D. DS_TOTAL_MEMORY
  A. SHMTOTAL

• Question 92:

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

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

• Question 93:

  The purge policy CANNOT be executed for a rolling window table utilizing which method?

  A. By calling the syspurge function.
  B. By the purge_tables task of the Scheduler.
  C. By setting up the server to automatically run the purge policy.
  D. By running ALTER FRAGMENT with the PURGE NOW predicate.
  D. By running ALTER FRAGMENT with the PURGE NOW predicate.

• Question 94:

  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.
  A. The query or query block must include at least 2 fact tables.

• Question 95:

  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
  C. onsmsync

• Question 96:

  Which statement is true regarding the selective row-level auditing feature in Informix?

  A. You can create audit masks corresponding to row-level events of a specific table.
  B. Selective row-level auditing must be explicitly turned on using the onshowaudit utility.
  C. When you create a table, you can specify if row-level auditing should be enabled for the table.
  D. When you create a database, you can specify if row-level auditing should be enabled for all the tables within the database.
  C. When you create a table, you can specify if row-level auditing should be enabled for the table.

• Question 97:

  Which command line utility does NOT have the equivalent functionality using the SQL Administration API?

  A. oninit
  B. onmode
  C. onspaces
  D. onparams
  A. oninit

• Question 98:

  Given the following:

  

  How many locks will be used on tab1 to run the query?

  B. 1
  C. 2
  D. Depends on the number of index pages accessed
  A

• Question 99:

  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.
  C. Row data and partition blobs will be compressed and any free table space will be released.

• Question 100:

  What command unlocks the storage catalogs when using the Primary Storage Manager?

  A. onbar -d unlock
  B. onpsm -C unlock
  C. onmode -C unlock
  D. onsmsync -c unlock
  B. onpsm -C unlock