We're so confident of our products that we provide no hassle product exchange.
IBM P2090-018 Exam Overview:
| Exam Name: | IBM Information Management DB2 10 Technical Mastery Test v3 |
| Exam Number: | P2090-018 |
| Related Certifications: | IBM Certified Database Administrator - DB2 IBM DB2 10.1 certification track |
| Available Languages: | English |
| Exam Format: | Multiple choice, Scenario-based questions |
| Recommended Training: | IBM DB2 10 for LUW Administration Training |
| Exam Registration: | IBM Certification Portal Pearson VUE IBM Exams |
| Sample Questions: | IBM P2090-018 Sample Questions |
| Exam Way: | Delivered via Pearson VUE testing centers or online proctored exam |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM P2090-018 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| DB2 Architecture and Concepts | - DB2 instance architecture
|
| SQL and Data Manipulation | - SQL fundamentals
|
| Database Administration | - User and security management
|
| Backup and Recovery | - Data protection
|
| Performance and Optimization | - Query optimization
|
IBM Information Management DB2 10 Technical Mastery Test v3 Sample Questions:
1. Which of the following options best defines the Label-Based Access Control (LBAC) feature?
A) DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full qualified name.
B) DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by comparing the security labels between database objects and users.
C) DB2 LBAC monitors table data access and tables modifications made by database users.
D) DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.
2. What are some of the benefits of DB2 Express?
A) DB2 Express is fastest and most powerful DB2 edition.
B) DB2 Express is a tool that allows DBAs to quickly solve complex database issues.
C) DB2 Express is designed for development and testing. It is not used as a production database.
D) DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.
3. Which one of the following options is CORRECT?
A) DB2 pureScale transfers log files from a primary database to a standby database.
B) In both DB2 pureScale and HADR environments data is available all the time.
C) In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.
D) HADR persists data in the cluster caching facilities (CFs).
4. What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?
A) This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.
B) This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.
C) STMM allows DBAs to inspect the current memory allocation by buffer pools.
D) The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: D | Question # 3 Answer: C | Question # 4 Answer: B |
By Wallis
