IBM C2090-612 Online Practice Questions and Exam Preparation

IBM C2090-612 Online Questions & Answers

• Question 61:

  The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class 3 Synchronous database I/O time. All of the DB2 objects for the new billing application are in BP5. What command can be used to research the details behind the database I/O time associated with the new billing application?

  A. DISPLAY DDF DETAIL
  B. START TRACE(AUDIT)
  C. DISPLAY BUFFERPOOL(*)
  D. DISPLAY BUFFERPOOL(BP5) LSTATS(ACTIVE) DETAIL
  D. DISPLAY BUFFERPOOL(BP5) LSTATS(ACTIVE) DETAIL

• Question 62:

  Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?

  A. Does not apply to threads that were defined with RELEASE(COMMIT).
  B. Does not apply to threads that were defined with RELEASE(DEALLOCATE).
  C. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next COMMIT point.
  D. Applies to RELEASE(COMMIT) at the next COMMIT point and to RELEASE(DEALLOCATE) at thread end.
  C. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next COMMIT point.

• Question 63:

  Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pending state AND creates an entry in SYSIBM.SYSCOPY?

  A. Run the BACKUP SYSTEM utility.
  B. Run the REPAIR SET NOCOPYPEND utility.
  C. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.
  D. Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 - 10.
  C. Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.

• Question 64:

  Poorly tuned memory can affect application performance, such as having sequential prefetch turned off. Which statistic should you monitor from the statistics report to be sure this is not occurring?

  A. PREF.DISABLED-NO BUFFER
  B. PREF.DISABLED-NO READ ENG
  C. BUFF.UPDATES/PAGES WRITTEN
  D. PAGES WRITTEN PER WRITE I/O
  A. PREF.DISABLED-NO BUFFER

• Question 65:

  The application will be handling a large volume of input data that will need to be added to or update 4 different tables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?

  A. Issue a LOCK TABLE for all 4 tables.
  B. Execute the SQL INSERT before the SQL UPDATE.
  C. Provide an effective commit / restart process.
  D. Run a QUIESCE utility before the process starts.
  C. Provide an effective commit / restart process.

• Question 66:

  You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized?

  A. Audit trace class(4)
  B. Monitor trace class(6)
  C. Performance trace class(3)
  D. Accounting trace class(1,2,3,7,8)
  C. Performance trace class(3)

• Question 67:

  Which privilege allows the execution of the EXPLAIN STMTCACHE ALL SQL statement?

  A. SYSOPR
  B. SYSCTRL
  C. SQLADM
  D. SECADM
  C. SQLADM

• Question 68:

  Which clone table statement is correct?

  A. A clone table can have its own indexes.
  B. A clone table has its own catalog statistics.
  C. The clone and base tables share a table space.
  D. The clone and base tables must have different schema names.
  C. The clone and base tables share a table space.

• Question 69:

  When converting a multiple table segmented table space to partition-by-growth table spaces, which statement is correct?

  A. DSMAX may have to be increased.
  B. Storage requirements for EDMDBDC will decrease.
  C. Storage requirements for some applications will increase.
  D. The dynamic statement cache should be increased to handle the additional SQL statements.
  A. DSMAX may have to be increased.

• Question 70:

  A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?

  A. The data is only stored in the auxiliary table.
  B. The data is only stored in the base table.
  C. The complete data is stored both in auxiliary and in base table.
  D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.
  B. The data is only stored in the base table.