Free IBM C2090-612 Exam Dumps Questions & Answers

What is the result of the command -RECOVER POSTPONEDCANCEL if the postponed- abort thread that you cancel was in the middle of a series of updates when DB2 abended?

• A.  No restrictive state is set. It is your responsibility to ensure data consistency.
• B.  The underlying page sets are stopped.
• C.  The underlying page sets are placed in REFP restrictive state.
• D.  The underlying page sets are placed in REORP restrictive state.

You have to design a table and application layout, in which automatic number generationis used. The application also wants to assign database generated numbers in an SQL UPDATE statement. Which statement is true?

• A.  Identity can deliver this functionality, but Sequence cannot.
• B.  Identity and Sequence can both deliver this functionality.
• C.  Identity cannot deliver this functionality, but Sequence can.
• D.  Neither Identity nor Sequence can deliver this functionality.

On what type of index would an ALTER INDEX ADD COLUMN be allowed?

• A.  An index defined with BUSINESS_TIME WITHOUT OVERLAPS.
• B.  A user defined catalog index.
• C.  An auxiliary index.
• D.  An XML index.

Which stored procedures need to be set up properly in order to register an XML schema?

• A.  XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE
• B.  XSR_ADD_SCHEMA
• C.  The commands to register a XML schema do not invoke stored procedures.
• D.  XSR_REGISTER and XSR_COMPLETE

An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

• A.  col1 is converted to UNICODE
• B.  SQLCode-270: Function not supported
• C.  col2 is converted to EBCDIC
• D.  col2 and col1 are converted to UTF-32