nerdexam
IBM

C2090-558 · Question #34

Click the Exhibit button. In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

The correct answer is D. Client 2 will get an error that the "record is locked" or the "table is locked". See the full explanation below for the reasoning.

Question

Click the Exhibit button. In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

Exhibit

C2090-558 question #34 exhibit

Options

  • AClient 2 will update col2 of the rows having col1=20.
  • BClient 2 will return successfully without updating any rows.
  • CClient 2 will keep waiting for client 1 to finish its transaction.
  • DClient 2 will get an error that the "record is locked" or the "table is locked".

How the community answered

(28 responses)
  • A
    11% (3)
  • B
    4% (1)
  • C
    4% (1)
  • D
    82% (23)

Community Discussion

No community discussion yet for this question.

Full C2090-558 Practice