Download IBM DB2 11 DBA for z-OS.C2090-312.Pass4Sure.2018-06-02.40q.vcex

Vendor: IBM
Exam Code: C2090-312
Exam Name: IBM DB2 11 DBA for z/OS
Date: Jun 02, 2018
File Size: 24 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

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?
  1. TCPALVER=NO
  2. TCPALVER=YES
  3. TCPALVER=SERVER_SECURE
  4. TCPALVER=SERVERENCRYPT
Correct answer: B
Question 2
Which global variables statement is true?
  1. A global variable is a synonym for special registers.
  2. Like for special registers, the access to global variables cannot be granted or revoked.
  3. A global variable is a created DB2 object, which can be instantiated and used by applications.
  4. Global variables can only be used in native SQL stored procedures and user-defined functions.
Correct answer: B
Question 3
Which DB2 subsystem parameter limits the number of concurrent active TSO requests?
  1. IDBACK
  2. IDFORE
  3. MAXDBAT
  4. CONDBAT
Correct answer: B
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?
  1. BSDS
  2. SYSIBM.SYSPACKDEP
  3. DB2 Active and Archive Logs
  4. SYSIBM.SYSAUDITPOLICIES
Correct answer: D
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?
  1. PRIQTYO
  2. PRIQTY-1
  3. DEFINE NO
  4. DEFER YES
Correct answer: C
Question 6
Which component is NOT shared between DB2 data sharing members?
  1. SCA
  2. IRLM
  3. DB2 catalog
  4. DB2 directory
Correct answer: C
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?
  1. -DIS THREAD (') TYPE(SYSTEM)
  2. -DIS DB(DSNDB06) SP(SYSTSTAB) USE
  3. -DIS GROUPBUFFERPOOL(GBPO) CONNLIST(YES)
  4. -DIS BUFFERPOOL (BPO) DB(DSNDB06) SP(SYSTSTAB) LIST(ACTIVE)
Correct answer: B
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?
  1. The index has now a status of REFP.
  2. The index has now a status of RECP.
  3. The index has now a status of CHKP.
  4. The index has now a status of RBDP.
Correct answer: C
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?
  1. 1G
  2. 2G
  3. 4G
  4. 8G
Correct answer: C
Question 10
Which statement regarding triggers is true?
  1. A trigger can use global variables and change their contents.
  2. A trigger can use global variables but cannot change their contents.
  3. A trigger cannot use global variables but can change their contents.
  4. A trigger cannot use global variables and cannot change their contents.
Correct answer: B
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!