C2090-317 by IBM Valid Free Exam Practice Test

Question 1

In complex DB2 recovery scenarios, it is important to understand the scope of which objects require recovery.
Which DB2 utility provides a list of the names of all table spaces in the table space set that is specified and a list of all the tables in those table spaces?

A. REPORT B. CHECK C. RECOVER D. QUIESCE

Correct Answer: C

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

Question 2

Which utility can be used to reset the copy-pending status?

A. COPYTOCOPY B. REPAIR C. DSN1COPY D. DSNJU003

Correct Answer: B

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

Question 3

Local buffer pool updated pages are queued by data set until they are written out to DASD when which event occurs?

A. A page is added. B. When VPSEQT is reached. C. A COMMIT is executed. D. A system checkpoint is taken.g

Correct Answer: C

Question 4

Which command can be used to adjust the system checkpoint frequency?

A. -SET LOG B. -SET ARCHIVE C. -RECOVER BSDS D. -ARCHIVE LOG

Correct Answer: A

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

Question 5

Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?

A. SYSADM B. SYSOPR C. SECADM D. SQLADM

Correct Answer: C

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

Question 6

What job will check for changes to DB2 that might impact your migration to Version 11 conversion mode?

A. DSNTIJPM B. DSNTIJXA C. DSNTIJTC D. DSNTIJIC

Correct Answer: C

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

IBM DB2 11 System Administrator for z/OS - C2090-317 Exam Practice Test