New PDF release: OCP: Oracle8i DBA Architecture & Administration and Backup &

By Doug Stuns

ISBN-10: 0782126839

ISBN-13: 9780782126839

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.

Show description

Read or Download OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide PDF

Similar oracle books

Download PDF by Sam Alapati: OCP Oracle Database 11g: New Features for Administrators

Книга 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) Оценка:-

Fred Long's The CERT® Oracle® Secure Coding Standard for Java (SEI PDF

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.

Download PDF by Robert Freeman: Oracle RMAN 11g : backup and recovery

"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.

Download e-book for iPad: Expert Oracle Indexing and Access Paths: Maximum Performance by Darl Kuhn

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.

Additional info for OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide

Example text

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?

Download PDF sample

OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide by Doug Stuns

by Jeff

Rated 4.58 of 5 – based on 4 votes