IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 81:

  Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

  A. cdr start
  B. cdr sync
  C. cdr realize
  D. cdr remaster
  D. cdr remaster

• Question 82:

  Which feature can be enabled in Informix?

  A. Automatic addition of a CPU VP.
  B. Automatic addition of an ADM VP.
  C. Automatic extension of storage spaces.
  D. Automatic addition of message log files.
  C. Automatic extension of storage spaces.

• Question 83:

  Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

  A. AUTO_PERF
  B. AUTO_TUNE
  C. AUTO_CONFIG
  D. AUTO_ENABLE
  B. AUTO_TUNE

• Question 84:

  When you take a level 2 backup, what data is backed up?

  A. All new data since the last level 1 backup.
  B. All new data since the last level 2 backup.
  C. All logical logs which have not previously been backed up.
  D. All new data since the last level 0, level 1 or level 2 backup.
  A. All new data since the last level 1 backup.

• Question 85:

  Which communication protocol needs additional configuration besides onconfig and sqlhosts?

  A. TLITCP
  B. IPCSTR
  C. IPCSHM
  D. SOCSSL
  D. SOCSSL

• Question 86:

  Which option provides the greatest performance benefit in an Informix warehouse environment?

  A. Setting lower value of PDQPRIORITY.
  B. Increasing the number of B-Tree cleaners.
  C. Setting higher value of DS_TOTAL_MEMORY.
  D. Setting value of OPT_GOAL configuration variable to 0.
  C. Setting higher value of DS_TOTAL_MEMORY.

• Question 87:

  Which statement accurately describes the mapped user functionality in Informix?

  A. The DBSA can control the access to the database at the table level by creating different security labels for each user.
  B. The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessaryprivileges.
  C. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the hostcomputer.
  D. The DBSA can grant access to the database server to users of the host computer operating system by implementing different authenticationmechanisms for each user.
  C. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the hostcomputer.

• Question 88:

  The 'onstat -k' output is showing '56 lock table overflows'. Which catalog table can be used to display the relevant lock statistics?

  A. syslocks
  B. systables
  C. sysprofile
  D. sysoverflow
  C. sysprofile

• Question 89:

  Which statement about DataBlade modules is true?

  A. All DataBlades located in the $INFORMIXDIR/extend are automatically registered.
  B. All built-in extensions are automatically registered when the extension is first accessed.
  C. All built-in extensions are automatically registered each time the database sever is started.
  D. All built-in extensions are automatically registered when the database server is first initialized.
  B. All built-in extensions are automatically registered when the extension is first accessed.

• Question 90:

  Which parameter is used to enable transactions to complete after failover of the primary server?

  A. HA_FOC_ORDER
  B. FAILOVER_CALLBACK
  C. CLUSTER_TXN_SCOPE
  D. FAILOVER_TX_TIMEOUT
  D. FAILOVER_TX_TIMEOUT