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

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: 21

Which statement is true for data in columns defined with data type XML?

  1. Data stored in XML columns cannot be indexed.

  2. It is possible to define the XML column with an INLINEJ.ENGTH.

  3. You can partially UPDATE, DELETE from, and INSERT into an XML document.

  4. If you want to change an existing XML document, you have to replace the whole document in the XML column.

Answer: C

Question No: 22

Arrays are based on a built-in data type. On which built-in data type can an array NOT be based?

  1. XML

  2. CLOB

  3. DBCLOB

  4. VARBINARY

Answer: A

Question No: 23

You want to determine which objects of your database DB1 are in LPL. What command should be used?

  1. -DIS DB(DB1) SP(#39;) ADVISORY(LPL) LIMIT(#39;)

  2. -DIS DB(DB1) SP(#39;) RESTRICT(LPL) LIMIT(#39;)

  3. -DIS DB(DB1) SP(#39;) ADVISORY(LPL) LIMIT(quot;) SCOPE(GROUP)

  4. -DIS DB(DB1) SP(#39;) RESTRICT(LPL) LIMIT(#39;) SCOPE(GROUP)

Answer: B

Question No: 24

A statement-level access path hintcan be applied to which type of SQL statement?

  1. Static SQL statements only.

  2. Dynamic SQL statements only.

  3. Both static and dynamic SQL statements.

  4. Statements included in a CREATE PROCEDURE statement only.

Answer: B

Question No: 25

What is required before you begin your installation of DB2 11?

  1. Data sets for catalog and directory tables must be user-managed.

  2. Data sets for only the catalog tables must be SMS-managed and include a data class for allocating the data sets in extended format.

  3. Data sets for only the directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.

  4. Data sets for catalog and directory tables must be SMS-managed and include a data class for allocating the data sets in extended format.

Answer: A

Question No: 26

What does the UNLOAD utility allow you to unload?

  1. Index entries from an index image copy.

  2. Rows from an image copy after the table has been dropped.

  3. Rows from an image copy after columns have been dropped.

  4. Rows from a sequential image copy created by the COPYTOCOPY utility.

Answer: D

Question No: 27

You are trying to reduce the transaction CPU cost by using KEEPDYNAMIC(YES). Which subsystem parameter would you increase to improve Local Dynamic Cache Hit Ratio and reduce the number of short prepares?

  1. MAXRBLK

  2. MAXKEEPD

  3. MAXTEMPS

  4. CONTSTOR

Answer: B

Question No: 28

Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?

  1. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Local Dynamic Statement Cache.

  2. The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic Statement Cache.

  3. The PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic Statement Cache.

  4. The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Global Dynamic Statement Cache.

Answer: D

Question No: 29

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 (#39;) 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)

Answer: B

Question No: 30

Prefetch l/Os are executed under a service request block in which address space?

  1. IRLM

  2. DBM1

  3. MSTR

  4. User address space

Answer: B

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 *