Muutke küpsiste eelistusi

E-raamat: OCA/OCP Oracle Database 11g All-in-One Exam Guide: Exams 1Z0-051, 1Z0-052, 1Z0-053

3.75/5 (32 hinnangut Goodreads-ist)
, ,
  • Formaat: 1050 pages
  • Sari: Oracle Press
  • Ilmumisaeg: 05-Sep-2009
  • Kirjastus: McGraw-Hill Professional
  • Keel: eng
  • ISBN-13: 9780071629218
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 92,66 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
OCA/OCP Oracle Database 11g All-in-One Exam Guide: Exams 1Z0-051, 1Z0-052, 1Z0-053Suurem pilt
  • Formaat: 1050 pages
  • Sari: Oracle Press
  • Ilmumisaeg: 05-Sep-2009
  • Kirjastus: McGraw-Hill Professional
  • Keel: eng
  • ISBN-13: 9780071629218
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.







A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053

Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exams 1Z0-051, 1Z0-052, and 1Z0-053, including:





Instance management Networking and storage Security SQL Oracle Recovery Manager and Oracle Flashback Oracle Automatic Storage Management Resource manager Oracle Scheduler Automatic workload repository Performance tuning And more

On the CD-ROM:





Three full practice exams Detailed answers and explanations Score report performance assessment tool Complete electronic book Three bonus exams available with free online registration
Introduction xxix
Part I Oracle Database IIg Administration
Architectural Overview of Oracle Database IIg
3(52)
Exam Objectives
3(1)
Oracle Product Stack
4(7)
Oracle Server Family
4(4)
Oracle Development Tools
8(2)
Oracle Applications
10(1)
Prerequisite Concepts
11(2)
Oracle Concepts
11(1)
SQL Concepts
12(1)
Operating System Concepts
13(1)
Single-Instance Architecture
13(6)
Single-Instance Database Architecture
13(3)
Distributed Systems Architectures
16(3)
Instance Memory Structures
19(9)
The Database Buffer Cache
20(1)
The Log Buffer
21(2)
The Shared Pool
23(3)
The Large Pool
26(1)
The Java Pool
26(1)
The Streams Pool
27(1)
Instance Process Structures
28(12)
SMON, the System Monitor
29(1)
PMON, the Process Monitor
30(1)
DBWn, the Database Writer
30(2)
LGWR, the Log Writer
32(1)
CKPT, the Checkpoint Process
33(1)
MMON, the Manageability Monitor
34(1)
MMNL, the Manageability Monitor Light
35(1)
MMAN, the Memory Manager
35(1)
ARCn, the Archiver
35(1)
RECO, the Recoverer Process
36(1)
Some Other Background Processes
37(3)
Database Storage Structures
40(9)
The Physical Database Structures
41(4)
The Logical Database Structures
45(1)
The Data Dictionary
46(3)
Two-Minute Drill
49(1)
Single-Instance Architecture
49(1)
Instance Memory Structures
49(1)
Instance Process Structures
49(1)
Database Storage Structures
49(1)
Self Test
50(2)
Self Test Answers
52(3)
Installing and Creating a Database
55(44)
Exam Objectives
55(1)
Identify the Tools for Administering an Oracle Database
56(12)
The Oracle Universal Installer
56(4)
Database Creation and Upgrade Tools
60(1)
Tools for Issuing Ad Hoc SQL: SQL*Plus and SQL Developer
61(5)
Oracle Enterprise Manager
66(1)
Other Administration Tools
67(1)
Plan an Oracle Database Installation
68(6)
Choice of Operating System
68(1)
Hardware and Operating System Resources
69(2)
Optimal Flexible Architecture
71(1)
Environment Variables
72(2)
Install the Oracle Software by Using the Oracle Universal Installer (OUI)
74(3)
Create a Database by Using the Database Configuration Assistant
77(14)
The Instance, the Database, and the Data Dictionary
78(1)
Using the DBCA to Create a Database
79(5)
The Scripts and Other Files Created by the DBCA
84(6)
The DBCA's Other Functions
90(1)
Two-Minute Drill
91(1)
Identify the Tools for Administering an Oracle Database
91(1)
Plan an Oracle Database Installation
92(1)
Install the Oracle Software by Using the Oracle Universal Installer (OUI)
92(1)
Create a Database by Using the Database Configuration Assistant
92(1)
Self Test
92(4)
Self Test Answers
96(3)
Instance Management
99(34)
Exam Objectives
99(2)
Set Database Initialization Parameters
101(7)
Static and Dynamic Parameters and the Initialization Parameter File
101(2)
The Basic Parameters
103(5)
Describe the Stages of Database Startup and Shutdown
108(13)
Starting and Connecting to Database Control
108(2)
Starting the Database Listener
110(2)
Starting SQL*Plus
112(1)
Database Startup and Shutdown
112(9)
Use the Alert Log and Trace Files
121(2)
Use Data Dictionary and Dynamic Performance Views
123(3)
The Data Dictionary Views
123(1)
The Dynamic Performance Views
124(2)
Two-Minute Drill
126(1)
Describe the Stages of Database Startup and Shutdown
126(1)
Set Database Initialization Parameters
126(1)
Use the Alert Log and Trace Files
127(1)
Use Data Dictionary and Dynamic Performance Views
127(1)
Self Test
127(3)
Self Test Answers
130(3)
Oracle Networking
133(38)
Exam Objectives
133(1)
Configure and Manage the Oracle Network
134(23)
Oracle Net and the Client-Server Paradigm
134(2)
A Word on Oracle Net and Communication Protocols
136(1)
Establishing a Session
136(3)
Creating a Listener
139(1)
Database Registration
140(3)
Techniques for Name Resolution
143(2)
The Listener Control Utility
145(4)
Configuring Service Aliases
149(2)
Filenames and the TNSADMIN Environment Variable
151(2)
Database Links
153(4)
Use the Oracle Shared Server Architecture
157(8)
The Limitations of Dedicated Server Architecture
157(2)
The Shared Server Architecture
159(2)
Configuring Shared Server
161(1)
When to Use the Shared Server
162(3)
Two-Minute Drill
165(1)
Configure and Manage the Oracle Network
165(1)
Use the Oracle Shared Server Architecture
165(1)
Self Test
166(3)
Self Test Answers
169(2)
Oracle Storage
171(32)
Exam Objectives
171(1)
Overview of Tablespaces and Datafiles
172(8)
The Oracle Data Storage Model
172(2)
Segments, Extents, Blocks, and Rows
174(4)
File Storage Technologies
178(2)
Create and Manage Tablespaces
180(14)
Tablespace Creation
180(6)
Altering Tablespaces
186(5)
Dropping Tablespaces
191(1)
Oracle-Managed Files (OMF)
191(3)
Space Management in Tablespaces
194(3)
Extent Management
194(2)
Segment Space Management
196(1)
Two-Minute Drill
197(1)
Overview of Tablespaces and Datafiles
197(1)
Create and Manage Tablespaces
198(1)
Space Management in Tablespaces
198(1)
Self Test
198(3)
Self Test Answers
201(2)
Oracle Security
203(56)
Exam Objectives
203(1)
Create and Manage Database User Accounts
204(12)
User Account Attributes
205(4)
Authentication Methods
209(4)
Creating Accounts
213(3)
Grant and Revoke Privileges
216(7)
System Privileges
216(3)
Object Privileges
219(4)
Create and Manage Roles
223(6)
Creating and Granting Roles
223(1)
Predefined Roles
224(1)
Enabling Roles
225(4)
Create and Manage Profiles
229(5)
Password Management
229(1)
Resource Limits
230(1)
Creating and Assigning Profiles
231(3)
Database Security and Principle of Least Privilege
234(6)
Public Privileges
234(1)
Security-Critical Instance Parameters
235(5)
Work with Standard Database Auditing
240(8)
Auditing SYSDBA Activity
241(1)
Database Auditing
241(3)
Value-Based Auditing with Triggers
244(1)
Fine-Grained Auditing (FGA)
245(3)
Two-Minute Drill
248(1)
Create and Manage Database User Accounts
248(1)
Grant and Revoke Privileges
248(1)
Create and Manage Roles
249(1)
Create and Manage Profiles
249(1)
Database Security and Principle of Least Privilege
249(1)
Work with Standard Database Auditing
249(1)
Self Test
249(4)
Self Test Answers
253(6)
Part II SQL
DDL and Schema Objects
259(56)
Exam Objectives
259(1)
Categorize the Main Database Objects
260(3)
Object Types
260(1)
Naming Schema Objects
261(1)
Object Namespaces
262(1)
List the Data Types That Are Available for Columns
263(3)
Create a Simple Table
266(7)
Creating Tables with Column Specifications
267(1)
Creating Tables from Subqueries
268(1)
Altering Table Definitions after Creation
269(1)
Dropping and Truncating Tables
270(3)
Create and Use Temporary Tables
273(2)
Indexes
275(8)
Why Indexes Are Needed?
275(1)
Types of Index
276(5)
Creating and Using Indexes
281(1)
Modifying and Dropping Indexes
282(1)
Constraints
283(7)
The Types of Constraint
283(3)
Defining Constraints
286(2)
Constraint State
288(1)
Constraint Checking
289(1)
Views
290(5)
Why Use Views at All?
291(2)
Simple and Complex Views
293(1)
Create View, Alter View, and Drop View
294(1)
Synonyms
295(3)
Sequences
298(5)
Creating Sequences
298(2)
Using Sequences
300(3)
Two-Minute Drill
303(2)
Categorize the Main Database Objects
303(1)
List the Data Types That Are Available for Columns
303(1)
Create a Simple Table
304(1)
Create and Use Temporary Tables
304(1)
Constraints
304(1)
Indexes
304(1)
Views
304(1)
Synonyms
305(1)
Sequences
305(1)
Self Test
305(6)
Self Test Answers
311(4)
DML and Concurrency
315(52)
Exam Objectives
315(1)
Data Manipulation Language (DML) Statements
316(14)
Insert
316(4)
Update
320(3)
Delete
323(2)
Truncate
325(1)
Merge
326(2)
DML Statement Failures
328(2)
Control Transactions
330(10)
Database Transactions
330(1)
Executing SQL Statements
331(4)
Transaction Control: Commit, Rollback, Savepoint, Select For Update
335(5)
Identify and Administer PL/SQL Objects
340(6)
Stored and Anonymous PL/SQL
340(1)
PL/SQL Objects
341(5)
Monitor and Resolve Locking Conflicts
346(5)
Shared and Exclusive Locks
346(1)
The Enqueue Mechanism
347(1)
Lock Contention
347(3)
Deadlocks
350(1)
Overview of Undo
351(1)
Transactions and Undo Data
352(2)
Managing Undo
354(5)
Error Conditions Related to Undo
354(1)
Parameters for Undo Management, and Retention Guarantee
355(1)
Sizing and Monitoring the Undo Tablespace
356(2)
Creating and Managing Undo Tablespaces
358(1)
Two-Minute Drill
359(2)
Describe Each Data Manipulation Language (DML) Statement
359(1)
Control Transactions
360(1)
Manage Data Using DML
360(1)
Identify and Administer PL/SQL Objects
360(1)
Monitor and Resolve Locking Conflicts
360(1)
Overview of Undo
360(1)
Transactions and Undo Data
361(1)
Managing Undo
361(1)
Self Test
361(4)
Self Test Answers
365(2)
Retrieving, Restricting, and Sorting Data Using SQL
367(52)
Exam Objectives
367(1)
List the Capabilities of SQL SELECT Statements
368(7)
Introducing the SQL SELECT Statement
368(1)
The Describe Table Command
369(1)
Capabilities of the Select Statement
370(1)
Data Normalization
371(4)
Create the Demonstration Schemas
375(6)
The HR and Webstore Schemas
375(4)
Demonstration Schema Creation
379(2)
Execute a Basic SELECT Statement
381(11)
Syntax of the Primitive SELECT Statement
382(1)
Rules Are Meant to Be Followed
383(3)
SQL Expressions and Operators
386(4)
NULL Is Nothing
390(2)
Limit the Rows Retrieved by a Query
392(11)
The WHERE Clause
392(3)
Comparison Operators
395(5)
Boolean Operators
400(2)
Precedence Rules
402(1)
Sort the Rows Retrieved by a Query
403(2)
The Order by Clause
403(2)
Ampersand Substitution
405(7)
Substitution Variables
406(3)
Define and Verify
409(3)
Two-Minute Drill
412(2)
List the Capabilities of SQL SELECT Statements
412(1)
Execute a Basic Select Statement
412(1)
Limit the Rows Retrieved by a Query
413(1)
Sort the Rows Retrieved by a Query
413(1)
Ampersand Substitution
413(1)
Self Test
414(2)
Self Test Answers
416(3)
Single-Row and Conversion Functions
419(40)
Exam Objectives
419(1)
Describe and Use Character, Number, and Date Functions in SQL
420(14)
Defining a Function
420(1)
Types of Functions
420(1)
Using Case Conversion Functions
421(2)
Using Character Manipulations Functions
423(4)
Using Numeric Functions
427(2)
Working with Dates
429(5)
Describe Various Types of Conversion Functions Available in SQL
434(2)
Conversion Functions
434(2)
Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
436(8)
Using the Conversion Functions
436(8)
Apply Conditional Expressions in a SELECT Statement
444(9)
Nested Functions
444(1)
Conditional Functions
445(8)
Two-Minute Drill
453(1)
Describe Various Types of Functions Available in SQL
453(1)
Use Character, Number, and Date Functions in SELECT Statements
453(1)
Describe Various Types of Conversion Functions Available in SQL
454(1)
Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
454(1)
Apply Conditional Expressions in a SELECT Statement
454(1)
Self Test
454(3)
Self Test Answers
457(2)
Group Functions
459(22)
Exam Objectives
459(1)
The Group Functions
460(5)
Definition of Group Functions
460(1)
Using Group Functions
461(4)
Group Data Using the GROUP By Clause
465(6)
Creating Groups of Data
465(1)
The GROUP BY Clause
466(2)
Grouping by Multiple Columns
468(2)
Nested Group Functions
470(1)
Include or Exclude Grouped Rows Using the HAVING Clause
471(4)
Restricting Group Results
472(1)
The HAVING Clause
473(2)
Two-Minute Drill
475(1)
Describe the Group Functions
475(1)
Identify the Available Group Functions
475(1)
Group Data Using the Group by Clause
475(1)
Include or Exclude Grouped Rows Using the Having Clause
476(1)
Self Test
476(2)
Self Test Answers
478(3)
SQL Joins
481(34)
Exam Objectives
481(1)
Write Select Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
482(16)
Types of Joins
482(5)
Joining Tables Using SQL:1999 Syntax
487(1)
Qualifying Ambiguous Column Names
487(2)
The Natural Join Clause
489(3)
The Natural Join Using Clause
492(1)
The Natural Join On Clause
492(3)
N-Way Joins and Additional Join Conditions
495(1)
Nonequijoins
496(2)
Join a Table to Itself Using a Self-Join
498(2)
Joining a Table to Itself Using the Join ... On Clause
498(2)
View Data That Does Not Meet a Join Condition by Using Outer Joins
500(5)
Inner Versus Outer Joins
500(1)
Left Outer Joins
501(2)
Right Outer Joins
503(1)
Full Outer Joins
503(2)
Generate a Cartesian Product of Two or More Tables
505(3)
Creating Cartesian Products Using Cross Joins
506(2)
Two-Minute Drill
508(2)
Write Select Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
508(1)
Join a Table to Itself Using a Self-Join
509(1)
View Data That Does Not Meet a Join Condition Using Outer Joins
509(1)
Generate a Cartesian Product of Two or More Tables
509(1)
Self Test
510(2)
Self Test Answers
512(3)
Subqueries and Set Operators
515(28)
Exam Objectives
515(1)
Define Subqueries
516(1)
Describe the Types of Problems That the Subqueries Can Solve
517(3)
Use of a Subquery Result Set for Comparison Purposes
517(1)
Generate a Table from Which to Select
518(1)
Generate Values for Projection
518(1)
Generate Rows to Be Passed to a DML Statement
519(1)
List the Types of Subqueries
520(4)
Single- and Multiple-Row Subqueries
520(1)
Correlated Subqueries
521(3)
Write Single-Row and Multiple-Row Subqueries
524(1)
Describe the Set Operators
525(4)
Sets and Venn Diagrams
525(1)
Set Operator General Principles
526(3)
Use a Set Operator to Combine Multiple Queries into a Single Query
529(4)
The Union All Operator
529(1)
The Union Operator
530(1)
The Intersect Operator
530(1)
The Minus Operator
531(1)
More Complex Examples
531(2)
Control the Order of Rows Returned
533(1)
Two-Minute Drill
533(2)
Define Subqueries
533(1)
Describe the Types of Problems That the Subqueries Can Solve
533(1)
List the Types of Subqueries
534(1)
Write Single-Row and Multiple-Row Subqueries
534(1)
Describe the Set Operators
534(1)
Use a Set Operator to Combine Multiple Queries into a Single Query
534(1)
Control the Order of Rows Returned
534(1)
Self Test
535(4)
Self Test Answers
539(4)
PART III Advanced Database Administration
Configuring the Database for Backup and Recovery
543(34)
Exam Objectives
543(1)
Backup and Recovery Issues
544(2)
Categories of Failures
546(6)
Statement Failure
546(1)
User Process Failure
547(1)
Network Failure
548(1)
User Errors
549(2)
Media Failure
551(1)
Instance Failure
552(1)
Instance Recovery
552(6)
The Mechanics of Instance Recovery
553(1)
The Impossibility of Database Corruption
554(1)
Tuning Instance Recovery
555(1)
The MTTR Advisor and Checkpoint Auto-Tuning
555(2)
Checkpointing
557(1)
Preparing the Database for Recoverability
558(9)
Protecting the Controlfile
558(2)
Protecting the Online Redo Log Files
560(3)
Archivelog Mode and the Archiver Process
563(3)
Protecting the Archive Redo Log Files
566(1)
The Flash Recovery Area
567(3)
Recovery Files
567(1)
Configure the Flash Recovery Area
568(1)
Flash Recovery Area Space Usage
569(1)
Two-Minute Drill
570(2)
Identify the Types of Failure That Can Occur in an Oracle Database
570(1)
Describe Ways to Tune Instance Recovery
571(1)
Identify the Importance of Checkpoints, Redo Log Files, and Archived Log Files
571(1)
Configure Archivelog Mode
571(1)
Configure Multiple Archive Log File Destinations to Increase Availability
571(1)
Overview of the Flash Recovery Area
572(1)
Configure the Flash Recovery Area
572(1)
Use the Flash Recovery Area
572(1)
Self Test
572(3)
Self Test Answers
575(2)
Back Up with RMAN
577(30)
Exam Objectives
577(1)
Backup Concepts and Terminology
578(2)
Using the Rman Backup Command to Create Backups
580(12)
Server-Managed Consistent Backups
580(2)
Server-Managed Open Backups
582(1)
Incremental Backups
583(5)
Image Copies
588(1)
Protect Your Backups
588(2)
Parallelizing Backup Operations
590(1)
Encrypting Backups
591(1)
Configuring RMAN Defaults
592(2)
Managing and Monitoring RMAN Backups
594(5)
The List, Report, and Delete Commands
594(2)
Archival Backups
596(1)
The Dynamic Performance Views
597(1)
Crosschecking Backups
597(2)
Two-Minute Drill
599(3)
Create Consistent Database Backups
599(1)
Back Up Your Database Without Shutting It Down
599(1)
Create Incremental Backups
599(1)
Automate Database Backups
600(1)
Manage Backups, View Backup Reports, and Monitor the Flash Recovery Area
600(1)
Define, Apply, and Use a Retention Policy
600(1)
Create Image File Backups
600(1)
Create a Whole Database Backup
600(1)
Enable Fast Incremental Backup
600(1)
Create Duplex Backups and Back Up Backup Sets
600(1)
Create an Archival Backup for Long-Term Retention
601(1)
Create a Multisection, Compressed, and Encrypted Backup
601(1)
Report On and Maintain Backups
601(1)
Configure Backup Settings
601(1)
Allocate Channels to Use in Backing Up
601(1)
Configure Backup Optimization
601(1)
Self Test
602(2)
Self Test Answers
604(3)
Restore and Recover with RMAN
607(34)
Exam Objectives
607(1)
The Data Recovery Advisor
608(5)
The Health Monitor and the ADR
608(1)
The Capabilities and Limitations of the DRA
609(1)
Using the Data Recovery Advisor
610(3)
Database Restore and Recovery
613(1)
Complete Recovery from Data File Loss Using RMAN
614(6)
Recovery of Datafiles in Noarchivelog Mode
614(2)
Recovery of a Noncritical File in Archivelog Mode
616(3)
Recovering from Loss of a Critical Datafile
619(1)
Incomplete Recovery
620(3)
Autobackup and Restore of the Controlfile
623(4)
Using Image Copies for Recovery
627(2)
Block Recovery
629(2)
Detection of Corrupt Blocks
629(1)
Block Media Recovery
630(1)
The Block Recover Command
630(1)
Two-Minute Drill
631(2)
Describe the Data Recovery Advisor
631(1)
Use the Data Recovery Advisor to Perform Recovery (Controlfile, Redo Log File, and Datafile)
631(1)
Perform Complete Recovery from a Critical or Noncritical Data File Loss Using RMAN
631(1)
Perform Incomplete Recovery Using RMAN
632(1)
Recover Using Incrementally Updated Backups
632(1)
Switch to Image Copies for Fast Recovery
632(1)
Recover Using a Backup Control File
632(1)
Perform Block Media Recovery
633(1)
Self Test
633(4)
Self Test Answers
637(4)
Advanced RMAN Facilities
641(36)
Exam Objectives
641(1)
The Recovery Catalog
642(7)
The Need for a Recovery Catalog
642(1)
Creating and Connecting to the Catalog
643(2)
The Virtual Private Catalog
645(1)
Protecting and Rebuilding the Catalog
646(3)
Stored Scripts
649(2)
Using RMAN to Create Databases
651(3)
Tablespace Point-in-Time Recovery (TSPITR)
654(4)
The TSPITR Methodology
654(1)
Perform Automated TSPITR
655(3)
RMAN Performance and Monitoring
658(9)
Monitoring RMAN Sessions and Jobs
658(4)
Tuning RMAN
662(3)
Tuning the BACKUP Command
665(1)
Configure RMAN for Asynchronous I/O
665(2)
Two-Minute Drill
667(4)
Identify Situations That Require an RMAN Recovery Catalog
667(1)
Create and Configure a Recovery Catalog
667(1)
Synchronize the Recovery Catalog
667(1)
Create and Use RMAN Stored Scripts
668(1)
Back Up the Recovery Catalog
668(1)
Create and Use a Virtual Private Catalog
668(1)
Create a Duplicate Database
668(1)
Use a Duplicate Database
669(1)
Restore a Database onto a New Host
669(1)
Perform Disaster Recovery
669(1)
Identify the Situations That Require TSPITR
669(1)
Perform Automated TSPITR
670(1)
Monitor RMAN Sessions and Jobs
670(1)
Tune RMAN
670(1)
Configure RMAN for Asynchronous I/O
671(1)
Self Test
671(3)
Self Test Answers
674(3)
User-Managed Backup, Restore, and Recovery
677(22)
Exam Objectives
677(1)
Backup and Recovery in One Page
678(1)
User-Managed Database Backup
678(4)
Backup in Noarchivelog Mode
678(2)
Backup in Archivelog Mode
680(2)
Backup of the Password and Parameter Files
682(1)
Media Failure That Does Not Affect Datafiles
683(5)
Recovery from Loss of a Multiplexed Controlfile
683(2)
Recovery from Loss of a Multiplexed Online Redo Log File
685(3)
Recovery from Loss of a Tempfile
688(1)
Recovery from Loss of Datafiles
688(3)
Recovery of Datafiles in Noarchivelog Mode
688(1)
Recovery of a Noncritical Datafile in Archivelog Mode
689(1)
Recovering a Critical Datafile in Archivelog Mode
690(1)
User-Managed Incomplete Recovery
691(2)
Two-Minute Drill
693(2)
Recover from a Lost TEMP File
693(1)
Recover from a Lost Redo Log Group
693(1)
Recover from the Loss of a Password File
694(1)
Perform User-Managed Complete Database Recovery
694(1)
Perform User-Managed Incomplete Database Recovery
694(1)
Perform User-Managed Backups
694(1)
Identify the Need for Backup Mode
695(1)
Back Up and Recover a Controlfile
695(1)
Self Test
695(2)
Self Test Answers
697(2)
Flashback
699(48)
Exam Objectives
699(1)
The Different Flashback Technologies
700(4)
Flashback Database
700(1)
Flashback Query, Transaction, and Table
701(1)
Flashback Drop
701(1)
Flashback Data Archive
702(1)
When to Use Flashback Technology
702(2)
Flashback Database
704(11)
Flashback Database Architecture
704(1)
Configuring Flashback Database
705(2)
Monitoring Flashback Database
707(2)
Using Flashback Database
709(4)
Limiting the Amount of Flashback Data Generated
713(2)
Flashback Drop
715(8)
The Implementation of Flashback Drop
715(2)
Using Flashback Drop
717(3)
Managing the Recycle Bin
720(3)
Flashback Query
723(13)
Basic Flashback Query
724(1)
Flashback Table Query
725(3)
Flashback Versions Query
728(1)
Flashback Transaction Query
729(6)
Flashback and Undo Data
735(1)
The Flashback Data Archive
736(3)
Two-Minute Drill
739(1)
Restore Dropped Tables from the Recycle Bin
739(1)
Perform Flashback Query
739(1)
Use Flashback Transaction
739(1)
Perform Flashback Table Operations
740(1)
Configure and Monitor Flashback Database and Perform Flashback Database Operations
740(1)
Set Up and Use a Flashback Data Archive
740(1)
Self Test
740(4)
Self Test Answers
744(3)
Automatic Storage Management
747(26)
Exam Objectives
747(1)
The Purpose of a Logical Volume Manager
748(3)
RAID Levels
748(1)
Volume Sizes
749(1)
Choice of RAID Level
750(1)
ASM Compared with Third-Party LVMs
750(1)
The ASM Architecture
751(5)
The Cluster Synchronization Service
751(1)
The ASM Disks and Disk Groups
751(2)
The ASM Instance
753(1)
The RDBMS Instance
754(1)
The ASM Files
755(1)
Creating Raw Devices
756(1)
Creating, Starting, and Stopping an ASM Instance
757(3)
Creating ASM Disk Groups
760(2)
Creating and Using ASM Files
762(1)
ASM and RMAN
763(2)
The ASMCMD Utility
765(1)
Two-Minute Drill
766(2)
Describe Automatic Storage Management (ASM)
766(1)
Set Up Initialization Parameter Files for ASM and Database Instances
767(1)
Start Up and Shut Down ASM Instances
767(1)
Administer ASM Disk Groups
767(1)
Self Test
768(3)
Self Test Answers
771(2)
The Resource Manager
773(32)
Exam Objectives
773(1)
The Need for Resource Management
774(1)
The Resource Manager Architecture
775(6)
Consumer Groups
775(1)
Resource Manager Plans
776(2)
Resource Manager Configuration Tools
778(3)
Managing Users and Consumer Groups
781(1)
Resource Manager Plans
781(13)
CPU Method
782(4)
Use of the Ratio CPU Method
786(1)
The Active Session Pool Method
787(2)
Limiting the Degree of Parallelism
789(1)
Controlling Jobs by Execution Time
790(1)
Terminating Sessions by Idle Time
791(2)
Restricting Generation of Undo Data
793(1)
Automatic Consumer Group Switching
794(1)
Adaptive Consumer Group Mapping
795(4)
Two-Minute Drill
799(1)
Understand the Database Resource Manager
799(1)
Create and Use Database Resource Manager Components
800(1)
Self Test
800(3)
Self Test Answers
803(2)
The Scheduler
805(26)
Exam Objectives
805(1)
The Scheduler Architecture
806(1)
Scheduler Objects
807(6)
Jobs
807(2)
Programs
809(1)
Schedules
809(1)
Job Classes
810(1)
Windows
811(1)
Privileges
812(1)
Creating and Scheduling Jobs
813(9)
A Self-Contained Job
813(1)
Using Programs and Schedules
814(3)
Event-Driven Jobs
817(2)
Job Chains
819(1)
Lightweight Jobs
819(3)
Using Classes, Windows, and the Resource Manager
822(4)
Using Job Classes
823(1)
Using Windows
824(2)
Two-Minute Drill
826(1)
Create a Job, Program, and Schedule
826(1)
Use a Time-Based or Event-Based Schedule for Executing Scheduler Jobs
826(1)
Create Lightweight Jobs
826(1)
Use Job Chains to Perform a Series of Related Tasks
826(1)
Create Windows and Job Classes
827(1)
Use Advanced Scheduler Concepts to Prioritize Jobs
827(1)
Self Test
827(2)
Self Test Answers
829(2)
Moving and Reorganizing Data
831(34)
Exam Objectives
831(1)
SQL*Loader
832(2)
External Tables
834(4)
Directories
835(1)
Using External Tables
835(3)
Data Pump
838(3)
Data Pump Architecture
839(1)
Directories and File Locations
840(1)
Direct Path or External Table Path?
840(1)
Using Data Pump Export and Import
841(9)
Capabilities
841(1)
Using Data Pump with the Command-Line Utilities
842(1)
Using Data Pump with Database Control
843(2)
Tablespace Export and Import
845(5)
Resumable Space Allocation
850(2)
Segment Reorganization
852(7)
Row Chaining and Migration
853(2)
Segment Shrink
855(4)
Two-Minute Drill
859(2)
Describe and Use Methods to Move Data (Directory Objects, SQL*Loader, External Tables)
859(1)
Explain the General Architecture of Oracle Data Pump
860(1)
Use Data Pump Export and Import to Move Data Between Oracle Databases
860(1)
Describe the Concepts of Transportable Tablespaces and Databases
860(1)
Manage Resumable Space Allocation
860(1)
Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
861(1)
Self Test
861(2)
Self Test Answers
863(2)
The AWR and the Alert System
865(26)
Exam Objectives
865(1)
The Automatic Workload Repository
866(5)
Gathering AWR Statistics
866(1)
Managing the AWR
867(2)
Statistics, Metrics, and Baselines
869(1)
The DBMS_WORKLOAD_REPOSITORY Package
869(2)
The Database Advisory Framework
871(9)
The Automatic Database Diagnostic Monitor
871(3)
The Advisors
874(1)
Automatic Maintenance Jobs
875(5)
Using the Server-Generated Alert System
880(6)
Alert Condition Monitoring and Notifications
880(1)
Setting Thresholds
881(1)
The Notification System
882(4)
Two-Minute Drill
886(1)
Use and Manage the Automatic Workload Repository
886(1)
Use the Advisory Framework
886(1)
Manage Alerts and Thresholds
887(1)
Self Test
887(2)
Self Test Answers
889(2)
Performance Tuning
891(46)
Exam Objectives
891(1)
Managing Memory
892(8)
PGA Memory Management
892(2)
SGA Memory Management
894(2)
Automatic Memory Management
896(1)
The Memory Advisors
897(3)
The SQL Tuning Advisor
900(10)
The Capabilities of the SQL Tuning Advisor
901(1)
Using the SQL Tuning Advisor with Enterprise Manager
901(7)
The SQL Tuning Advisor API: the DBMS_SQLTUNE Package
908(2)
The SQL Access Advisor
910(6)
Using the SQL Access Advisor with Database Control
910(3)
Using the SQL Access Advisor with DBMS_ADVISOR
913(3)
Identifying and Fixing Invalid and Unusable Objects
916(5)
Invalid Objects
916(2)
Unusable Indexes
918(3)
Database Replay
921(6)
Database Replay Workload Capture
921(1)
Database Replay Workload Preprocessing
922(1)
Launch the Replay
923(1)
Database Replay Analysis and Reporting
924(3)
Two-Minute Drill
927(3)
Use Automatic Memory Management
927(1)
Use Memory Advisors
928(1)
Troubleshoot Invalid and Unusable Objects
928(1)
Implement Automatic Memory Management
928(1)
Manually Configure SGA Parameters
928(1)
Configure Automatic PGA Memory Management
929(1)
Use the SQL Tuning Advisor
929(1)
Use the SQL Access Advisor to Tune a Workload
929(1)
Understand Database Replay
929(1)
Self Test
930(3)
Self Test Answers
933(4)
Globalization
937(28)
Exam Objectives
937(1)
Globalization Requirements and Capabilities
938(6)
Character Sets
938(2)
Language Support
940(2)
Territory Support
942(2)
Other NLS Settings
944(1)
Using Globalization Support Features
944(8)
Choosing a Character Set
945(1)
Changing Character Sets
946(1)
Globalization Within the Database
947(1)
Globalization at the Instance Level
948(1)
Client-Side Environment Settings
948(2)
Session-Level Globalization Settings
950(1)
Statement Globalization Settings
951(1)
Languages and Time Zones
952(5)
Linguistic Sorting and Selection
953(1)
The Locale Builder
954(1)
Using Time Zones
954(3)
Two-Minute Drill
957(1)
Customize Language-Dependent Behavior for the Database and Individual Sessions
957(1)
Work with Database and NLS Character Sets
958(1)
Self Test
958(3)
Self Test Answers
961(4)
The Intelligent Infrastructure
965(18)
Exam Objectives
965(1)
The Enterprise Manager Support Workbench
966(5)
The Automatic Diagnostic Repository (ADR)
966(1)
Problems and Incidents
967(1)
The ADR Command-Line Interface (ADRCI)
967(1)
The Support Workbench
968(3)
Patches
971(7)
Types of Patch
971(1)
Integration with MetaLink and the Patch Advisor
971(1)
Applying Patches
972(6)
Two-Minute Drill
978(1)
Use the Enterprise Manager Support Workbench
978(1)
Manage Patches
978(1)
Set Up the Automatic Diagnostic Repository
979(1)
SelfTest
979(1)
Self Test Answers
980(3)
Appendix About the CD
983(4)
System Requirements
984(1)
Installing and Running MasterExam
984(1)
MasterExam
984(1)
Electronic Book
984(1)
Help
984(1)
Removing Installation(s)
985(1)
Technical Support
985(2)
LearnKey Technical Support
985(2)
Glossary 987(16)
Index 1003
John Watson (UK) OCP DBA 8.0, 8.i, & 9i, 10g, 11g, Interrnet Application Server Administrator, and certified on Managing Oracle on Unix, is a senior consultant with BLP Management Consultants, and taught for Oracle University in South Africa for four years. John taught the DB10g New Features course, the DB10g Manageability and Performance seminars. He validated hundreds of OCP 10g New Features exam questions and contributed to the course material for all the 10g courses. John is the author of numerous articles on technology.





Bob Bryla (Plattville, WI) OCP, is an Oracle 8, 8i, 9i, 10g, and 11g Certified Professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands End in Dodgeville, Wisconsin. Bob is the co-author of the Oracle Database 11g DBA Handbook from Oracle Press (McGraw-Hill), and the OCA: Oracle 10g Administration I Study Guide (1Z0-042) and OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 from Sybex/Wiley.





Roopesh Ramklass, OCM, is a technical specialist with 10 years of experience in a wide variety of IT environments, including software development, system administration, systems analysis, software design, systems architecture, courseware development, and lecturing. Ramklass is experienced in managing and executing IT development projects, including infrastructure systems provisioning, software development, and systems integration.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97800716292182e.html