DB2 12 System Administrator for zOS C2090-318 Exam Questions

1. C2090-318 Free Questions C2090-318 Free Questions DB2 12 System Administrator DB2 12 System Administrator for z/OS for z/OS https://www.passquestion.com/C2090-318.html https://www.passquestion.com/C2090-318.html

2. Question 1 Question 1 In any disaster recovery scenario, a direct relationship exists between the frequency at 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? which image copies are taken and sent to the recovery site and which of the following? A. The ability to perform a RESTORE SYSTEM A. The ability to perform a RESTORE SYSTEM B. Time spent rebuilding indexes at disaster site B. Time spent rebuilding indexes at disaster site C. The amount of data that could potentially be lost C. The amount of data that could potentially be lost D. The total number of incremental image copies made D. The total number of incremental image copies made Answer: C Answer: C

3. Question 2 Question 2 Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the Which statement is TRUE if the PARAMDEG_DPSI subsystem parameter is set to the default value of 0? default value of 0? A. Parallelism for DPSI is disabled A. Parallelism for DPSI is disabled B. The DB2 optimizer will not consider DPSI for access path selection B. The DB2 optimizer will not consider DPSI for access path selection C. DB2 creates multiple child tasks but works on one task at a time when DPSI is used to C. DB2 creates multiple child tasks but works on one task at a time when DPSI is used to drive parallelism drive parallelism D. DB2 will use the value specified for the PARAMDEG subsystem parameter to control D. DB2 will use the value specified for the PARAMDEG subsystem parameter to control the degree of parallelism when DPSI is used the degree of parallelism when DPSI is used Answer: D Answer: D

4. Question 3 Question 3 Which of the following commands can be used to show the client correlation Which of the following commands can be used to show the client correlation token in order to find details such as the ip-address. port-address and unique-id token in order to find details such as the ip-address. port-address and unique-id to identify the distributed transaction? to identify the distributed transaction? A. -DISPLAY LOCATION OB. A. -DISPLAY LOCATION OB. B. -DISPLAY DDF DETAIL B. -DISPLAY DDF DETAIL C. -DISPLAY THREADH DETAIL C. -DISPLAY THREADH DETAIL D. -DISPLAY FUNCTION SPECIFIC D. -DISPLAY FUNCTION SPECIFIC Answer: C Answer: C

5. Question 4 Question 4 Which of the following is an advantage of role-based security? Which of the following is an advantage of role-based security? A. If you DROP a role that owns objects, those objects will also be dropped A. If you DROP a role that owns objects, those objects will also be dropped B. Within a trusted connection. DB2 allows multiple roles to be associated with B. Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in time any given thread at any point in time C. Roles are used to provide a more flexible technique than security group C. Roles are used to provide a more flexible technique than security group definitions or userids in assigning and controlling authorization definitions or userids in assigning and controlling authorization D. If a role creates an object, a user requires no additional privileges to access the D. If a role creates an object, a user requires no additional privileges to access the object if the access uses that role as the object owner in the SQL statement object if the access uses that role as the object owner in the SQL statement Answer: A Answer: A

6. Question 5 Question 5 To simulate a new buffer pool size, what buffer pool parameter is used? To simulate a new buffer pool size, what buffer pool parameter is used? A. PGFIX A. PGFIX B. VPSIZE B. VPSIZE C. SPSIZE C. SPSIZE D. AUTOSI2E D. AUTOSI2E Answer: C Answer: C

7. Question 6 Question 6 Which service class does not have a goal, but runs with a fixed dispatching priority above Which service class does not have a goal, but runs with a fixed dispatching priority above all of the other work on the system? all of the other work on the system? A. ONLINE A. ONLINE B. SYSSTC B. SYSSTC C. SYSTEM C. SYSTEM D. SYSOTHER D. SYSOTHER Answer: B Answer: B

8. Question 7 Question 7 At what point in the upgrade process is the catalog migrated to DB2 12? At what point in the upgrade process is the catalog migrated to DB2 12? A. Completion of DSNTIJTC job A. Completion of DSNTIJTC job B. At the completion of CATMAI NT in function level 500 B. At the completion of CATMAI NT in function level 500 C. After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M100) C. After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M100) D. After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M500) D. After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M500) Answer: B Answer: B

9. Question 8 Question 8 Which of the following is TRUE about the SYSCTRL authority? Which of the following is TRUE about the SYSCTRL authority? A. It is designed to allow access to all data directly in DB2 A. It is designed to allow access to all data directly in DB2 B. It is designed not to be a part of the administrative authorizations B. It is designed not to be a part of the administrative authorizations C. It is designed so group privileges cannot be granted to SYSCTRL C. It is designed so group privileges cannot be granted to SYSCTRL D. It is designed to be an administrator in a system with sensitive data D. It is designed to be an administrator in a system with sensitive data Answer: D Answer: D

10. Question 9 Question 9 Which type of trace is used to record transaction-level data that is written when Which type of trace is used to record transaction-level data that is written when the processing for a transaction is completed? the processing for a transaction is completed? A. Audit A. Audit B. Monitor B. Monitor C. Statistics C. Statistics D. Accounting D. Accounting Answer: D Answer: D

11. Question 10 Question 10 Which stored procedures need to be set up in order to register an XML schema? Which stored procedures need to be set up in order to register an XML schema? A. XSR_VALI DATE and XSR_COMPLETE A. XSR_VALI DATE and XSR_COMPLETE B. XSR_REGISTERandXSR_COMPLETE B. XSR_REGISTERandXSR_COMPLETE C. XSR_VALIDATE and XSR_ADDSCHEMADOC C. XSR_VALIDATE and XSR_ADDSCHEMADOC D. XSR ADDSCHEMADOCandXSR COMPLETE D. XSR ADDSCHEMADOCandXSR COMPLETE Answer: B Answer: B