DB2 will not allow certain processing to occur when the soft limit of RBA TFF800000000'x is reached and an object's RBA remains in basic 6-byte format.
What processing is NEVER allowed?
A. RECOVER to CURRENT.
B. Changes to the BSDS.
C. REORGwith RBALRSN_CONVERSION EXTENDED.
D. SQL update activities (INSERT. UPDATE, DELETE, MERGE).
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement:
ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5;
What should be your next step?
A. REBUILD all of the indexes.
B. REORG the table space.
C. DROP the segmented table space.
D. COPY the table space.
正解:C
質問 3:
When would DB2 NOT use list prefetch?
A. Fast log apply operations.
B. RUNSTATS TABLESPACE without table sampling.
C. Reading leaf pages of a disorganized index.
D. Incremental image copies of a table space defined with TRACKMOD YES.
正解:C
質問 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:
What is required before you begin your installation of DB2 11?
A. Data sets for catalog and directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.
B. Data sets for catalog and directory tables must be user-managed.
C. Data sets for only the catalog tables must be SMS-managed and include a data class for allocating the data sets in extended format.
D. Data sets for only the directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.
正解:B
質問 6:
Arrays are based on a built-in data type. On which built-in data type can an array NOT be based?
A. VARBINARY
B. CLOB
C. XML
D. DBCLOB
正解:C
質問 7:
Which is NOT a valid value for the KEYWORDS column in the DSN_PROFILES_ATTRIBUTES table?
A. MONITOR CONNECTIONS
B. MONITOR IDLE THREADS
C. MONITOR ACTIVE THREADS
D. MONITOR THREAD
正解:B
七*彩 -
先週C2090-312認定資格を取得しました。Pass4Test様がかなり実力をつけてくださったおかげだと思います。
でも最後まで頑張りました。合格できるのは何よりです。