20:00

PDF|

Guide for C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

Quiz C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

Free Test
/ 10

Quiz

1/10
When does space reclamation for a column-organized table normally occur?
Select the answer
1 correct answer
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.

Quiz

2/10
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?
Select the answer
1 correct answer
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

Quiz

3/10
What are the correct steps to capture EXPLAIN information for column-organized tables?
Select the answer
1 correct answer
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

Quiz

4/10
If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two
capabilities are available?
Select the answer
2 correct answers
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

Quiz

5/10
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?
Select the answer
1 correct answer
A.
MON_GET_TABLE()
B.
MON_GET_TABLESPACE()
C.
MON_GET_UNIT_OF_WORK()
D.
MON_GET_TABLE_USAGE_LIST()

Quiz

6/10
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?
Select the answer
1 correct answer
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.

Quiz

7/10
When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width
size for database tables?
Select the answer
1 correct answer
A.
32 KB
B.
64 KB
C.
1MB
D.
2 MB

Quiz

8/10
When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale
environment?
Select the answer
1 correct answer
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.

Quiz

9/10
What type of table can be converted into a column-organized table with the db2convert command?
Select the answer
1 correct answer
A.
A range partitioned table
B.
A materialized query table
C.
A row-organized user table
D.
A declared global temporary table

Quiz

10/10
Which statement regarding NOT ENFORCED unique constraints is true?
Select the answer
1 correct answer
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.
Looking for more questions?Buy now

C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Practice test unlocks all online simulator questions

Thank you for choosing the free version of the C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 practice test! Further deepen your knowledge on IBM Simulator; by unlocking the full version of our C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Simulator you will be able to take tests with over 30 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 30 questions.

BUY NOW

What to expect from our C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 practice tests and how to prepare for any exam?

The C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Simulator Practice Tests are part of the IBM Database and are the best way to prepare for any C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 exam. The C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 practice tests consist of 30 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Simulator will also give you an idea of the time it will take to complete each section of the C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 practice test . It is important to note that the C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Simulator does not replace the classic C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 exam.

BUY NOW

C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Practice test therefore represents an excellent tool to prepare for the actual exam together with our IBM practice test . Our C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Simulator and how our unique C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Database made up of real questions:

Info quiz:

  • Quiz name:C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1
  • Total number of questions:30
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Simulator.

Use our Mobile App, available for both Android and iOS devices, with our C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 practice tests which consist of 30 questions and also provide study material to pass the final C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 exam with guaranteed success. Our C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 database contain hundreds of questions and IBM Tests related to C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW