Oracle Database 10g OCP Certification All-In-One Exam Guide
Search in google:
The Most Authoritative OCA/OCP Exam Guide AvailablePrepare to pass the OCA and OCP Oracle Database 10g certification exams with help from this Oracle Press guide. With complete coverage of all the material on Exam #1Z0-042 Oracle Database 10g: Administration I and Exam #1Z0-043 Oracle Database 10g: Administration II, this book covers everything you need to know to pass both exams. Inside, you’ll find helpful exam tips, hundreds of practice questions, and real-world exercises. This comprehensive guide serves as both a study tool and an on-the-job reference. Get full details on all exam objectives, including how to: Install Oracle Database 10g and create a database Use SQL, SQL*Plus, iSQL*Plus, and PL/SQL Create and manage database user accounts Configure Oracle Networking Manage shared servers Monitor, tune, and troubleshoot a database Handle database backup, restore, and recovery Use Oracle Recovery Manager and Oracle Flashback Configure and manage security Use Automatic Storage Management and Resource Manager Automate administrative tasksIncluded on the CD-ROM Electronic Practice Test engine with two full practice exams Complete electronic book
Pt. IOracle Database 10g administrative I exam1Ch. 1Basic Oracle concepts3Ch. 2Installing Oracle Database 10g19Ch. 3Creating an Oracle database49Ch. 4Interfacing with the Oracle Database73Ch. 5Managing Oracle processes105Ch. 6Managing Oracle storage structures127Ch. 7Administering database users157Ch. 8Managing database objects209Ch. 9Manipulating database data233Ch. 10Programming Oracle with PL/SQL261Ch. 11Securing the Oracle Database277Ch. 12Configuring Oracle networking305Ch. 13Managing shared servers333Ch. 14Managing database performance351Ch. 15Monitoring Oracle375Ch. 16Managing undo395Ch. 17Dealing with locking413Ch. 18Configuring the database for backup and recovery427Ch. 19Backing up an Oracle database457Ch. 20Recovering Oracle databases479Ch. 21Managing globalization in Oracle databases497Pt. IIOracle Database 10g administrative II exam523Ch. 22Configuring security for the listener525Ch. 23Getting started with Oracle Recovery Manager (RMAN)543Ch. 24Using RMAN to back up databases565Ch. 25Diagnosing Oracle database issues589Ch. 26Recovering from noncritical losses609Ch. 27Incomplete database recovery631Ch. 28Using Oracle Flashback Database657Ch. 29Recovering from user errors681Ch. 30Detecting and recovering from database corruption711Ch. 31Tools for Oracle Database 10g tuning731Ch. 32Monitoring and managing storage749Ch. 33Managing storage with automatic storage management781Ch. 34Monitoring and managing memory805Ch. 35Managing Oracle database resources833Ch. 36Automating administrative tasks865
