We're so confident of our products that we provide no hassle product exchange.
IBM C2090-546 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM DB2 9.7 Database Administrator for Linux, UNIX and Windows Upgrade |
| Exam Number: | C2090-546 |
| Certificate Validity Period: | Typically 2 years (may vary by IBM certification policy) |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | Approximately 55-65 questions |
| Passing Score: | Approximately 60-65% |
| Exam Format: | Scenario-based questions, Multiple choice |
| Available Languages: | English |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX and Windows |
| Exam Price: | Approximately 200 USD |
| Recommended Training: | IBM Training for DB2 9.7 Administration |
| Exam Registration: | IBM Certification Portal |
| Sample Questions: | IBM C2090-546 Sample Questions |
| Exam Way: | Online proctored or test center delivery (varies by region and provider) |
| Pre Condition: | Recommended to hold IBM DB2 9.7 DBA certification or equivalent experience before attempting the upgrade exam |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM C2090-546 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Performance Monitoring and Troubleshooting | - Query performance analysis and tuning - Problem determination and diagnostics - Monitoring tools and snapshot monitoring |
| Topic 2: Backup, Recovery, and High Availability | - High availability concepts - Backup and restore strategies - Crash and rollforward recovery |
| Topic 3: Security and User Management | - Roles, privileges, and authorities - Authentication and authorization |
| Topic 4: Database Administration and Maintenance | - Storage management and table spaces - Database objects management (tables, indexes, schemas) - Routine maintenance tasks |
| Topic 5: DB2 9.7 Architecture and Installation | - Configuration parameters overview - DB2 instance and database architecture - Installation and upgrade procedures |
IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:
Question #1
Which command will enable Oracle applications to work within a DB2 9.7 environment?
- A. db2set DB2_COMPATIBILITY=ORA
- B. db2set DB2_COMPATIBILITY=ORACLE
- C. db2set DB2_COMPATIBILITY_VECTOR=ORACLE
- D. db2set DB2_COMPATIBILITY_VECTOR=ORA
Answer: D
Question #2
Which command/statement is used to implement Currently Committed (CC) semantics behavior on an application-by-application basis?
- A. UPDATE DB CFG FOR <db_name> USING CUR_COMMIT AVAILABLE
- B. UPDATE DBM CFG USING EVALUNCOMMITTED NO
- C. SET CURRENT ISOLATION CC
- D. db2set DB2_USE_CURRENTLY_COMMITTED=YES
Answer: A
Question #3
Which two are valid BASED UPON CONNECTION attributes for a trusted context? (Choose two.)
- A. Data stream encryption
- B. Date and time
- C. Database role
- D. Application program name
- E. System authorization id
Answer: A,E
Question #4
What DB2 feature must NOT be activated in order to enable Secure Sockets Layer (SSL) support?
- A. Kerberos Authentication
- B. Connection Concentrator
- C. High Availability Disaster Recovery (HADR)
- D. Work Load Manager (WLM)
Answer: B
Question #5
If the following statements are executed:
Which operation will be captured by the ASP_1 audit policy?
- A. DROP TABLE old_tab
- B. CREATE TABLE tab_1 (col1 INT, col2 DATE)
- C. SELECT * FROM staff
- D. CREATE INDEX idx_1 ON tab_1 (col1)
Answer: C
By Viola
