Free IBM C2090-556 Exam Dumps Questions & Answers

The following actions occur in order:

What result does User B see?

• A.  A "row locked" error.
• B.  A combined account balance of 110.
• C.  A combined account balance of either 110, 60, or 50 depending on when buffers where flushed to disk.
• D.  A combined account balance of 0.

What result will be returned for User B in the attached exhibit?

• A.  A "row locked" error.
• B.  An account_balance of either 80 or 90 depending on when buffers were last flushed to disk.
• C.  An account_balance of 80.
• D.  An account_balance of 90.

Which two are valid Interval classes of the INTERVAL datatype? (Choose two.)

• A.  Day-time Interval
• B.  Month-day Interval
• C.  Day-second Interval
• D.  Year-month Interval
• E.  Hour-second Interval

What are the two valid methods to obtain trace data for diagnosing JDBC problems with the IBM Data Server Driver for JDBC and SQLJ type 4 connectivity? (Choose two.)

• A.  Set the db2.jcc.override.traceFile property.
• B.  Set the ifx.jcc.override.traceDirectory property.
• C.  Set the ifx.jcc.override.traceFile property.
• D.  Set the db2.jcc.override.traceDirectory property.
• E.  Set the ibm.jcc.override.trace property.

In an ANSI compliant database, what value of SQLCODE indicates a successful query that returned no rows?

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