IBM IBM Certified Advanced Database Administrator C2090-610 Questions & Answers

• Question 1:

  What factor influences lock conversion/promotion?

  A. Lock size

  B. Number of locks

  C. Lock mode needed

  D. Available real storage

  Correct Answer: C

• Question 2:

  Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates?

  A. Read Stability (RS)

  B. Cursor Stability (CS)

  C. Repeatable Read (RR)

  D. Uncommitted Read (UR)

  Correct Answer: D

• Question 3:

  If no isolation level is specified, what is the default isolation level used?

  A. Cursor Stability (CS)

  B. Repeatable Read (RR)

  C. Read Stability (RS) with Currently Committed semantics

  D. Cursor Stability (CS) with Currently Committed semantics

  Correct Answer: A

• Question 4:

  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)

  Correct Answer: C

• Question 5:

  When is an INTENT EXCLUSIVE (IX) lock required?

  A. When a transaction intends to read or change data.

  B. When a transaction intends to change but not read data.

  C. When a transaction intends to read but not change data.

  D. When a transaction intends to change the system catalog.

  Correct Answer: A

• Question 6:

  The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?

  A. Concurrent application processes from performing any operations on the table.

  B. Concurrent application processes from performing any read-only operations on the table.

  C. Concurrent applications processes that are running under the cursor stability (CS) isolation level from performing read-only operations on thetable.

  D. Concurrent applications processes that are running under the uncommitted read (UR) isolation level from performing read-only operations onthe table.

  Correct Answer: A

• Question 7:

  What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?

  A. Trigger

  B. Procedure

  C. Table function

  D. Scalar function

  Correct Answer: A

• Question 8:

  Which data type should be used to store data in a column that represents money and accurately returns a two position scale?

  A. BIGINT

  B. BINARY

  C. DOUBLE

  D. DECIMAL

  Correct Answer: D

• Question 9:

  User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?

  A. 1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE CASCADE rule.

  B. 1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE CASCADE rule.

  C. 1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE RESTRICT rule.

  D. 1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE RESTRICT rule.

  Correct Answer: A

• Question 10:

  Which statement about a deadlock is true?

  A. The victim will be rolled back.

  B. The victim will read through the lock.

  C. Both victim and holder are rolled back.

  D. The victim must wait until the holder releases the lock.

  Correct Answer: A