PDF Version DemoIBM C2090-548 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | IBM Certified Database Administrator - IBM IMS |
| Exam Number: | C2090-548 |
| Real Exam Qty: | Approximately 60 |
| Passing Score: | Not officially published |
| Exam Price: | Varies by country (typically around USD 200) |
| Exam Duration: | 90 minutes |
| Exam Format: | Multiple-choice, Multiple-response |
| Available Languages: | English |
| Related Certifications: | IBM Certified Database Administrator - IBM IMS |
| Certificate Validity Period: | Not officially specified |
| Sample Questions: | IBM C2090-548 Sample Questions |
| Exam Way: | Pearson VUE authorized testing center or online proctored exam (where available). |
| Pre Condition: | No mandatory prerequisite exam. IBM recommends practical experience administering IBM IMS databases and familiarity with IMS architecture and utilities. |
| Official Syllabus URL: | https://www.ibm.com/training/certification/ibm-certified-database-administrator-ims-08007401 |
IBM C2090-548 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Database Design and Definition | - Database definition
|
| Topic 2: Database Administration | - Administration tasks
|
| Topic 3: Backup, Recovery and Data Integrity | - Recovery management
|
| Topic 4: IMS Architecture and Database Fundamentals | - IMS architecture
|
| Topic 5: Utilities and Operations | - IMS utilities
|
| Topic 6: Security and Problem Determination | - Security and troubleshooting
|
IBM Certified Database Administrator - IBM IMS Sample Questions:
1. What is the LOAD authority in DB2?
A) LOAD authority does not exist in DB2.
B) LOAD authority is at the database level. When combined with the INSERT privilege on a table,it allows the user to load data into that table.
C) LOAD authority in DB2 is the main DBA in your organization that allows for a database to beloaded.
D) LOAD authority is a permission granted to a database table that allows the table the accessesrights to load a backup database.
2. 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.
3. How is DB2 installed on the server?
A) DB2 can only be installed from a command prompt using command-line entries.
B) DB2 can be installed using the DB2 installation wizard.
C) DB2 must be installed on RAM drive on the server to speed up performance of the database.
D) DB2 can only be purchased pre-installed on an IBM server. There is no need to ever installDB2.
4. Which one of the following statements is true?
A) Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in insertion sequence).
B) Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in insertion sequence) for which there is space. The remainingsegments of the database record are put in the overflow dataset.}
C) Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in hierarchical sequence) for which there is space. The remainingsegments of the database record are put in the overflow dataset.
D) Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in hierarchical sequence).
5. Which one of the following statements is TRUE about DB2 Workload Management (WLM)?
A) DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.
B) DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.
C) DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.
D) DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: B | Question # 3 Answer: B | Question # 4 Answer: C | Question # 5 Answer: D |
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.
972 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.