IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 51:

  Role separation provides checks and balances to improve the security of your event-auditing procedures. Which two roles must be associated with group IDs to enable role separation? (Choose two.)

  A. DBSEC: DB Security Officer
  B. AAO: Auditing Analysis Officer
  C. DBASO: DB Audit and Security Officer
  D. DBAMO: DB Audit Management Officer
  E. DBSSO: Database System Security Officer
  B. AAO: Auditing Analysis Officer
  E. DBSSO: Database System Security Officer

• Question 52:

  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.
  C. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.

• Question 53:

  Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

  A. CKPTINTVL
  B. RA_PAGES
  C. CLEANERS
  D. SHMVIRTSIZE
  C. CLEANERS

• Question 54:

  Given these statements are executed:

  

  which statement is true?

  A. The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.
  B. The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator(IWA).
  C. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and OLAP expressions are evaluated by Informix database server.
  D. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAPexpressions are evaluated by Informix Warehouse Accelerator (IWA).
  C. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and OLAP expressions are evaluated by Informix database server.

• Question 55:

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

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

• Question 56:

  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
  A. onstat
  E. OpenAdmin Tool

• Question 57:

  An Enterprise Replication server is a primary server for shared-disk secondary servers. The DBA wants to reduce the replication latency by reducing the number of transactions that are applied before the logs are flushed to disk. What configuration parameter should the DBA modify?

  A. CDR_MAX_TXNS
  B. CDR_TSINSTANCEID
  C. CDR_MAX_FLUSH_SIZE
  D. CDR_LOG_LAG_ACTION
  C. CDR_MAX_FLUSH_SIZE

• Question 58:

  An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?

  A. Increase the value of MAX_INCOMPLETE_CONNECTIONS.
  B. Increase the value of NUMFDSERVERS and add more poll threads.
  C. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.
  D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.
  B. Increase the value of NUMFDSERVERS and add more poll threads.

• Question 59:

  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.
  C. Copy external files to grid servers.
  D. Setup replication automatically in a grid.

• Question 60:

  Consider the following Enterprise Replication command: cdr define template temp1 -c g_serv1 -C ignore -a -d testdb. Which statement is TRUE?

  A. The command defines a template to be realized on servers serv4 and serv5.
  B. The command defines a template to exclude database testdb from replication.
  C. The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.
  D. The command defines a template to replicate the entire database testdb by defining replicates for each of the views and system tables in testdb.
  C. The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.