When we use multilevel-security using a security label column, which sentence is true?
A. Multilevel security with row-level checking is enforced when DB2 checks a referential constraint.
B. A referential constraint is not allowed on a security label column.
C. A unique constraint is allowed on a security label column.
D. A check constraint is not allowed on a security label column.
正解:B
質問 2:
What is the least disruptive way of externalizing real-time statistics for table space DB1TS1?
A. -DISPLAY DB(DB1)SPACENAM(TS1)
B. -SET LOG LOGLOAD(O)
C. RUNSTATS TABLESPACE DB1TS1
D. -ACCESS DB(DB1) SPACENAM(TSI) MODE(STATS)
正解:C
質問 3:
If the OPTHINTS subsystem parameter is set to YES, and you issue the following DB2 command relating to optimization parameter hints:
BIND QUERY LOOKUP (YES)
what is the result of the execution of this command?
A. New values are inserted into the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.
B. Messages containing only the status of rows in catalog tables SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN.
C. Updated values are placed in SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.
D. A list of queries that are in error is produced.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
Which statement about an array data type is true?
A. User-defined data types are allowed in an array.
B. Arrays can be used as direct input to a select-statement predicate.
C. An array is a built-in data type and can only be numeric.
D. Associative arrays can only use INTEGER and VARCHAR data types as indexes.
正解:D
質問 5:
The degree of parallelism can vary for the REBUILD INDEX utility.
What action should be taken to limit the use of real memory using the REBUILD INDEX utility?
A. Increase the value in the CURRENT DEGREE special register.
B. Increase the value of the PARALLEL option.
C. Decrease the value of the PARALLEL option.
D. Decrease the value in the CURRENT DEGREE special register.
正解:B
質問 6:
DB2 AUDIT policies are defined by inserting rows into what DB2 Catalog table?
A. SYSIBM.SYSDBAUTH
B. SYSIBM.SYSAUTOALERTS
C. SYSIBM.SYSAUDITPOLICIES
D. SYSIBM.SYSTABLESPROFILES
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
You analyze an accounting report. You see a high "NOT ACCOUNTED" time. Which two events can contribute to this high value?
A. CPU wait time.
B. Real storage paging wait time.
C. Log write wait time.
D. Execution unit switch wait time.
E. I/O read wait time.
正解:C,D
小嶋** -
、辞書として使えるような構成になっていますので持っているだけで便利。見やすく、C2090-312勉強しやすい本だと思いました。