IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 31:

  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
  D. Querying sysviolations system catalog table

• Question 32:

  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.
  B. They do not obey transaction isolation modes.

• Question 33:

  Which configuration parameter locks the resident and virtual segments of shared memory in operating-system physical memory?

  A. SHMSEG
  B. SHMBASE
  C. RESIDENT
  D. INFORMIXSHMLCK
  C. RESIDENT

• Question 34:

  The sector option for cdr utility is used to perform what operation?

  A. Dynamically convert ER cluster instances in order to perform rolling upgrades.
  B. Dynamically convert H/A cluster instances in order to perform rolling upgrades.
  C. Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform rolling upgrades.
  D. Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.
  B. Dynamically convert H/A cluster instances in order to perform rolling upgrades.

• Question 35:

  What is the purpose of the ifx_getMartStat() function?

  A. To display status information about the data mart.
  B. To display update statistics information about the data mart and its tables.
  C. To display statistics about the workers and coordinators defined for the accelerator.
  D. To display status information about the Informix Warehouse Accelerator and all the data marts.
  A. To display status information about the data mart.

• Question 36:

  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
  D. AUTO_READAHEAD

• Question 37:

  Which storage manager allows specification of a larger size than others for BAR_XFER_BUF_SIZE?

  A. Informix Storage Manager (ISM)
  B. Informix Primary Storage Manager (PSM)
  C. Informix Secondary Storage Manager (ISSM)
  D. Informix Archive Restore Storage Environment (IARSE)
  B. Informix Primary Storage Manager (PSM)

• Question 38:

  Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)

  A. On-disk encryption
  B. Enterprise Replication
  C. Column level encryption
  D. High-Availability Data Replication
  E. Server-to-server distributed query communication
  B. Enterprise Replication
  D. High-Availability Data Replication

• Question 39:

  When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

  A. LOW_MEMORY_SVR
  B. LOW_MEMORY_MGR
  C. LOW_MEMORY_RESERVE
  D. LOW_MEMORY_PRESERVE
  C. LOW_MEMORY_RESERVE

• Question 40:

  Which SQL statement is valid to monitor database server sessions?

  A. EXECUTE FUNCTION task ("onstat","-g ses");
  B. EXECUTE FUNCTION task ("view sessions","all");
  C. EXECUTE FUNCTION task ("check sessions","all");
  D. EXECUTE FUNCTION task ("check server","sessions");
  A. EXECUTE FUNCTION task ("onstat","-g ses");