Printable of C2090-612 free practice questions materials and testing engine for IBM certification for consumer, Real Success Guaranteed with Updated C2090-612 pdf dumps vce Materials. 100% PASS DB2 10 DBA for z/OS exam Today!
2021 Apr C2090-612 Study Guide Questions:
Q81. What should be implemented in order to audit all the activity of the install SYSADM?
A. DATA CAPTURE CHANGES should be set on all tables.
B. A DB2 audit policy should be established, identifying the SYSADM ID to be audited.
C. The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID.
D. Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.
Answer: B
Explanation:
Q82. If security administration is separated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?
A. SYSADM
B. DBADM
C. SECADM
D. INSTALL SYSOPR
Answer: C
Explanation:
Q83. When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the SECURITY clause specify?
A. DB2
B. RACF
C. USER
D. DEFINER
Answer: C
Explanation:
Down to date C2090-612 exam question:
Q84. In a normalized design, in third normal form, the entity defined in the logical design is often transformed in the physical design to which of the following?
A. Index
B. Table
C. Schema
D. Database
Answer: B
Explanation:
Q85. How do you enable parallelism in a dynamic SQL statement?
A. BIND with DEGREE(1)
B. BIND with DEGREE(ANY)
C. Use SET CURRENT DEGREE = ANY
D. Use SET CURRENT DEGREE = '1'
Answer: C
Explanation:
Q86. Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?
A. NUMTCB parameter must be set to 1 for Java stored procedures.
B. NUMTCB parameter must be set to 1 for REXX stored procedures.
C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.
D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities.
Answer: B
Explanation:
Free C2090-612 testing bible:
Q87. Given the following view definition: CREATE VIEW EMPD AS (SELECT D.DEPTNAME, E.LASTNAME FROM DEPT D INNER JOIN EMP E ON D.DEPTNO = E.WORKDEPT); Can an UPDATE statement be used to update the view EMPD on joined tables DEPT and EMP?
A. No, an UPDATE statement against the EMPD view is not allowed at all.
B. Yes, the view EMPD can be updated directly via an UPDATE statement.
C. No, only a clone of the view EMPD can be updated via an UPDATE statement.
D. Yes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is defined on the view.
Answer: D
Explanation:
Q88. Which statement is true about table check constraints?
A. Only one constraint per column is allowed.
B. The LOAD utility cannot enforce the constraint.
C. A constraint placed on a table does not apply to a view defined on the table.
D. A row meets the requirement of the constraint if the condition evaluates to true or unknown.
Answer: D
Q89. Which two parameters would reduce the impact of availability from a REORG with SHRLEVEL CHANGE for a partitioned table space with 16 parts? (Choose two.)
A. LOG NO
B. SORTKEYS 16
C. FASTSWITCH YES
D. AUTOESTSPACE YES
E. DRAIN_WAIT & RETRY
Answer: C,E
Explanation:
Q90. What WLM action will establish performance objectives for DDF threads and their related address space?
A. Insure the NUMTCB is set to a value greater than 10.
B. Specify DDF for the value of APPLENV to the name of the WLM environment.
C. Execute the WLM_REFRESH stored procedure for the DDF application environment.
D. Create a WLM service definition that assigns service classes to the DDF threads.
Answer: D
Explanation: