IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 1:

  What ONCONFIG parameter can be tuned to increase memory for hash joins?

  A. RESIDENT
  B. EXTSHMADD
  C. VP_MEMORY_CACHE_KB
  D. DS_NONPDQ_QUERY_MEM
  D. DS_NONPDQ_QUERY_MEM

• Question 2:

  Consider the following selective row-level auditing example:

  

  How many entries will be added to the audit file?

  B. 3
  C. 5
  D. 8
  C. 5

• Question 3:

  Which storage space should be used to store columns defined as a BLOB or a CLOB?

  A. sbspace
  B. dbspace
  C. extspace
  D. blobspace
  A. sbspace

• Question 4:

  Which is a valid PAM mode supported by Informix in a UNIX platform?

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

• Question 5:

  Which of the following privileges is NOT valid for a table fragment?

  A. ALL
  B. INSERT
  C. UPDATE
  D. CREATE INDEX
  D. CREATE INDEX

• Question 6:

  Which of the following is NOT a step in setting up HDR for the first time?

  A. Take a level 0 backup of the primary.
  B. Useoninit -v to bring up the secondary.
  C. Execute a physical restore on the secondary.
  D. Useonmode -d to specify the secondary instance name.
  B. Useoninit -v to bring up the secondary.

• Question 7:

  Which of the following gives a good initial estimate for the physical log size?

  A. 110% ofrootdbs.
  B. 110% the default buffer pool.
  C. 110% of the logical log space.
  D. 110% of combined buffer pool.
  D. 110% of combined buffer pool.

• Question 8:

  Which statement about the scope of UPDATE STATISTICS is true?

  A. If the FOR PROCEDURE keywords are included but the name of any SPL routine is not specified, an error will be returned.
  B. If the FOR TABLE keywords are used without specifying the name or synonym of a table, the database will not recalculate distributions for any table in the current database.
  C. If the FOR TABLE keywords are specified with a table but without specifying a list of columns, the database server will not recalculate distributions on all of the columns of the specified table.
  D. If the FOR PROCEDURE specification, Table and Column Scope, and Resolution clauses are NOT included, then the statistics are updated for every table and SPL routine in the current database.
  D. If the FOR PROCEDURE specification, Table and Column Scope, and Resolution clauses are NOT included, then the statistics are updated for every table and SPL routine in the current database.

• Question 9:

  What two conditions must be met for direct I/O to occur? (Choose two.)

  A. When the I/O is to raw disk space.
  B. When the I/O is to cooked disk space.
  C. When the table is too big to fit in thebufferpool.
  D. When doing I/O operations on temporarydbspaces.
  E. When the DIRECT_IO configuration parameter is set to 1.
  B. When the I/O is to cooked disk space.
  E. When the DIRECT_IO configuration parameter is set to 1.

• Question 10:

  Given the following customer table:

  

  A. 1
  B. 2
  C. 3
  D. 4
  B. 2