IBM C2090-312 問題集

質問 1：
Which table characteristic is a good attribute for the exploitation of hash access?
A. The size of individual rows in the table vary greatly.
B. DB2 uses range scans to access rows in the table.
C. At least 20 rows fit on a data page.
D. DB2 uses sequential lookups to access data in the table.
正解：D

質問 2：
Which statement about an array data type is true?
A. Associative arrays can only use INTEGER and VARCHAR data types as indexes.
B. An array is a built-in data type and can only be numeric.
C. Arrays can be used as direct input to a select-statement predicate.
D. User-defined data types are allowed in an array.
正解：A

質問 3：
You are trying to reduce the transaction CPU cost by using KEEPDYNAMIC(YES). Which subsystem parameter would you increase to improve Local Dynamic Cache Hit Ratio and reduce the number of short prepares?
A. CONTSTOR
B. MAXRBLK
C. MAXKEEPD
D. MAXTEMPS
正解：C

質問 4：
From where does the cross-loader function allow you to load data?
A. From a cursor including XML columns but not including LOB columns.
B. From an input file including all columns.
C. From a cursor including all LOB and XML columns except the ROWID column.
D. From a cursor including LOB columns but not including XML columns.
正解：B

質問 5：
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. Messages containing only the status of rows in catalog tables SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN.
B. New values are inserted into the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.
C. A list of queries that are in error is produced.
D. Updated values are placed in SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You analyze an accounting report. You see a high "NOT ACCOUNTED" time. Which two events can contribute to this high value?
A. Log write wait time.
B. CPU wait time.
C. I/O read wait time.
D. Real storage paging wait time.
E. Execution unit switch wait time.
正解：A,E

質問 7：
Which statement is true for data in columns defined with data type XML?
A. Data stored in XML columns cannot be indexed.
B. It is possible to define the XML column with an INLINEJ.ENGTH.
C. You can partially UPDATE, DELETE from, and INSERT into an XML document.
D. If you want to change an existing XML document, you have to replace the whole document in the XML column.
正解：C