Download IBM.C2090-312.Pass4Sure.2018-06-02.40q.vcex

Download Exam

File Info

Exam IBM DB2 11 DBA for z/OS
Number C2090-312
File Name IBM.C2090-312.Pass4Sure.2018-06-02.40q.vcex
Size 24 KB
Posted Jun 02, 2018
Download IBM.C2090-312.Pass4Sure.2018-06-02.40q.vcex

ProfExam Suite - Black Friday

How to open VCEX & EXAM Files?

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

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
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?


  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

Twitter

Mastodon

Facebook

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files