IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 121:

  What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

  A. Read stability (RS)
  B. Cursor stability (CS)
  C. Repeatable read (RR)
  D. Uncommitted read (UR)
  C. Repeatable read (RR)

• Question 122:

  Which object can be enabled for compression?

  A. View
  B. Buffer pool
  C. Storage group
  D. Temporary table
  D. Temporary table

• Question 123:

  Which object is used to cache table and index data as it is read from disk?

  A. Database
  B. Buffer pool
  C. Table space
  D. Package cache
  B. Buffer pool

• Question 124:

  When an index is created for a table, where is the metadata for that index stored?

  A. In the table definition.
  B. In the system catalog.
  C. In the schema that the index resides in.
  D. In the metadata of the table the index was created for.
  B. In the system catalog.

• Question 125:

  Which product replaced the Control Center used in versions prior to DB2 v10?

  A. IBM Data Studio
  B. IBM Administrator
  C. IBM Data Manager
  D. IBM Command Center
  A. IBM Data Studio

• Question 126:

  Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?

  A. Share (S)
  B. Update (U)
  C. Exclusive (X)
  D. Intent Exclusive (IX)
  A. Share (S)

• Question 127:

  Which type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced?

  A. Check
  B. Unique
  C. Referential
  D. Informational
  D. Informational

• Question 128:

  Which tool allows users to connect to a DB2 database using a wizard?

  A. Control Center
  B. IBM Data Studio
  C. Universal Connection Expert
  D. DB2 Connection Pool Manager
  B. IBM Data Studio

• Question 129:

  What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

  A. Read stability (RS)
  B. Cursor stability (CS)
  C. Repeatable read (RR)
  D. Uncommitted read (UR)
  C. Repeatable read (RR)

• Question 130:

  If the following result set is desired:

  

  Which SQL statement must be executed?

  A. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS ONLY
  B. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY
  C. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS
  D. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS
  B. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY