C1000-078 by IBM Actual Free Exam Questions And Answers

Question 1

When using a persistent thread bound with RELEASE(DEALLOCATE), which subsystem parameter setting will permit a REBIND PACKAGE at a COMMIT or ROLLBACK in this thread?

A. PKGREL COMMIT=YES

B. APPLCOMPAT=YES

C. BINDNV=BIND

D. ABIND=COEXIST

Discussion 0

Correct Answer: B Vote an answer

Question 2

DB2A and DB2B are in the same data sharing group on separate LPARs There are two coupling facilities CF01 and CF02. CF01 contains the Lock and SCA structures and CF02 contains the GBP structures. The group buffer pools are not duplexed. The structures can reside on either CF01 or CF02 as specified in the CRFM policy PREFLIST and AUTOREC is set to YES. CF02 fails and DB2A or DB2B can no longer connect to it. Once they are able to reconnect, what action is necessary in order to minimize loss of data availability?

A. Stop members DB2A and DB2B and initiate a group restart

B. Manually rebuild the GBP structures on CF01

C. No action is needed. Each member performs automatic GRECP recovery

D. No action is needed. The GBP structures are automatically rebuilt in CF02

Discussion 0

Correct Answer: B Vote an answer

Question 3

Where is recovery information for table space DSNDB06.SYSTSCPY stored?

A. BSDS

B. Log

C. SYSIBM.SYSCOPY

D. Directory

Discussion 0

Correct Answer: A Vote an answer

Question 4

Which of the following are TRUE regarding the DSN1PRNT utility? (Choose two)

A. Compressed records cannot be printed in decompressed format

B. It does not decrypt any encrypted data

C. The input can be a list of concatenated DB2 VSAM data sets

D. lt can be executed on both image copies and concurrent copies

E. lt can be executed when the DB2 subsystem is not operational

Discussion 0

Correct Answer: B Vote an answer

Question 5

In any disaster recovery scenario, a direct relationship exists between the frequency at which image copies are taken and sent to the recovery site and which of the following?

A. The total number of incremental image copies made

B. The amount of data that could potentially be lost

C. Time spent rebuilding indexes at disaster site

D. The ability to perform a RESTORE SYSTEM

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

A down level page set is identified by the following error message:
DSNB232I UNEXPECTED DATA SET LEVEL ID ENCOUNTERED
Which of the following should be performed to correct the condition?

A. Replace the object with an appropriate data set at the proper level and confirm with DSN1PRNT of the header page

B. Execute a REORG on the object in question

C. Stop the object, set the DLDFREQ subsystem parameter to OFF. and then restart the object in RW status

D. Execute a REPAIR DBD REBUILD on the object

Discussion 0

Correct Answer: D Vote an answer

Question 7

Which of the following can be accomplished by altering a table to use column access control?

A. Restrict the access to specific rows for all or some users

B. Pre-materialize a view with the changed values provided by the column mask

C. Hide column definitions from the DB2 catalog table SYSIBM.SYSCOLUMNS

D. Modify the values returned for table columns based on column masking definitions

Discussion 0

Correct Answer: D Vote an answer

IBM Db2 12 for z/OS Administrator - C1000-078 Exam Practice Test

Contact Us

Useful Links

Latest Updated