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

Download Dump

File Info

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 02, 2018
Downloaded 2



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.









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset