File Info
| Exam | DB2 10.1 Fundamentals |
| Number | C2090-610 |
| File Name | IBM.C2090-610.TestInside.2018-11-30.80q.vcex |
| Size | 297 KB |
| Posted | Nov 30, 2018 |
| Download | IBM.C2090-610.TestInside.2018-11-30.80q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which product is used to customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system?
- pureScale
- Workload manager
- Data partitioning feature
- Self-tuning memory manager
Correct answer: B
Question 2
What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?
- locator
- pointer
- address
- reference
Correct answer: A
Explanation:
Question 3
What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object?
- inline
- binary
- internal
- partitioned
Correct answer: A
Question 4
What is the purpose of the Query Tuner?
- To automatically capture and stop rogue queries.
- To provide recommendations and analysis for tuning a single query.
- To provide recommendations and analysis for tuning up to 100 queries.
- To recommend indexes and to guide DBAs through the process of creating new indexes.
Correct answer: B
Question 5
Which tool allows users to connect to a DB2 database using a wizard?
- Control Center
- IBM Data Studio
- Universal Connection Expert
- DB2 Connection Pool Manager
Correct answer: B
Question 6
Which two activities indicate the need for a data warehouse? (Choose two.)
- Confirm product inventory.
- Monitor product availability.
- Summarize sales by region.
- Identify patterns for products sold in the last five years.
- Associate one or more products with a purchase order.
Correct answer: CD
Question 7
What factor influences lock escalation?
- Table size
- Buffer space
- Number of locks
- Available real storage
Correct answer: C
Question 8
Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?
- Share (S)
- Update (U)
- Exclusive (X)
- Intent Exclusive (IX)
Correct answer: A
Question 9
Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation level. If application APP_B wants to retrieve all rows from table TAB1 without waiting for application APP_A to finish making updates, what isolation level must application APP_B use?
- Read Stability (RS)
- Repeatable Read (RR)
- Uncommitted Read (UR)
- Cursor Stability (CS)
Correct answer: C
Question 10
Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?
- LOCK TABLE tab1 IN READ MODE
- LOCK TABLE tab1 IN SHARE MODE
- LOCK TABLE tab1 IN EXCLUSIVE MODE
- LOCK TABLE tab1 IN READ-ONLY MODE
Correct answer: B
