C2090-311 PDF Dumps

How to use our free ibm C2090-311 PDF Dumps

Our Free C2090-311 PDF dumps are based on the full C2090-311 mock exams which are available on our Web Site. The ibm C2090-311 PDF consists in questions and answers with detailed explanations.
You can use the PDF C2090-311 practice exam as a study material to pass the C2090-311 exam, and don't forget to try also our C2090-311 testing engine Web Simulator.

On-Line Users: {{voteInfo.result.viewUsers}}
Subscribed Users: {{voteInfo.result.subscribedUsers}}
Thank you for your vote {{voteInfo.result.stars}} Your vote has already been submitted ({{voteInfo.result.votingPeople}} votes)

Follow us on SlideShare to see the latest available C2090-311 tests pdf.

										
											Q1.An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created
for a table named EMPLOYEE.
If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:
RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE
ONLY
Which command will create a statistics profile on the EMPLOYEE table?
 - A:   RUNSTATS ON TABLE employee USE PROFILE
 - B:   RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1
 - C:   RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL
 - D:   RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1 GENERATE

PROFILE

 solution: C



Q2.When does space reclamation for a column-organized table normally occur?
 - A:   Whenever an individual row is deleted.
 - B:   Whenever an individual row is updated.
 - C:   After all rows in an extent have been updated.
 - D:   After all rows in an extent where updates took place have been deleted.

 solution: A

Explanation:
answer is verified.


Q3.What are the correct steps to capture EXPLAIN information for column-organized tables?
 - A:   1. Issue the query against column-organized tables

2. Execute the db2exfmt command
 - B:   1. Execute the command CURRENT EXPLAIN MODE YES

2. Issue the query against column-organized tables
3. Execute the db2exfmt command
 - C:   1. Set the ENABLE_COLUMN_TABLES registry variable to YES

2. Issue the query against column-organized tables
3. Execute the db2exfmt command
 - D:   1. Set the ENABLE_COLUMN_TABLES registry variable to YES

2. Execute the command CURRENT EXPLAIN MODE YES
3. Issue the query against column-organized tables
4. Execute the db2exfmt command

 solution: D



Q4.If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two
capabilities are available?
 - A:   Multi-tenancy
 - B:   Workload consolidation
 - C:   Independent tuning member
 - D:   Broadcasting STMM tuning decisions to all members
 - E:   Single INSTANCE_MEMORY instance configuration memory setting

 solution: D, E



Q5.Which monitoring function can be used to determine how many times an SQL statement has referenced a
particular column-organized table within a specific period of time?
 - A:   MON_GET_TABLE()
 - B:   MON_GET_TABLESPACE()
 - C:   MON_GET_UNIT_OF_WORK()
 - D:   MON_GET_TABLE_USAGE_LIST()

 solution: A



Q6.What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be
used to populate a column-organized table and a statistics profile does not exist?
 - A:   A warning is returned and no statistics are collected.
 - B:   An error is returned and the table is placed in "load pending" state.
 - C:   A statistics profile is automatically generated before the load is allowed to continue.
 - D:   The Load utility uses the same RUNSTATS command options as those used during an automatic runstats

operation.

 solution: C



Q7.When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width
size for database tables?
 - A:   32 KB
 - B:   64 KB
 - C:   1MB
 - D:   2 MB

 solution: B



Q8.When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale
environment?
 - A:   When crash recovery is occurring on the standby cluster.
 - B:   When all the log streams are in peer or assisted remote catchup state.
 - C:   When the primary database is not connected to the standby database.
 - D:   All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.

 solution: D



Q9.What type of table can be converted into a column-organized table with the db2convert command?
 - A:   A range partitioned table
 - B:   A materialized query table
 - C:   A row-organized user table
 - D:   A declared global temporary table

 solution: A



Q10.Which statement regarding NOT ENFORCED unique constraints is true?
 - A:   NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.
 - B:   The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data

access plan.
 - C:   Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a

unique index.
 - D:   When attempting to insert data that does not conform to the NOT ENFORCED unique constraint, an error

will be returned and the record will not be inserted.

 solution: A