IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 61:

  You are running an UPDATE statement on a table using dbaccess. What kind of lock type is expected?

  A. Byte
  B. Update
  C. Shared
  D. Exclusive
  D. Exclusive

• Question 62:

  The DBA wants to define a replicate as follows:

  

  Which condition must be true for the command to execute successfully?

  A. The table table1 should have col1 as its primary key.
  B. The table table1 should have CRCOLS shadow columns.
  C. The table table1 should have a constraint on column col1.
  D. The table table1 should have an unique index on column col2.
  D. The table table1 should have an unique index on column col2.

• Question 63:

  Which statement is true about log salvaging?

  A. ontape cannot perform salvage of logs.
  B. Log salvaging cannot be avoided if onbar is used for restore.
  C. Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.
  D. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.
  D. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.

• Question 64:

  Which step must be performed to enable Secure Socket Layer (SSL) connections to Informix?

  A. Configure encrypt virtual processors in the ONCONFIG file.
  B. Configure poll threads for SSL connections in the ONCONFIG file.
  C. Specify the SSL connection protocol in the sqlhosts file or registry entry.
  D. Specify the name of the label of the server digital certificate in the ONCONFIG file.
  C. Specify the SSL connection protocol in the sqlhosts file or registry entry.

• Question 65:

  Which two statements are true? (Choose two.)

  A. Logical log files must always reside in rootdbs.
  B. Having too little log space does not affect performance.
  C. Having too much log space does not affect performance.
  D. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.
  E. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.
  C. Having too much log space does not affect performance.
  D. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.

• Question 66:

  What data migration tool(s) should be used to load data from a non-Informix data source?

  A. dbimport
  B. onload and dbload
  C. dbload and High Performance Loader
  D. onload and High Performance Loader
  C. dbload and High Performance Loader

• Question 67:

  Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to-end secure connection?

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

• Question 68:

  What are two requirements for the "ifxclone" utility? (Choose two.)

  A. All databases must use logging.
  B. The source server must be a secondary server.
  C. Only one server clone process can occur at a time.
  D. Both the source and target servers must be part of a trusted network environment.
  E. Both the source and target servers must use the same type of disk space (raw or cooked).
  C. Only one server clone process can occur at a time.
  D. Both the source and target servers must be part of a trusted network environment.

• Question 69:

  To potentially return unused extent pages to the chunk free list, an Informix administrator would execute which storage optimization operation?

  A. Shrink
  B. Repack
  C. Compress
  D. Defragment
  A. Shrink

• Question 70:

  Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?

  A. -1
  C. 1
  D. 30
  B