Free IBM A2090-556 Exam Dumps Questions & Answers

What statement describes the logging restriction that applies to distributed queries?

• A.  Participating databases must have unbuffered logging.
• B.  Participating database must have identical transaction logging types.
• C.  Participating databases must have buffered logging.
• D.  Participating databases must be ANSI-compliant.

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

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

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

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

Which of the following data types is not based on built-in data types?

• A.  Row types
• B.  Named row types
• C.  Distinct types
• D.  Opaque types

Consider the following code:

What action is undertaken if Error -210 is encountered when executing the logic above?

• A.  Action A
• B.  Action A followed by Action C
• C.  Action C
• D.  Action B
• E.  Action C followed by Action A