← Back to exam page

Free C2090-320 – DB2 11 Fundamentals for z/OS Practice Test Question

Free demo downloads

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Reduced active logs
  • ○

    Reduced storage use
  • ○

    Higher transaction rates
  • ○

    Reduced lock contention
  • ○

    Increased data availability
Question 5

Why would an SQL statement receive an SQLCODE of +100? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The result of a SELECT INTO statement was an empty table
  • ○

    A rowset FETCH statement encountered one or more error conditions
  • ○

    The statement references an object that is not defined in the DB2 subsystem
  • ○

    An error occurred during the insertion of a row into an optional explanation table
  • ○

    A FETCH statement was executed when the cursor was positioned after the last row of the result table
Question 6

Given the following CREATE VIEW statement and sample data; your login id is “ROGER”. What will be the result for this query?

Select an option, then click Submit answer.

  • ○

    6
  • ○

    5
  • ○

    4
  • ○

    2