IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 91:

  Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?

  A. onbar -E

  B. dbexport

  C. onsmsync

  D. ontape -exp

  Correct Answer: C

• Question 92:

  The purge policy CANNOT be executed for a rolling window table utilizing which method?

  A. By calling the syspurge function.

  B. By the purge_tables task of the Scheduler.

  C. By setting up the server to automatically run the purge policy.

  D. By running ALTER FRAGMENT with the PURGE NOW predicate.

  Correct Answer: D

• Question 93:

  Which OpenAdmin Tool feature is used to analyze the state of the Informix database server and can alert the DBA through email?

  A. SQL Toolbox

  B. Health Advisor

  C. Server Administration

  D. Performance Analysis

  Correct Answer: B

• Question 94:

  Which Informix utility is used to print information about runtime statistics for all threads in the server?

  A. onstat -g sta

  B. onstat -g act

  C. onstat -g rea

  D. onstat -g cpu

  Correct Answer: D

• Question 95:

  How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

  A. Use the 'Committed Read' isolation level.

  B. Use the RETAIN UPDATE LOCKS clause with isolation level.

  C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.

  D. Use the SET TRANSACTION command to with SERIALIZABLE clause.

  Correct Answer: B

• Question 96:

  What is the primary benefit of a Storage Pool?

  A. It allows data to be shared across instances.

  B. It allows data to be shared across dbspaces.

  C. It allows space to automatically be added to dbspaces.

  D. It allows space to be reserved for critical database operations.

  Correct Answer: C

• Question 97:

  Which SQL statement is used to remove detailed statistical information from the sysdistrib catalog table?

  A. UPDATE STATISTICS DISTRIBUTIONS ONLY

  B. UPDATE STATISTICS LOW DROP DISTRIBUTIONS

  C. UPDATE STATISTICS LOW REMOVE DISTRIBUTIONS

  D. UPDATE STATISTICS MEDIUM REMOVE DISTRIBUTIONS

  Correct Answer: B

• Question 98:

  Which fragmentation strategy is capable of generating new fragments automatically?

  A. Fragment by List

  B. Fragment by Range

  C. Fragment By Expression

  D. Fragment by Round Robin

  Correct Answer: B

• Question 99:

  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).

  Correct Answer: CD

• Question 100:

  Which option is available through ifx_grid_connect()?

  A. Rename a replicated database.

  B. Enable use of TimeSeries columns in tables.

  C. Enable automatic creation of templates in a grid.

  D. Defer propagation of DDL statements to other servers in the grid.

  Correct Answer: D