IBM DB2 11 DBA for z/OS 認定 C2090-312 試験問題:

1. Which address space should be classified with the highest priority WLM service class?

A) IRLM
B) DBM1
C) MSTR
D) DIST

2. Which type of column can be dropped from a table via the ALTER TABLE ... DROP COLUMN ... SQL statement?

A) LOB column
B) DOCID column
C) Hidden ROWID column
D) XML column

3. An application receives an 00C90110 reason code. See the following manual explanation of the code.
" 00C90110
Explanation:
The data manager detected an inconsistent data condition. This may be caused by an inconsistency in either the DB2P' catalog or the DB2 directory. In this case, the OBD for the requested OBID cannot be located in the database descriptor (DBD). The DBD in storage may be inconsistent. Specifically, the OBDDMAP(OBID) array element should contain an offset into the DBD where the OBD should be located. However, in this case the OBD expected was not at the indicated offset.To prevent further damage and possible loss of data, the inconsistency must be corrected before any further SQL access is attempted to this database."
Even though the problem cannot be recreated, you still want to find out what caused this and you want to collect additional information for the IBM support team.
Which utilities and service aids CANNOT help to provide useful additional info to diagnose the problem?

A) DSN1LOGP
B) REPAIR
C) REPORT
D) DIAGNOSE

4. 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) 2G
B) 1G
C) 4G
D) 8G

5. Which global variables statement is true?

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

質問と回答：