최신IBM DB2 11 System Administrator for z/OS - C2090-317무료샘플문제

A. Image copies would never be needed when using data mirroring.

B. To resolve outstanding units of recovery.

C. If a LOAD or RECOVER utility was active at the time of the disaster.

D. If the RBAinthe BSDS is higher than the RBA in the active log.

A. Use DSNJU003 with the ENDRBA option.

B. Start DB2 using DEFER ALL.

C. Start DB2 using DEFER on catalog and directory.

D. Use DSNJU003 with the STARTRBA option.

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

A. Using the SET_CLIENT_ID option during RRS SIGNON

B. Using the SQL SET statement (eg. SET CURRENT CLIENT J/VRKSTNNAME = 'MYWS*)

C. Setting up a profile using the SPECIAL_REGISTER attribute in SYSIBM.DSNPROFILE ATTRIBUTES table

D. Using the java.sql.Connection.setClientlnfo method

A. A persistent thread will not release an active package at COMMIT or ROLLBACK.

B. A persistent thread will release an active package at every COMMIT or ROLLBACK.

C. A persistent thread will not release an active package at ROLLBACK if there is a REBIND PACKAGE request on that package.

D. A persistent thread will release an active package at COMMIT if there is a REBIND PACKAGE request on that package.

A. SELECT ' FROM TB_A INTERSECT SELECT * FROM TB_B

B. SELECT ' FROM TB_A UNION ALL SELECT ' FROM TB_B

C. SELECT'FROM TB A INTERSECT ALL SELECT * FROM TBB

D. SELECT ' FROM TB_A EXCEPT ALL SELECT ' FROM TB_B

A. BSDS and catalog VSAM data sets should always be protected by the MSTR address space.

B. BSDS and catalog VSAM data sets should always be protected by the SYSADM authority.

C. BSDS and catalog VSAM data sets should always be protected by an external security profile.

D. BSDS and catalog VSAM data sets should always be protected by the BSDS system privilege