IBM C2090-312 問題集

質問 1：
You are having problems accessing SYSIBM.SYSTABLES in your data sharing environment and you want to know who is using the table space DSNDB06.SYSTSTAB.
How would you find this information?
A. -DIS BUFFERPOOL (BPO) DB(DSNDB06) SP(SYSTSTAB) LIST(ACTIVE)
B. -DIS DB(DSNDB06) SP(SYSTSTAB) USE
C. -DIS GROUPBUFFERPOOL(GBPO) CONNLIST(YES)
D. -DIS THREAD (') TYPE(SYSTEM)
正解：B

質問 2：
Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the results in a data set or as a result set?
A. ADMIN_INFO_SQL
B. ADMIN_INFO_SYSPARM
C. ADMIN_JOB_QUERY
D. ADMIN UPDATESYSPARM
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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=SERVERENCRYPT
B. TCPALVER=SERVER_SECURE
C. TCPALVER=YES
D. TCPALVER=NO
正解：C

質問 4：
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 table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Local Dynamic Statement Cache.
C. The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic Statement Cache.
D. The PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic Statement Cache.
正解：A

質問 5：
Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
A. A period-specification placed in the FROM clause of a subselect.
B. A period-specification placed in the WHERE clause of a subselect
C. A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect.
D. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal table.
E. A SELECT statement predicate against the transaction start ID of the base table.
正解：D,E

質問 6：
Given this statement:
RUNSTATS TABLESPACE DB1 TS1 RESET ACCESSPATH HISTORY ACCESSPATH
Which statement is FALSE?
A. It externalizes current access paths statistics for DB1 TS1 to HIST catalog tables.
B. It resets all access path statistics for DB1TS1 in the catalog.
C. It invalidates the dynamic statement cache for table space DB1TS1.
D. It resets all real-time statistics (RTS) for DB1TS1.
正解：C

質問 7：
You must be able to process recoveries for DB2 objects to any point in time between now and two weeks ago.
What is the recommended amount of recovery data needed?
A. One set of SHRLEVEL(CHANGE) full images copies at least every week that are kept for at least two weeks as well as the active/archive logs during that time.
B. One set of SHRLEVEL(CHANGE) full images copies during week#1 and one set of SHRLEVEL(REFERENCE) incremental images copies during week #2, all are kept for at least two weeks.
C. One set of SHRLEVEL(CHANGE) full image copies every two weeks that are kept for at least two weeks.
D. One set of SHRLEVEL(CHANGE) full image copy at least every week that are kept for at least three weeks as well as the active/archive logs during that time.
正解：B
解説: (Topexam メンバーにのみ表示されます)