IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 71:

  Which onstat command will allow the gathering of statistics about the Informix Database Scheduler tasks that are currently running or scheduled to be run?

  A. onstat -g dbc
  B. onstat -g sch
  C. onstat -g adm
  D. onstat -g tsk
  A. onstat -g dbc

• Question 72:

  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 73:

  Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?

  A. To avoid LRU flushes.
  B. To ensure the buffer pool is always available.
  C. To ensure theonstat -g ckp report is accurate.
  D. To avoid transaction blocking during checkpoints.
  D. To avoid transaction blocking during checkpoints.

• Question 74:

  Which statement about Informix data compression is true?

  A. Compressing data on one Enterprise Replication (ER) node affects the data on the other ER nodes.
  B. I/O-bound tables, for example, those with bad cache hit ratios, are good candidates for compression.
  C. Compression operations can be executed on a HDR secondary, RS secondary, or SD secondary server.
  D. Compressing data on a primary instance will not compress data on the High-Availability Data Replication (HDR) secondary instance.
  B. I/O-bound tables, for example, those with bad cache hit ratios, are good candidates for compression.

• Question 75:

  Which statement is true when creating a table through a Grid operation with the replication option enabled?

  A. A separate replicate set is created for each table.
  B. ERKEY shadow columns are automatically added to the table.
  C. The replication for the table is defined with the always apply conflict resolution rule.
  D. All servers in the Enterprise Replication domain are included as participants in the replicate created.
  B. ERKEY shadow columns are automatically added to the table.

• Question 76:

  Which two statements are true for onbar only but not for ontape? (Choose two.)

  A. It can apply external programs using filters.
  B. It can restart a restore from the place it failed.
  C. It can back up to or restore from cloud storage.
  D. It can restore data to a given point in time (PIT).
  E. It can execute an external backup and restore.
  B. It can restart a restore from the place it failed.
  D. It can restore data to a given point in time (PIT).

• Question 77:

  Which statement about Informix data compression is NOT true?

  A. It can compress, repack and shrink a table in one command.
  B. There is no Admin API (sysadmin) interface to automatically compress tables.
  C. The 'onstat -g dsk' command can be used to find the progress of currently running compression operations.
  D. The compress, repack,repack_offline, uncompress, and uncompress_offline operations can consume large amounts of logs.
  B. There is no Admin API (sysadmin) interface to automatically compress tables.

• Question 78:

  Under which condition can table fragments NOT be eliminated during query processing?

  A. Tables with non-overlapping fragments and an equality query predicate.
  B. Tables with round-robin distribution scheme and a range query predicate.
  C. Tables with non-overlapping fragments on a single column and a range query predicate.
  D. Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.
  B. Tables with round-robin distribution scheme and a range query predicate.

• Question 79:

  What does the following task function do?

  EXECUTE FUNCTION task("storagepool add", "/region2/dbspaces", "0", "0", "20000", "1");

  A. Creates a secondstoragepool.
  B. Createsdbspace at /region2/dbspaces.
  C. Invalid offset and total size forstoragepool add command.
  D. Add the directory /region2/dbspaces to the storagepool with a beginning offset of 0, a total size of 0, initial chunk size of 20 MB, and a high priority.
  D. Add the directory /region2/dbspaces to the storagepool with a beginning offset of 0, a total size of 0, initial chunk size of 20 MB, and a high priority.

• Question 80:

  Which of the following activities does the Secure-Auditing Facility NOT monitor and record?

  A. Specific rows.
  B. Specific users.
  C. Specific tables.
  D. Specific DML operations.
  A. Specific rows.