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

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

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

Answer: C

Question No: 12

DB2 AUDIT policies are defined by inserting rows into what DB2 Catalog table?

  1. SYSIBM.SYSDBAUTH

  2. SYSIBM.SYSAUTOALERTS

  3. SYSIBM.SYSAUDITPOLICIES

  4. SYSIBM.SYSTABLESPROFILES

Answer: C

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.seca/src/tpc/d b2z_secadmauthority.dita(9th bullet)

Question No: 13

Which command populates the EXPLAIN tables but does not create a package?

  1. REBINDCOPY

  2. REBINDEXPLAIN(NO)

  3. REBINDEXPLAIN(YES)

  4. REBIND EXPLAIN(ONLY)

Answer: D

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

/db2z_bindoptexplain.dita

Question No: 14

Consider a logical data model that includes an Employees entity and a Projects entity. In this model, employees work on many projects and projects are worked on by many employees.

The Employees and Projects entity is considered what kind of relationship?

  1. A one-to-one relationship.

  2. A one-to-many relationship.

  3. A many-to-one relationship.

  4. A many-to-many relationship.

Answer: D

Question No: 15

What can you accomplish with the stored procedure ADMIN_UTL_MONITOR?

  1. This stored procedure helps you monitor currently running threads.

  2. You can create a detailed report of currently running and stopped utilities.

  3. This stored procedure materializes SYSIBM.SYSSTATFEEDBACK for the page sets you specify as input parameter.

  4. You can create RUNSTATS profiles and RUNSTATS recommendations for DB2 tables in your DB2 subsystem.

Answer: D

Reference:http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.perf/src/tpc/db 2z_sp_adminutlmonitor.dita?cp=SSEPEK_11.0.0/6-0-6-1-4-5

Question No: 16

From where does the cross-loader function allow you to load data?

  1. From an input file including all columns.

  2. From a cursor including LOB columns but not including XML columns.

  3. From a cursor including XML columns but not including LOB columns.

  4. From a cursor including all LOB and XML columns except the ROWID column.

Answer: A

Question No: 17

As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action?

  1. Issue the ACCESS command with appropriate keywords.

  2. Issue the ARCHIVE command with the appropriate keywords.

  3. Issue the STOP command for the appropriate set of statistics.

  4. Issue the ALTER command with the appropriate memory location.

Answer: A

Question No: 18

When performing several inserts into a table defined with an identity column, which attribute could be ALTERed to help with the performance?

  1. RESET

  2. CACHE

  3. MAXVALUE

  4. INCREMENT

Answer: D

Question No: 19

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.

Answer: B

Question No: 20

Which type ofstored procedures do NOT require a WLM-managed stored procedure address space?

  1. External stored procedures.

  2. Native SQL stored procedure.

  3. External SQL stored procedures.

  4. DB2 supplied stored procedures.

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 *