PDF Version DemoIBM P2090-018 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | IBM Information Management DB2 10 Technical Mastery Test v3 |
| Exam Number: | 000-N18 |
| Available Languages: | English |
| Related Certifications: | IBM Information Management DB2 10 |
| Exam Format: | Multiple Choice |
| Sample Questions: | IBM P2090-018 Sample Questions |
| Exam Way: | Online technical mastery assessment through IBM certification/testing platform (historically web-based). |
| Pre Condition: | No formal prerequisite published. Intended for professionals demonstrating technical mastery of IBM Information Management DB2 10. |
| Official Syllabus URL: | https://www.ibm.com/products/db2/tutorials |
IBM P2090-018 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Backup, Recovery, and Utilities | - Database maintenance
|
| Topic 2: Database Administration | - Database creation and configuration
|
| Topic 3: Performance and Monitoring | - Performance management
|
| Topic 4: Security and Authorization | - Access control
|
| Topic 5: DB2 10 Fundamentals | - DB2 10 architecture and concepts
|
| Topic 6: SQL and Data Management | - SQL operations
|
IBM Information Management DB2 10 Technical Mastery Test v3 Sample Questions:
1. What is a buffer pool in DB2?
A) A buffer pool is a logical storage grouping composed of one or more containers.
B) A buffer pool is a DB2 component that manages connections to databases.
C) A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.
D) A buffer pool is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.
2. What is a table space in DB2?
A) A table space is a logical storage grouping that can be composed of one or more containers.
B) A table space is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.
C) A table space is a space reserved for catalog tables and base table data.
D) A table space is a DB2 component that manages access to databases.
3. Which one of the following options is FALSE about DB2's Multi-Temperature Data Storage capability?
A) Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead.
B) Multi-temperature data management integrates with DB2's Workload Manager feature to let you prioritize your workloads based on the data being accessed.
C) Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.
D) You can use storage groups to implement multi-temperature data management in DB2.
4. Which one of the following statements is FALSE about DB2 Workload Management (WLM)?
A) DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class.
B) DB2 Workload Management dispatcher can be used to control sharing of memory resources among active workloads.
C) DB2 Workload Management uses workloads to identify incoming work based on the connection attributes under which the work is submitted.
D) When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: A | Question # 3 Answer: C | Question # 4 Answer: B |
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
778 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.