最新的IBM C2090-317免費考試真題

問題1

Which two features are the motivation behind the conversion to extended RBA/LRSN format?

A. Reduction of the potential for an RBA rollover.

B. Potentially faster UPDATE performance due to greater LRSN granularity.

C. More precise PIT recovery of the DB2 system catalog and directory.

D. Reduced p-Lock contention in the coupling facility due to greater LRSN granularity.

E. Greater RECOVER utility concurrency.

正確答案: C

問題2

Which information uniquely identifies a distributed thread?

A. The TOKEN' field in the -DISPLAY THREAD output.

B. The 'REG' field in the -DISPLAY THREAD output.

C. The 'ASID' field in the -DISPLAY THREAD output.

D. The 'ID' field in the -DISPLAY THREAD output.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題3

What utility can benefit from the additional zllP (IBM System z Integrated Information Processor) enablement inDB2 11?

A. CHECK INDEX

B. RUNSTATS

C. MODIFY STATISTICS

D. COPY

正確答案: B

問題4

The statement cache table, DSN_STATEMENT_CACHE_TABLE. contains information about the SQL statements in the statement cache.
Which SQL statement will NOT capture information from the DB2 dynamic statement cache into this table?

A. EXPLAIN STMTCACHE;

B. EXPLAIN STMTCACHE STMTID integer;

C. EXPLAIN STMTCACHE STMTTOKEN string;

D. EXPLAIN STMTCACHE ALL;

正確答案: A

問題5

Which combination of subsystem parameter values will enable connection pooling for idle distributed database access threads?

A. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT < MAXDBAT.

B. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT = MAXDBAT.

C. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT > MAXDBAT.

D. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT >MAXDBAT.

正確答案: C

說明：（僅 Fast2test 成員可見）

問題6

If a DB2 subsystem fails during start up in the log initialization phase, which two steps are needed in your corrective actions to minimize impact without completing a cold start?

A. Start DB2 using DEFER ALL.

B. Recover the subsystem to the last known system checkpoint in BSDS.

C. Start DB2 using DEFER on catalog and directory.

D. Use DSNJU003 with the ENDRBA option.

E. Use DSNJU003 with the STARTRBA option.

正確答案: B,C

最新的IBM DB2 11 System Administrator for z/OS - C2090-317免費考試真題

聯系我們

站內鏈接

最新更新