Free IBM 000-556 Exam Dumps Questions & Answers

Which of the following is NOT a legal value for the BOOLEAN data type?

• A.  't' for true, and 'f' for false.
• B.  'T' for true, and 'F' for false.
• C.  1 for true, and 0 for false.
• D.  NULL value.

What isolation level allows other users to change rows in your result set, but not the current row you are examining?

• A.  Repeatable Read
• B.  Dirty Read
• C.  Cursor Stability
• D.  Committed Read

The following actions occur in order:

What result does User B see?

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

Which statement combines the actions of the PREPARE, EXECUTE, and FREE statements into a single operation to process most SQL statements?

• A.  EXECUTE NOW
• B.  EXECUTE IMMEDIATE
• C.  EXECUTE DYNAMIC
• D.  EXEC SQL

Which predicate is used in a query to perform searches with Basic Text Search?

• A.  bts_like()
• B.  bts_search()
• C.  bts_in()
• D.  bts_contains()