IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 101:

  Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

  A. STATAUTO
  B. STATFORCE
  C. FORCE AUTO
  D. STATCHANGE
  D. STATCHANGE

• Question 102:

  Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.

  A. All users with the EXTEND role can grant it to other users.
  B. All users with the default role can register external routines.
  C. All users can create external routines in the database server.
  D. All users with the EXTEND role can register external routines.
  D. All users with the EXTEND role can register external routines.

• Question 103:

  What is the earliest version you can migrate / upgrade directly to Informix 12.10?

  A. 7.30
  B. 8.0
  C. 9.40
  D. 10.0
  D. 10.0

• Question 104:

  Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?

  A. The temp table will be created in datadbs1.
  B. The temp table will be created in root dbspace.
  C. The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.
  D. The temp table will be created round-robin across the dbspaces in DBSPACETEMP.
  B. The temp table will be created in root dbspace.

• Question 105:

  The DBA has defined the following configuration parameters in the onconfig file:

  

  What are the actual values for LMM START THRESHOLD and LMM STOP THRESHOLD computed internally by the database server?

  A. LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB
  B. LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB
  C. LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB
  D. LMM START THRESHOLD = 2% and LMM STOP THRESHOLD = 3% of physical memory in the system
  B. LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB

• Question 106:

  Which two parameters are mandatory when running "ifxclone"? (Choose two.)

  A. Target server instance size.
  B. Target server instance name.
  C. Source server instance sqlhosts.
  D. Target server configuration parameters.
  E. Source server instance TCP/IP address.
  B. Target server instance name.
  E. Source server instance TCP/IP address.

• Question 107:

  Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured? (Choose two.)

  A. Memory page size.
  B. Total number of available semaphores.
  C. Lower-boundary address for shared memory.
  D. Total memory presented to the operating system.
  E. Maximum operating-system shared-memory segment size.
  C. Lower-boundary address for shared memory.
  E. Maximum operating-system shared-memory segment size.

• Question 108:

  Which two statements are true about archecker utility? (Choose two.)

  A. Archecker can help developers team to debug procedures.
  B. Archecker can do backup testing, fully integrated with onbar and ontape utilities.
  C. Archecker can copy data from different servers, even restoring from a remote device.
  D. Archecker can use all kind of connections protocols, including shared memory connections.
  E. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.
  B. Archecker can do backup testing, fully integrated with onbar and ontape utilities.
  E. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.

• Question 109:

  Which two parameters must be set to a valid value before starting a Shared Disk (SD) Secondary server? (Choose two.)

  A. SDS_PAGING
  B. SDS_TIMEOUT
  C. SDS_TEMPDBS
  D. SDS_LOGCHECK
  E. SDS_ALTERNATE
  A. SDS_PAGING
  C. SDS_TEMPDBS

• Question 110:

  Which operation can benefit from PDQ?

  A. Checkpoints
  B. Data replication
  C. DML Statement
  D. Login Log flushing
  C. DML Statement