IBM C2090-312 問題集

質問 1：
What is required before you begin your installation of DB2 11?
A. Data sets for catalog and directory tables must be user-managed.
B. Data sets for only the directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.
C. Data sets for catalog and directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.
D. Data sets for only the catalog tables must be SMS-managed and include a data class for allocating the data sets in extended format.
正解：A

質問 2：
Which technique can be utilized for the reporting of real-time statistics?
A. Query the SYSIBM.SYSTABLES_PROFILES system catalog table.
B. Query the SYSI BM.SYSTABSTATS system catalog table.
C. Call stored procedure SYSPROC.ADMINJNFOJHOST.
D. Call stored procedure SYSPROC.DSNACCOX.
正解：A

質問 3：
A hotel prices its rooms differently at different times of the year. For example, Room 101 rents for $100 per night January through March, $150 per night April through September, and $80 per night October through December.
Which type of table could be used to implement the time-based rate changes?
A. An application-period temporal table
B. A system-period temporal table
C. A rate-period temporal table
D. A range-based temporal table
正解：A

質問 4：
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. Decrease the value in the CURRENT DEGREE special register.
B. Decrease the value of the PARALLEL option.
C. Increase the value of the PARALLEL option.
D. Increase the value in the CURRENT DEGREE special register.
正解：C

質問 5：
Which SQL statement can be used to create a data type that will represent possible speed limit values, with valid values not greater than 99, and to create a table that contains route numbers and the maximum speed limit for each route?
A. CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEEDJJMIT);
B. CREATE TYPE SPEEDJJMIT AS SMALLINT; CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT, MAX_SPEED SPEEDJJMIT);
C. CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. SPEED_LIMIT);
D. CREATE TYPE SPEEDJJMIT USING DECIMAL(2.0); CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEED_LIMIT);
正解：A

質問 6：
Given the following output:
DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS DSNV402I _DB2D ACTIVE THREADS NAME ST A REQ ID AUTHID PLAN ASID TOKEN DB2CALL T 17039 BBISS BBISS 00AF 19855 TSO T * 3 KSTTEST KSTTEST 0135 20172 A51OTEST N* 13 CICSTEST 0125 19625 You receive a call that user KSTTEST is holding resources and needs to be canceled.
Which command should be issued?
A. -CANCEL THREAD( 3)
B. -CANCEL USER(KSTTEST)
C. User KSTTEST does not hold an active connection, no way he blocks anything.
D. -CANCEL THREAD(20172)
正解：A

質問 7：
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. SQL update activities (INSERT. UPDATE, DELETE, MERGE).
C. Changes to the BSDS.
D. REORGwith RBALRSN_CONVERSION EXTENDED.
正解：D
解説: (Topexam メンバーにのみ表示されます)