By Doug Stuns
This examine advisor is geared toward Oracle database directors who wish OCP certification. It covers the second one and 3rd tests within the DBA music, structure & management and Backup & restoration.
Read or Download OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide PDF
Similar oracle books
Книга OCP Oracle Database 11g: New positive aspects for directors examination consultant OCP Oracle Database 11g: New gains for directors examination advisor Книги Oracle Автор: Sam Alapati Год издания: 2008 Формат: pdf Издат. :The McGraw-Hill businesses, Inc. Страниц: 554 Размер: three ISBN: 0-07-164372-9 Язык: Русский0 (голосов: zero) Оценка:-
A vital component to safe coding within the Java programming language is a well-documented and enforceable coding regular. Coding criteria motivate programmers to persist with a uniform algorithm made up our minds by means of the necessities of the venture and association, instead of via the programmer’s familiarity or choice.
"Protect your databases from undefined, software program, and operator mess ups utilizing the targeted info during this Oracle Press advisor. Oracle RMAN 11g Backup and restoration explains find out how to configure databases, generate actual information, and perform approach restores. paintings from the command line or Oracle firm supervisor, automate the backup procedure, practice Oracle Flashback recoveries, and combine cloud computing know-how.
Accelerate the execution of significant database queries via making stable offerings approximately which indexes to create. select right index kinds for various situations. keep away from indexing pitfalls that could even have indexes hurting functionality instead of assisting. retain indexes so one can offer constant and predictable question reaction over the life of an program.
- Oracle and PL/SQL Recipes: A Problem-Solution Approach
- Oracle SQL jumpstart with examples
- Beginning Oracle Application Express 4
- TOAD Handbook
Additional info for OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide
TIME_PERIOD C. TIME_OUT D. TIMEOUT 3. Which utility enables you to identify and skip corrupt data blocks? A. DBVERIFY B. DBMS_REPAIR C. ANALYZE TABLE D. com lii Assessment Test 4. If you are using the LOG_ARCHIVE_DEST_N parameter to protect your archive log files from media, what is the maximum number of destinations? A. 2 B. 5 C. 10 D. 8 E. 3 5. Which parameter causes the Import utility to import the transportable tablespace data dictionary information from the export file? A. TABLE B. TRANSPORTABLE C.
OS backup without archiving C. Export utility without archiving D. RMAN backup set without archiving E. Import utility with archiving 37. What should you do first before launching the RMAN utility to con- nect to Recovery Manager? A. Shut down the recovery catalog database B. Import the target database C. Set ORACLE_SID to the correct target database name D. Shut down the target database 38. You are performing a recovery due to a media failure and you discover that you are missing an archive log file, so you must perform an incomplete recovery.
To back up data files to tape 19. What is the maximum number of archive log processes allowed? A. 2 B. 5 C. 10 D. com lvi Assessment Test 20. You must perform a recovery because of incorrect DELETE statements that were made to the database. Which type of recovery would be best to perform? A. Complete recovery B. Time-based recovery C. Cancel-based recovery D. Change-based recovery 21. Which command combines the results of incremental, cumulative, archives, and redo logs to generate a synchronized database?
OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide by Doug Stuns