IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 31:

  Which two actions will occur when the following command is executed? (Choose two.) UPDATE STATISTICS HIGH AUTO

  A. Stored Procedures will be recompiled.
  B. Update statistics will run high on the table named AUTO.
  C. Update statistics will run high only on the first column of an index.
  D. Update statistics will run high only after the optimizer decides the statistics are too old.
  E. Update statistics will run high only on columns which meet the STATSCHANGE threshold.
  A. Stored Procedures will be recompiled.
  E. Update statistics will run high only on columns which meet the STATSCHANGE threshold.

• Question 32:

  If the DYNAMIC_LOGS onconfig parameter is set to 1 and logical log backups are not occurring, what will happen in the instance when the last logical-log file fills?

  A. The instance suspends all processing until the next logical-log file is manually added.
  B. The database server will automatically execute a checkpoint and flush the oldest update to disk.
  C. The database server will make use of any logical-log file available regardless of whether the available file is in sequence or not.
  D. The database server will stop processing, then start an automatic backup of the logical-log file and resume normal processing once the automatic back up of the logical-log files is completed.
  A. The instance suspends all processing until the next logical-log file is manually added.

• Question 33:

  What does the SP_WAITTIME variable control?

  A. The maximum time allowed for distributed stored procedures to complete.
  B. The maximum amount ofwait time for a reply from an H/A cluster secondary.
  C. The maximum time a user session will wait for a space extension to complete.
  D. The maximum amount ofwait time permitted before an automatic space allocation will begin.
  C. The maximum time a user session will wait for a space extension to complete.

• Question 34:

  Given the following SQL command where the DBSPACETEMP onconfig and environment variables are set to valid dbspaces:

  createtemp table mytemp (columns) with no log;

  inwhat order will the instance evaluate where to place this table?

  A. DBSPACETEMP environment variable, rootdbspace, dbspace where the database was created, DBSPACETEMP onconfig parameter.
  B. DBSPACETEMP environment variable, DBSPACETEMPonconfig parameter, dbspace where the database was created, root dbspace.
  C. DBSPACETEMPonconfig parameter variable, DBSPACETEMP environment variable, root dbspace, dbspace where the database was created.
  D. DBSPACETEMPonconfig parameter variable, root dbspace, dbspace where the database was created, DBSPACETEMP environment variable.
  B. DBSPACETEMP environment variable, DBSPACETEMPonconfig parameter, dbspace where the database was created, root dbspace.

• Question 35:

  How many paging files are required for SD secondary instances?

  A. There should always be two.
  B. It depends on how many CPU VPs you have.
  C. It depends on how many datadbspaces you have.
  D. It depends on how many temporarydbspaces you have.
  A. There should always be two.

• Question 36:

  Given the following SQL statement:

  

  WHEN MATCHED THEN DELETE What does the merge statement do?

  A. Deletes rows in tab2 that match the condition col1 = c1.
  B. Deletes rows in tab1 that match the condition col1 = c1.
  C. Deletes rows in tab1 that match the condition col1 = c1 and deletes rows in tab2 that do not match the condition col1 = c1.
  D. Deletes rows in tab1 that match the condition col1 = c1 and insert rows in tab1 from those in tab2 that do not match the condition.
  B. Deletes rows in tab1 that match the condition col1 = c1.

• Question 37:

  By default, the alarm program gets executed for which event(s)?

  A. All events.
  B. Only for events with Severity code 1.
  C. Only for events with Severity code 5.
  D. Only for events with Severity code greater than 1.
  D. Only for events with Severity code greater than 1.

• Question 38:

  How does the Deployment Assistant enable you to reduce the size of the installation to be deployed?

  A. By limiting the size ofdbspaces.
  B. By removing specific databases.
  C. By removing specific product features.
  D. By removing all free space at the end of a chunk.
  C. By removing specific product features.

• Question 39:

  What is used during Fast Recovery to return pages to the original state?

  A. Logical Log
  B. Physical Log
  C. External Tables
  D. TemporaryDBSpaces
  B. Physical Log

• Question 40:

  Which two options can be used to monitor PDQ resources? (Choose two.)

  A. onstat -l.
  B. onstat -p.
  C. onstat -D.
  D. onstat -g ath.
  E. SET EXPLAIN output.
  D. onstat -g ath.
  E. SET EXPLAIN output.