We're so confident of our products that we provide no hassle product exchange.
IBM C2090-548 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM IMS Database Administrator (C2090-548) |
| Exam Number: | C2090-548 |
| Passing Score: | Not publicly disclosed |
| Available Languages: | English |
| Exam Duration: | Not publicly standardized (typically around 90 minutes) |
| Certificate Validity Period: | Typically 3 years (IBM certifications may vary by program updates) |
| Exam Format: | Scenario-based questions, Multiple choice |
| Real Exam Qty: | Not publicly disclosed (varies by exam version) |
| Exam Price: | Varies by region and delivery provider |
| Related Certifications: | IBM Certified System Programmer - IMS IBM Certified Application Developer - IMS |
| Recommended Training: | IBM IMS Training Courses |
| Exam Registration: | IBM Certification Portal |
| Sample Questions: | IBM C2090-548 Sample Questions |
| Exam Way: | Online proctored or test center (varies by region and IBM testing partner) |
| Pre Condition: | Recommended experience with IBM IMS database systems; prior IMS administration or development experience is strongly suggested but not strictly required |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM C2090-548 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Database Recovery and Availability | - Recovery mechanisms
|
| Topic 2: Performance and Tuning | - Optimization techniques
|
| Topic 3: IMS Environment and Architecture | - IMS data organization concepts
|
| Topic 4: Database Definition and Management | - Database maintenance
|
| Topic 5: Security and Access Control | - Access control mechanisms
|
IBM Certified Database Administrator - IBM IMS Sample Questions:
Question #1
Which of the following options best describes the differences between Label Based Access Control (LBAC) and Row and Column Access Control (RCAC)?
- A. With RCAC users do not get an error when accessing protected data, while with LBAC users can get an error if they don't have the necessary credentials to access a LBAC protected column.
- B. RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.
- C. RCAC is a fixed label security model designed for the US government while LBAC is a general purpose security model best suited for commercial customers.
- D. LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and columns.
Correct Answer: A 🗳️
Question #2
A client wants to Decommission an Oracle 9i application and an IMS application. They need to store the data in a central location. They will be accessing the data from various applications including COGNOS, Business Objects, and a home grown JDBC application. What is necessary to ensure success?
- A. a Sun Solaris Server and Multiple Windows Desktops with Rhumba
- B. Optim TDM, DP, and Archive with ODM/Optim Connect
- C. Optim Data Growth with ODM/Optim Connect
- D. an AIX Server, Windows Desktop, and Optim DRA
Correct Answer: C 🗳️
Question #3
What are DB2 wizards?
- A. DB2 wizards are DBAs that are considered the top of their field in DB2.
- B. DB2 wizards are programs that assist you in completing a single task by stepping you throughthe task.
- C. DB2 does not have wizard functionality.
- D. DB2 wizards programs are automated in DB2. They run as background processes of thedatabase and they automatically configure database parameters.
Correct Answer: B 🗳️
Question #4
What is the purpose of the TRANSFER OWNERSHIP SQL statement in DB2?
- A. This statement provides the capability to change the ownership of a database object.
- B. This statement allows for another DB2 table to wn the data that exists in a column in anothertable.
- C. This statement allows you to transfer DB2 licenses to another company.
- D. This statement does not exist in DB2.
Correct Answer: A 🗳️
Question #5
With respect to DB2 security, what is authorization?
- A. Authorization is the process where the DB2 database checks with Windows security to see if you have access to the DB2 database.
- B. Authorization is the process where the DBA gathers information to see who will have access to the database.
- C. Authorization is a process that validates that you are who you claim to be by verifying your user ID and password.
- D. Authorization is a process that checks whether you have sufficient privileges to perform the desired database operation.
Correct Answer: D 🗳️
By Giles
