IBM A2090-731 Exam Details & Actual Exam Questions

IBM DB2 9 DBA for Linux,UNIX and Windows Exam Questions

(39 Up Votes)

Certification Vendor:	IBM
Exam Name:	DB2 9 DBA for Linux, UNIX and Windows
Exam Number:	A2090-731
Exam Duration:	90 minutes
Available Languages:	English
Exam Format:	Multiple Choice
Related Certifications:	IBM Certified Database Administrator – DB2 9 for Linux, UNIX and Windows IBM Exam 730: DB2 9 Family Fundamentals IBM Exam 736: DB2 9 for Linux, UNIX and Windows Upgrade
Exam Price:	USD 150
Real Exam Qty:	50–70
Sample Questions:	IBM A2090-731 Sample Questions
Exam Way:	Administered via IBM/authorized testing partners; proctored onsite or online.
Pre Condition:	Typically requires passing IBM Exam 730 (DB2 9 Family Fundamentals) or equivalent experience.
Official Syllabus URL:	https://www.ibm.com/training/certification/

Section	Objectives
Topic 1: Server Management	- Manage DB2 instances 1. Create, start, stop, migrate, and update DB2 instances 2. Configure client and server connectivity
Topic 2: Storage and Physical Design	- Database storage concepts 1. Tablespaces and buffer pools 2. Design considerations for storage
Topic 3: Monitoring and Utilities	- Performance and maintenance utilities 1. DB2 utilities: REORG, RUNSTATS, REBIND, EXPORT/IMPORT/LOAD 2. Use DB2 monitoring tools and snapshot facilities
Topic 4: Data Access and SQL	- SQL and data access 1. SQL fundamentals for DB2 queries 2. Views, indexes, and constraints
Topic 5: Backup, Recovery, and High Availability	- Protect and restore data 1. Backup and restore strategies 2. Transaction logging and roll-forward recovery
Topic 6: Database Objects and Administration	- Manage database objects 1. Privileges and XML data management 2. Create and modify tables, views, and constraints