File Info
| Exam | DB2 10.1 Fundamentals |
| Number | C2090-610 |
| File Name | IBM.C2090-610.PrepAway.2018-08-07.78q.vcex |
| Size | 229 KB |
| Posted | Aug 07, 2018 |
| Download | IBM.C2090-610.PrepAway.2018-08-07.78q.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
What are two valid objects that can be created in DB2? (Choose two.)
- Tree
- Node
- Trigger
- Contexts
- Sequence
Correct answer: CE
Question 2
Which type of temporal table can be used to store only time-sensitive data?
- Bitemporal
- Time-period
- System-period
- Application-period
Correct answer: D
Explanation:
Question 3
When an index is created for a table, where is the metadata for that index stored?
- In the table definition.
- In the system catalog.
- In the schema that the index resides in.
- In the metadata of the table the index was created for.
Correct answer: B
Question 4
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 5
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
Question 6
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 7
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 8
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 9
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 10
What is the primary function of an Online Transaction Processing (OLTP) workload?
- To combine data from multiple sources.
- To discover hidden relationships in data.
- To analyze large amounts of data to find patterns.
- To make changes to a small number of records within a single transaction.
Correct answer: D
