Download IBM.pass4sures.C2090-312.2018-06-02.1e.40q.vcex

IBM.pass4sures.C2090-312.2018-06-02.1e.40q.vcexIBM.pass4sures.C2090-312.2018-06-02.1e.40q.vcexIBM.pass4sures.C2090-312.2018-06-02.1e.40q.vcexIBM.pass4sures.C2090-312.2018-06-02.1e.40q.vcexIBM.pass4sures.C2090-312.2018-06-02.1e.40q.vcexIBM.pass4sures.C2090-312.2018-06-02.1e.40q.vcex
Exam IBM DB2 11 DBA for z/OS
Number C2090-312
File Name IBM.pass4sures.C2090-312.2018-06-02.1e.40q.vcex
Size 24 Kb
Posted June 04, 2018

Download




How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%






Demo Questions

Question 1

The TCP/IP Already Verified (TCPALVER) DB2 system parameter controls whether DB2 accepts a TCP/IP connection requests. Which statement is NOT a valid value?


  • A: TCPALVER=NO
  • B: TCPALVER=YES
  • C: TCPALVER=SERVER_SECURE
  • D: TCPALVER=SERVERENCRYPT
Question 2

Which global variables statement is true?


  • A: A global variable is a synonym for special registers.
  • B: Like for special registers, the access to global variables cannot be granted or revoked.
  • C: A global variable is a created DB2 object, which can be instantiated and used by applications.
  • D: Global variables can only be used in native SQL stored procedures and user-defined functions.
Question 3

Which DB2 subsystem parameter limits the number of concurrent active TSO requests?


  • A: IDBACK
  • B: IDFORE
  • C: MAXDBAT
  • D: CONDBAT
Question 4

An Audit report shows that data on the CUSTOMER table was successfully updated by an unknown USERID. 
What other DB2 supplied information could be reviewed to learn more about the updated data?


  • A: BSDS
  • B: SYSIBM.SYSPACKDEP
  • C: DB2 Active and Archive Logs
  • D: SYSIBM.SYSAUDITPOLICIES
Question 5

You want to create a table space without actually creating the underlying data sets until rows are inserted into the corresponding table. 
Which CREATE TABLESPACE statement option and value should you use?


  • A: PRIQTYO
  • B: PRIQTY-1
  • C: DEFINE NO
  • D: DEFER YES
Question 6

Which component is NOT shared between DB2 data sharing members?


  • A: SCA
  • B: IRLM
  • C: DB2 catalog
  • D: DB2 directory
Question 7

You are having problems accessing SYSIBM.SYSTABLES in your data sharing environment and you want to know who is using the table space DSNDB06.SYSTSTAB. 
How would you find this information?


  • A: -DIS THREAD (') TYPE(SYSTEM)
  • B: -DIS DB(DSNDB06) SP(SYSTSTAB) USE
  • C: -DIS GROUPBUFFERPOOL(GBPO) CONNLIST(YES)
  • D: -DIS BUFFERPOOL (BPO) DB(DSNDB06) SP(SYSTSTAB) LIST(ACTIVE)
Question 8

A table space is successfully recovered by using RECOVER TABLESPACE db. ts TOLASTFULLCOPY. This table space is referenced by an index. 
Which statement is true?


  • A: The index has now a status of REFP.
  • B: The index has now a status of RECP.
  • C: The index has now a status of CHKP.
  • D: The index has now a status of RBDP.
Question 9

What is the maximum partition size for a table space created with NUMPARTS 128, a page size of 8K, and a default DSSIZE of 4G?


  • A: 1G
  • B: 2G
  • C: 4G
  • D: 8G
Question 10

Which statement regarding triggers is true?


  • A: A trigger can use global variables and change their contents.
  • B: A trigger can use global variables but cannot change their contents.
  • C: A trigger cannot use global variables but can change their contents.
  • D: A trigger cannot use global variables and cannot change their contents.



Comments