By Robert G. Freeman
Oracle is the major developer of database software program, and the oracle certifications have lengthy been the traditional for pro database directors. Focusing a hundred% at the examination pursuits, this publication is designed in the event you suppose they're able to test this demanding examination. It additionally encompasses a workbook workout appendix, to organize the readers the palms on they want as a part of their certification. The booklet additionally comes with an interactive cd, together with the sybex attempt engine that includes bankruptcy evaluate questions and bonus checks, a chain of flashcards that may be used in your computer or hand held, and an book. · utilizing oracle asm. · acting oracle user-managed backups. · appearing oracle user-managed database recoveries. · configuring and backing up utilizing rman. · utilizing the rman restoration catalog. · improving databases with rman. · reporting, tracking, and tuning with rman. · appearing oracle complicated restoration. · realizing flashback know-how. · diagnosing the database and coping with functionality. · handling database assets. · utilizing the scheduler to automate projects. · imposing globalization help.
Read or Download OCP : Oracle Database 11g Administrator certified professional study guide (Exam 1Z0-053) PDF
Similar oracle books
# quick, effortless automation for each Oracle 9i and 10g DBA! # easy accessibility to real-world examples# set up, database production, administration, tracking, tuning, and backup/recovery# Oracle common Installer (OUI), Oracle web Configuration Assistant (NetCA), and Oracle Database Configuration Assistant (DBCA)
Organize to cross the Oracle9i qualified specialist DBA New gains for directors examination utilizing this Oracle Press research advisor. you will get entire assurance of all examination themes via perform questions and bankruptcy summaries. The CD-ROM comprises 1000s of perform examination questions in an adaptive structure.
-Your key to reaching certification in Oracle's made over DBA music! -Contains examination necessities, real-world state of affairs sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD comprises flashcards, chapter-by-chapter assessments, randomly gen
This booklet is a finished and easy-to-understand advisor for utilizing the Oracle information supplier (ODP) model 11g at the . web Framework. It additionally outlines the middle GoF (Gang of 4) layout styles and coding options hired to construct and install high-impact mission-critical functions utilizing complex Oracle database positive aspects in the course of the ODP.
- PeopleSoft for the Oracle DBA
- Oracle Database 12c DBA Handbook (1st Edition)
- Oracle SQL: the Essential Reference
- Oracle Application Server 10g Administration Handbook (Osborne ORACLE Press Series)
- Oracle PL/SQL Programming (6th Edition)
- Expert Oracle Database Architecture: Third Edition
Additional resources for OCP : Oracle Database 11g Administrator certified professional study guide (Exam 1Z0-053)
B. Delete and re-create the log file. C. Use the alter database clear logfile command to clear the log file. D. Shut down the database and restart it. E. Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs. 10. You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database? 1. Take the datafiles that were lost offline.
Database files B. Spfiles C. Redo-log files D. Archived log files E. RMAN backup sets F. Password files G. ora files 2. After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance: Select group_number, count(*) from v$asm_operation; What is the implication if the query against V$ASM_OPERATION returns zero rows? A. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation. B. The drop disk operation is complete and you can run the undrop disks command if needed.
Active database duplication. C. Tablespace point-in-time recovery. D. No operation requires the creation of an auxiliary instance. 32. What RMAN command is used to execute a tablespace point-in-time recovery? A. recover B. duplicate C. restore D. copy E. None of the above 33. A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?