Free IBM C2090-312 Exam Dumps Questions & Answers

What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?

• A.  4G
• B.  8G
• C.  1G
• D.  2G

Which statement is true?

• A.  Unicode and EBCDIC have a different collating sequence.
• B.  The collating sequence for ASCII and EBCDIC is identical.
• C.  If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation.
• D.  The collating sequence for Unicode and EBCDIC is identical.

Which is NOT a valid value for the KEYWORDS column in the DSN_PROFILES_ATTRIBUTES table?

• A.  MONITOR IDLE THREADS
• B.  MONITOR THREAD
• C.  MONITOR CONNECTIONS
• D.  MONITOR ACTIVE THREADS

What subsystem parameter in DDF specifies the maximum number of inactive or new connections queued that can be waiting for a DBAT to process the request?

• A.  CONDBAT
• B.  MAXCONQN
• C.  IDTHTOIN
• D.  MAXDBAT

Which global variables statement is true?

• A.  Like for special registers, the access to global variables cannot be granted or revoked.
• B.  A global variable is a created DB2 object, which can be instantiated and used by applications.
• C.  Global variables can only be used in native SQL stored procedures and user-defined functions.
• D.  A global variable is a synonym for special registers.