When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER YES is altered toMEMBER CLUSTER NO by the ALTER TABLESPACE command. Which statement is correct?
A. DB2 applies the changes immediately.
B. DB2 does not allow the command.
C. DB2 allows the command only if the table is empty.
D. DB2 places the table space in AREOR (Advisory Reorg).
正解:D
質問 2:
In a data sharing environment, how is the LRSN value created?
A. It is selected from the DB2 catalog.
B. It is derived from the sysplex timer (store clock).
C. It is generated from a sequence object.
D. It is derived fromcombining RBAs from multiple members.
正解:B
質問 3:
In order to retain an access path across a rebind which of the following commands could be used?
A. REBIND PACKAGE(PK1) REOPT(ONCE)
B. BIND PLAN
C. BIND PACKAGE (PK1) EXPLAIN(YES)
D. REBIND PACKAGE (PK1) PLANMGMT(BASIC)
正解:D
質問 4:
Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, C3 CLOB(1K)) ; How many VSAM clusters will DB2 create?
A. 4
B. 5
C. 1
D. 6
正解:D
質問 5:
The billing application has a DB2 referential integrity setof three tables. TABA, TABB and TABC. Daily, Full Image copies are done for the three table spaces related to the three tables. There is a requirement to recover the three table spaces to noon time, which is about 8 hours after the full image copies were run. Which one of the following statements is true about this recovery situation?
A. No recovery is allowed, a QUIESCE utility is missing to create a point of consistency.
B. BSDS contains information useful to find an appropriate RBA to use for the TORBA value.
C. Recovery will need to be done on the children table first.
D. No recovery is allowed since the tables have been updated.
正解:B
質問 6:
Using the -SET LOG command, what logging characteristics CANNOT be modified?
A. Altering DB2 from dual active logging mode to single active logging mode.
B. The number of minutes between the start of successive checkpoints.
C. Add a newly defined active log data set to the active log inventory.
D. The number of log records that DB2 writes between the start of successive checkpoints.
正解:A
質問 7:
The UNLOAD utility can be used to do which of the following functions?
A. Unload rows from a FlashCopy image copy.
B. Unload data from an image copy of an index.
C. Unload rows from an image copy that has rows from a dropped table.
D. Unload compressed data.
正解:D
質問 8:
For monitoring space growth over time, which statistics should NOT be considered?
A. SYSIBM.SYSTABLESPACESTATS
SPACE
SYSIBM.SYSINDEXSPACESTATS
SPACE
B. SYSIBM.SYSTABLEPART_HIST
CARDF, SPACEF
SYSIBM.SYSINDEXPART_HIST
CARDF, SPACEF
C. SYSIBM.SYSTABLESPACE
DSSIZE, AVGROWLEN
SYSIBM.SYSINDEXES
PIECESIZE, AVGKEYLEN
D. SYSIBM.SYSTABLEPART
CARDF, SPACEF
SYSIBM.SYSINDEXPART
CARDF, SPACEF
正解:C
瀬能** -
今回のC2090-612の問題集の内容もすごくわかりやすくて素敵です。また買いに来ます。