Free C2090-556 Exam Braindumps


  • Exam Number: C2090-556
  • Provider: IBM
  • Questions: 115
  • Updated On: 23-Jun-2022

Topic 1, Volume A


QUESTION: 1
What are user created temporary tables used for?

A. To persistently write temporary data to disk.
B. To share result sets across multiple sessions.
C. To access a temporary result set within one session.
D. To automatically delete data based on a time policy.

Answer(s): C
QUESTION: 2
In an ANSI compliant database, what value of SQLCODE indicates a successful query that returned no
rows?

A. 100
B. -330
C. -201
D. -1

Answer(s): A
QUESTION: 3
Which Committed Read isolation level statement is correct?

A. It locks all rows examined.
B. It does not check for locks.
C. It checks for locks after returning a row.
D. It checks for locks before returning a row.

Answer(s): D
QUESTION: 4
Which two values can be used for connection type field from sqlhosts file when using Distributed
Relational Database Architecture (DRDA) protocol? (Choose two.)

A. ontlitcp
B. onipcshm
C. onsoctcp
D. drtlitcp
E. drsoctcp

Answer(s): D, E
QUESTION: 5
Which type of isolation level results in a lock on every row a query examines in order to retrieve any row
from the result set?

A. DIRTY READ
B. COMMITTED READ