Oracle 1Z0-236 Exam Details & Actual Exam Questions

Oracle 11i Applications DBA Fundamentals II Exam Questions

(60 Up Votes)

Certification Vendor:	Oracle
Exam Name:	Oracle 11i Applications DBA Fundamentals II
Exam Number:	1Z0-236
Passing Score:	72%
Available Languages:	English
Related Certifications:	Oracle 11i Applications Database Administrator Certified Professional (OCP)
Certificate Validity Period:	Oracle certification validity policy at time of certification
Exam Price:	USD 195
Real Exam Qty:	Approximately 66
Exam Format:	Linear Exam, Multiple Choice
Exam Duration:	120 minutes
Sample Questions:	Oracle 1Z0-236 Sample Questions
Exam Way:	Pearson VUE authorized testing center or Oracle-authorized exam delivery (subject to Oracle policies at the time).
Pre Condition:	Recommended to pass Oracle 11i Applications DBA Fundamentals I (1Z0-235) and complete an approved Oracle instructor-led course for the corresponding OCP credential.
Official Syllabus URL:	https://www.oracle.com/education/certification/

Section	Objectives
Diagnostic and Tuning Tools	- Using diagnostic tools 1. Performance monitoring 2. Troubleshooting database issues
Backup and Recovery	- User-managed recovery 1. Incomplete recovery 2. Complete recovery
Application and SQL Performance	- Application optimization 1. SQL statement tuning 2. Application tuning 3. Optimizing sort operations
Data Movement and Loading	- Data transfer operations 1. Loading data between databases 2. Transporting data between databases
Concurrency Management	- Managing locking and contention 1. Resolving locking issues 2. Using Oracle blocks effectively
Memory and SGA Tuning	- Managing memory structures 1. Tuning the buffer cache 2. Tuning the shared pool 3. Sizing SGA structures
Database and I/O Configuration	- Configuring database and I/O issues 1. I/O optimization 2. Storage configuration