[Free] 2017(Nov) EnsurePass Testking IBM C2090-312 Dumps with VCE and PDF 31-40

EnsurePass
2017 Nov IBM Official New Released C2090-312
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-312.html

IBM DB2 11 DBA for z/OS

Question No: 31

Which statement is true if a table space is created using the quot;FOR UPDATE nnquot; (where nn is a number) clause?

  1. The first nn UPDATE operation(s) will use an indirect reference.

  2. Only the first nn UPDATE operation(s) on the table will be processed.

  3. nn% space is reserved per page for future UPDATE operations to reduce indirect reference.

  4. nn row locations per page are kept for future UPDATE operations to reduce indirect reference.

Answer: A

Question No: 32

You have defined the array type PHONENUMBERS using the following DDL: CREATE TYPE PHONENUMBERS AS DECIMAL(10,0) ARRAY[50];

You also defined a variable named RECENT_CALLS based on this new array type as follows:

CREATE VARIABLERECENT_CALLS PHONENUMBERS:

Which SQL statement would you use to set the variable LIST_SIZE to the maximum array size allowed for the variable RECENT_CALLS?

  1. SET LIST_SIZE = MAX(RECENT_CALLS)

  2. SET LIST_SIZE = ARRAY_MAX(RECENT_CALLS)

  3. SET LIST_SIZE = ARRAY_LAST(RECENT_CALLS)

  4. SET LIST_SIZE = MAX_CARDINALITY(RECENT_CALLS)

Answer: B

Question No: 33

Which type of column can be dropped from a table via the ALTER TABLE … DROP COLUMN … SQL statement?

  1. XML column

  2. LOB column

  3. DOCID column

  4. Hidden ROWID column

Answer: A

Question No: 34

What is a general recommendation for when to rebind?

  1. After a backup is taken.

  2. After a subsystem restart.

  3. Before maintenance is applied.

  4. After a major change in data volume.

Answer: B

Question No: 35

What keyword establishes the maximum partition size of a partition-by-growth universal table space?

  1. PART

  2. DSSIZE

  3. SEGSIZE

  4. MAXPARTITIONS

Answer: C

Question No: 36

What catalog table provides the information about missing or conflicting catalog statistics for SQL statements?

  1. SYSIBM.SYSGUERYSEL

  2. SYSIBM.SYSTATFEEDBACK

  3. SYSIBM.SYSVARIABLES_TEXT

  4. SYSIBM.SYSOUERYPREDICATE

Answer: B

Question No: 37

If the OPTHINTS subsystem parameter is set to YES, and you issue the following DB2 command relating to optimization parameter hints:

BIND QUERY LOOKUP (YES)

what is the result of the execution of this command?

  1. A list of queries that are in error is produced.

  2. Updated values are placed in SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.

  3. New values are inserted into the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.

  4. Messages containing only the status of rows in catalog tables SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN.

Answer: B

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.comref/src/tpc

/db2z_cmd_bindquery.dita?cp=SSEPEK_11.0.0/10-1-1-0-0-2

Question No: 38

Given the following output:

DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS – DSNV402I _DB2D ACTIVE THREADS –

NAME ST A REQ ID AUTHID PLAN ASID TOKEN DB2CALL T 17039 BBISS BBISS 00AF 19855 TSO T * 3 KSTTEST KSTTEST 0135 20172

A51OTEST N* 13 CICSTEST 0125 19625

You receive a call that user KSTTEST is holding resources and needs to be canceled. Which command should be issued?

  1. -CANCEL THREAD( 3)

  2. -CANCEL THREAD(20172)

  3. -CANCEL USER(KSTTEST)

  4. User KSTTEST does not hold an active connection, no way he blocks anything.

Answer: A

Question No: 39

You must be able to process recoveries for DB2 objects to any point in time between now and two weeks ago.

What is the recommended amount of recovery data needed?

  1. One set of SHRLEVEL(CHANGE) full image copies every two weeks that are kept for at least two weeks.

  2. One set of SHRLEVEL(CHANGE) full image copy at least every week that are kept for at least three weeks as well as the active/archive logs during that time.

  3. One set of SHRLEVEL(CHANGE) full images copies at least every week that are kept for at least two weeks as well as the active/archive logs during that time.

  4. One set of SHRLEVEL(CHANGE) full images copies during week#1 and one set of SHRLEVEL(REFERENCE) incremental images copies during week #2, all are kept for at least two weeks.

Answer: D Reference:http://www.gsebelux.com/system/files/GSE backup and recovery%2 0 at KBC.pdf(page 10)

Question No: 40

What is the minimum buffer pool page size for a compressed index?

  1. 4K

  2. 8K

  3. 16K

  4. 32K

Answer: A

100% Free Download!
Download Free Demo:C2090-312 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-312 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE

Leave a Reply

Your email address will not be published. Required fields are marked *