IBM DB2 9 DBA for Linux,UNIX and Windows 000-731 Certified Exam Dumps

000-731 Exam Dumps

IBM DB2 9 DBA for Linux,UNIX and Windows 000-731 real exam questions and online practice test engine by FreeCram. Try 000-731 exam questions for free. You can also download a free demo of the 000-731 exam PDF version.

IBM's 000-731 actual exam materials brought to you by FreeCram group of IBM certification experts.
View all 000-731 actual exam questions & answers and explanations for free.

If you like our product, you can request full access to all the latest IBM DB2 9 DBA for Linux,UNIX and Windows 000-731 exam premium questions.

Certification Provider: IBM
Exam Code / Number: 000-731
Exam Name: DB2 9 DBA for Linux,UNIX and Windows
Exam Questions: 138
Last Updated: Jun 23, 2026
Corresponding Certification: DB2

Get 000-731 Premium File

(288 Up Votes)

IBM 000-731 Exam Syllabus Topics:

SectionObjectives
Utilities- Administrative utilities
  • 1. EXPORT
  • 2. REORGCHK and other maintenance utilities
  • 3. REORG
  • 4. LOAD and IMPORT
  • 5. RUNSTATS
Performance- Performance monitoring and tuning
  • 1. Monitoring tools and snapshots
  • 2. Optimizer concepts
  • 3. RUNSTATS and statistics management
  • 4. Index and SQL performance tuning
Data Placement- Storage objects and physical design
  • 1. Create and manage buffer pools
  • 2. Design data placement strategies
  • 3. Manage containers and storage allocation
  • 4. Create and manage databases and table spaces
Database Objects- Database object administration
  • 1. Manage constraints and schemas
  • 2. Create and manage tables, indexes and views
  • 3. Use system catalog information
  • 4. Manage sequences, aliases and other objects
Server Management- Server and instance administration
  • 1. Manage authentication, authorization and security
  • 2. Use administrative tools and troubleshoot errors
  • 3. Configure client/server connectivity
  • 4. Create, start, stop, list, update and migrate instances
High Availability- Backup, recovery and disaster recovery
  • 1. High Availability Disaster Recovery (HADR)
  • 2. Rollforward recovery
  • 3. Backup and restore operations
  • 4. Client automatic reroute
  • 5. Split mirroring
Data Concurrency- Transaction and locking management
  • 1. Isolation levels
  • 2. Deadlock and concurrency management
  • 3. Transactions and commit/rollback processing
  • 4. Lock types and lock acquisition


0
0
0
10