What subsystem parameter in DDF specifies the maximum number of inactive or new connections queued that can be waiting for a DBAT to process the request?
A. MAXDBAT
B. CONDBAT
C. IDTHTOIN
D. MAXCONQN
正解:D
質問 2:
Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?
A. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Global Dynamic Statement Cache.
B. The PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic Statement Cache.
C. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Local Dynamic Statement Cache.
D. The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic Statement Cache.
正解:A
質問 3:
A statement-level access path hint can be applied to which type of SQL statement?
A. Dynamic SQL statements only.
B. Both static and dynamic SQL statements.
C. Statements included in a CREATE PROCEDURE statement only.
D. Static SQL statements only.
正解:A
質問 4:
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 メンバーにのみ表示されます)
質問 5:
The TCP/IP Already Verified (TCPALVER) DB2 system parameter controls whether DB2 accepts a TCP/IP connection requests. Which statement is NOT a valid value?
A. TCPALVER=YES
B. TCPALVER=SERVER_SECURE
C. TCPALVER=NO
D. TCPALVER=SERVERENCRYPT
正解:A
質問 6:
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 メンバーにのみ表示されます)
質問 7:
Which table characteristic is a good attribute for the exploitation of hash access?
A. DB2 uses sequential lookups to access data in the table.
B. DB2 uses range scans to access rows in the table.
C. At least 20 rows fit on a data page.
D. The size of individual rows in the table vary greatly.
正解:A
北条** -
今日はC2090-312試験に合格しました。試験する前に、緊張しました。でも、試験内容を見ると、多くの問題がC2090-312問題集に出ることがあります。