Muutke küpsiste eelistusi

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) 2nd edition [Raamat]

3.11/5 (11 hinnangut Goodreads-ist)
, ,
  • Formaat: Book, 1072 pages, kõrgus x laius x paksus: 236x211x58 mm, kaal: 1774 g, 450 Illustrations
  • Sari: All-in-One
  • Ilmumisaeg: 16-Sep-2015
  • Kirjastus: McGraw-Hill Professional
  • ISBN-10: 0071828087
  • ISBN-13: 9780071828086
Teised raamatud teemal:
OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) 2nd editionSuurem pilt
  • Formaat: Book, 1072 pages, kõrgus x laius x paksus: 236x211x58 mm, kaal: 1774 g, 450 Illustrations
  • Sari: All-in-One
  • Ilmumisaeg: 16-Sep-2015
  • Kirjastus: McGraw-Hill Professional
  • ISBN-10: 0071828087
  • ISBN-13: 9780071828086
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780071828086.html

This Oracle Press certification exam guide prepares you for the new Oracle Database 12c certification track, including the core requirements for OCA and OCP certification.

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail. Each chapter includes examples, practice questions, Inside the Exam sections highlighting key exam topics, a chapter summary, and a two-minute drill to reinforce essential knowledge. 300+ practice exam questions match the format, topics, and difficulty of the real exam.

  • Electronic content includes interactive practice exam software with hundreds of questions that include detailed answers and explanations, a score report performance assessment tool, and a PDF copy of the book
  • Ideal as both exam guide and on-the-job reference
  • The most comprehensive single preparation tool for the Oracle Database 12c OCA and OCP certification exams

Introduction xxxi
Part I Getting Started
Chapter 1 Installing Oracle Database Software
3(12)
Plan for an Oracle Database Software Installation
4(3)
Supported Platforms
4(1)
Obtain the Oracle Database Software
4(1)
User Accounts
5(1)
Disk Space and Directories
5(1)
The Prerequisite Checks
6(1)
Install the Oracle Database Software
7(5)
The OUI Inventory
7(1)
The OUI Dialog: Interactive Install
8(1)
Silent Install and Response Files
9(1)
Windows and Linux Variations
10(2)
Two-Minute Drill
12(1)
Plan for an Oracle Database Software Installation
12(1)
Install the Oracle Database Software
12(1)
Self Test
12(1)
Self Test Answers
13(2)
Chapter 2 Creating an Oracle Database Using DBCA
15(24)
Create a Database by Using the Database Configuration Assistant
16(9)
The Instance, the Database, and the Data Dictionary
16(1)
Using the Database Configuration Assistant to Create a Database
17(2)
The DBCA Dialog
19(6)
Generate Database Creation Scripts by Using DBCA
25(5)
Generating the Scripts
25(1)
The Creation Scripts
26(2)
The Initialization Parameter File
28(2)
Manage Database Design Templates by Using DBCA
30(1)
Configure Database Options by Using DBCA
31(2)
Two-Minute Drill
33(1)
Create a Database by Using the Database Configuration Assistant .
33(1)
Generate Database Creation Scripts by Using DBCA
33(1)
Manage Database Design Templates by Using DBCA
33(1)
Configure Database Options by Using DBCA
33(1)
Self Test
33(3)
Self Test Answers
36(3)
Chapter 3 Installing Oracle Grid Infrastructure for a Stand-Alone Server
39(16)
Configure Storage for Oracle Automatic Storage Management
40(5)
GI Architecture
40(1)
ASM Architecture
41(2)
ASM Disks
43(1)
Creating ASM Disks
44(1)
Install Oracle Grid Infrastructure for a Stand-Alone Server
45(6)
Two-Minute Drill
51(1)
Configure Storage for Oracle Automatic Storage Management
51(1)
Install Oracle Grid Infrastructure for a Stand-Alone Server
51(1)
Self Test
52(1)
Self Test Answers
53(2)
Chapter 4 Using Oracle Restart
55(12)
Use Oracle Restart to Manage Components
56(6)
Administering the Oracle Restart Processes
56(2)
Administering Registered Resources
58(1)
The Restart Capability
59(3)
Two-Minute Drill
62(1)
Use Oracle Restart to Manage Components
62(1)
Self Test
63(1)
Self Test Answers
64(3)
Part II SQL
Chapter 5 DDL and Schema Objects
67(64)
Use the Client Tools
68(8)
SQL*Plus
68(5)
SQL Developer
73(3)
Categorize the Main Database Objects
76(5)
Object Types
76(1)
Users and Schemas
77(1)
Naming Schema Objects
78(1)
Object Namespaces
79(2)
List the Data Types that Are Available for Columns
81(3)
Create a Simple Table
84(6)
Creating Tables with Column Specifications
84(1)
Creating Tables from Subqueries
85(1)
Altering Table Definitions After Creation
86(1)
Dropping and Truncating Tables
87(3)
Create and Use Temporary Tables
90(2)
Indexes
92(8)
Why Indexes Are Needed
92(1)
Types of Indexes
93(5)
Creating and Using Indexes
98(1)
Modifying and Dropping Indexes
99(1)
Constraints
100(7)
The Types of Constraints
101(2)
Defining Constraints
103(2)
Constraint State
105(1)
Constraint Checking
106(1)
Views
107(5)
Why Use Views at All?
108(2)
Simple and Complex Views
110(1)
CREATE VIEW, ALTER VIEW, and DROP VIEW
111(1)
Synonyms
112(3)
Sequences
115(5)
Creating Sequences
115(2)
Using Sequences
117(3)
Two-Minute Drill
120(2)
Categorize the Main Database Objects
120(1)
List the Data Types that Are Available for Columns
120(1)
Create a Simple Table
120(1)
Create and Use Temporary Tables
121(1)
Indexes
121(1)
Constraints
121(1)
Views
121(1)
Synonyms
122(1)
Sequences
122(1)
Self Test
122(5)
Self Test Answers
127(4)
Chapter 6 DML and Concurrency
131(54)
Describe Each Data Manipulation Language Statement
132(12)
INSERT
132(4)
UPDATE
136(3)
DELETE
139(2)
TRUNCATE
141(1)
MERGE
142(1)
DML Statement Failures
143(1)
Control Transactions
144(10)
Database Transactions
145(1)
Executing SQL Statements
146(3)
Transaction Control: COMMIT, ROLLBACK, SAVEPOINT, SELECT FOR UPDATE
149(5)
Explain DML and Undo Data Generation
154(2)
Monitor and Administer Undo Data
156(5)
Error Conditions Related to Undo
156(1)
Parameters for Undo Management
156(1)
Sizing and Monitoring the Undo Tablespace
157(2)
Temporary Undo
159(1)
Creating and Managing Undo Tablespaces
159(2)
Describe the Difference Between Undo Data and Redo Data
161(1)
Configure Undo Retention
162(2)
Configuring Undo Retention to Support Long-Running Queries
162(1)
Flashback Query and Undo Retention
163(1)
Describe the Locking Mechanism and Data Concurrency Management
164(4)
Shared and Exclusive Locks
165(1)
The Enqueue Mechanism
166(1)
Automatic and Manual Locking
166(2)
Monitor and Resolve Locking Conflicts
168(5)
The Causes of Lock Contention
168(1)
Detecting Lock Contention
169(2)
Solving Lock Contention
171(1)
Deadlocks: A Special Case
171(2)
Two-Minute Drill
173(2)
Describe Each Data Manipulation Language Statement
173(1)
Control Transactions
174(1)
Explain DML and Undo Data Generation
174(1)
Monitor and Administer Undo Data
174(1)
Describe the Difference Between Undo Data and Redo Data
174(1)
Configure Undo Retention
174(1)
Describe the Locking Mechanism and Data Concurrency Management
175(1)
Monitor and Resolve Locking Conflicts
175(1)
Self Test
175(6)
Self Test Answers
181(4)
Chapter 7 Retrieving, Restricting, and Sorting Data Using SQL
185(56)
Explain the Capabilities of SQL SELECT Statements
186(3)
Introducing the SQL SELECT Statement
186(1)
The DESCRIBE Table Command
186(2)
Capabilities of the SELECT Statement
188(1)
Data Normalization
189(15)
Data Modeling
190(1)
Entities and Relations
190(7)
Rows and Tables
197(2)
Create the Demonstration Schemas
199(1)
Users and Schemas
200(1)
The HR and OE Schemas
200(3)
Demonstration Schema Creation
203(1)
Execute a Basic SELECT Statement
204(10)
Syntax of the Primitive SELECT Statement
205(1)
Rules Are Meant to Be Followed
206(3)
SQL Expressions and Operators
209(3)
NULL Is Nothing
212(2)
Limit the Rows Retrieved by a Query
214(11)
The WHERE Clause
214(3)
Comparison Operators
217(5)
Boolean Operators
222(2)
Precedence Rules
224(1)
Sort the Rows Retrieved by a Query
225(4)
The ORDER BY Clause
225(2)
The SQL Row-Limiting Clause
227(2)
Ampersand Substitution
229(5)
Substitution Variables
229(3)
Define and Verify
232(2)
Two-Minute Drill
234(2)
Explain the Capabilities of SQL SELECT Statements
234(1)
Execute a Basic SELECT Statement
235(1)
Limit the Rows Retrieved by a Query
235(1)
Sort the Rows Retrieved by a Query
235(1)
Ampersand Substitution
236(1)
Self Test
236(3)
Self Test Answers
239(2)
Chapter 8 Single-Row and Conversion Functions
241(38)
Describe and Use Character, Number, and Date Functions in SQL
242(13)
Defining a Function
242(1)
Types of Functions
242(1)
Using Case Conversion Functions
243(2)
Using Character Manipulation Functions
245(3)
Using Numeric Functions
248(3)
Working with Dates
251(4)
Describe Various Types of Conversion Functions Available in SQL
255(2)
Conversion Functions
255(2)
Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
257(8)
Using the Conversion Functions
257(8)
Apply Conditional Expressions in a SELECT Statement
265(9)
Nested Functions
265(1)
Conditional Functions
266(8)
Two-Minute Drill
274(1)
Describe Various Types of Conversion Functions Available in SQL
274(1)
Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
274(1)
Apply Conditional Expressions in a SELECT Statement
274(1)
Self Test
275(2)
Self Test Answers
277(2)
Chapter 9 Group Functions
279(24)
Describe the Group Functions
280(7)
Definition of Group Functions
280(1)
Using Group Functions
281(6)
Group Data Using the GROUP BY Clause
287(6)
Creating Groups of Data
287(2)
The GROUP BY Clause
289(2)
Grouping by Multiple Columns
291(1)
Nested Group Functions
292(1)
Include or Exclude Grouped Rows Using the HAVING Clause
293(3)
Restricting Group Results
293(1)
The HAVING Clause
294(2)
Two-Minute Drill
296(1)
Describe the Group Functions
296(1)
Group Data Using the GROUP BY Clause
297(1)
Include or Exclude Grouped Rows Using the HAVING Clause
297(1)
Self Test
297(3)
Self Test Answers
300(3)
Chapter 10 SQL Joins
303(38)
Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
304(17)
Types of Joins
305(4)
Joining Tables Using ANSI SQL Syntax
309(1)
Qualifying Ambiguous Column Names
310(1)
The NATURAL JOIN Clause
311(3)
The JOIN USING Clause
314(1)
The JOIN ON Clause
315(3)
N-Way Joins and Additional Join Conditions
318(1)
Nonequijoins
319(2)
Join a Table to Itself Using a Self-Join
321(3)
Joining a Table to Itself Using the JOIN... ON Clause
321(3)
View Data That Does Not Meet a Join Condition by Using Outer Joins
324(7)
Inner versus Outer Joins
325(1)
Left Outer Joins
325(1)
Right Outer Joins
326(3)
Full Outer Joins
329(2)
Generate a Cartesian Product of Two or More Tables
331(3)
Creating Cartesian Products Using Cross Joins
331(3)
Two-Minute Drill
334(1)
Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
334(1)
Join a Table to Itself Using a Self-Join
334(1)
View Data that Does Not Meet a Join Condition Using Outer Joins
334(1)
Generate a Cartesian Product of Two or More Tables
335(1)
Self Test
335(2)
Self Test Answers
337(4)
Chapter 11 Subqueries and Set Operators
341(32)
Define Subqueries
342(1)
Describe the Types of Problems that the Subqueries Can Solve
343(5)
Use of a Subquery Result Set for Comparison Purposes
343(1)
Star Transformation
344(1)
Generate a Table from Which to SELECT
345(1)
Generate Values for Projection
345(1)
Generate Rows to Be Passed to a DML Statement
346(2)
Describe the Types of Subqueries
348(3)
Single- and Multiple-Row Subqueries
348(1)
Correlated Subqueries
349(2)
Write Single-Row and Multiple-Row Subqueries
351(1)
Using the EXISTS Condition
352(1)
Null Results in a Subquery
352(1)
Describe the Set Operators
352(4)
Sets and Venn Diagrams
353(1)
Set Operator General Principles
353(3)
Use a Set Operator to Combine Multiple Queries into a Single Query
356(5)
The UNION ALL Operator
356(1)
The UNION Operator
357(1)
The INTERSECT Operator
358(1)
The MINUS Operator
359(1)
More Complex Examples
360(1)
Control the Order of Rows Returned
361(1)
Two-Minute Drill
362(1)
Define Subqueries
362(1)
Describe the Types of Problems that the Subqueries Can Solve
362(1)
Describe the Types of Subqueries
362(1)
Write Single-Row and Multiple-Row Subqueries
362(1)
Describe the Set Operators
362(1)
Use a Set Operator to Combine Multiple Queries into a Single Query
363(1)
Control the Order of Rows Returned
363(1)
Self Test
363(5)
Self Test Answers
368(5)
Part III DBA1*
Chapter 12 Architectural Overview of Oracle Database 12c
373(36)
List the Architectural Components of an Oracle Database
374(4)
Single-Instance Database Architecture
374(3)
Distributed Systems Architectures
377(1)
Explain the Memory Structures
378(8)
The Database Buffer Cache
379(1)
The Log Buffer
380(2)
The Shared Pool
382(2)
The Large Pool
384(1)
The Java Pool
384(1)
The Streams Pool
384(2)
Describe the Background Processes
386(9)
SMON, the System Monitor
386(1)
PMON, the Process Monitor
386(1)
DBWn, the Database Writer
387(2)
LGWR, the Log Writer
389(1)
CKPT, the Checkpoint Process
390(1)
MMON, the Manageability Monitor
390(1)
MMNL, the Manageability Monitor Light
390(1)
MMAN, the Memory Manager
390(1)
LREG, the Listener Registration Process
391(1)
ARCn, the Archiver
391(1)
RECO, the Recoverer Process
392(1)
Some Other Background Processes
392(3)
Explain the Relationship Between Logical and Physical Storage Structures
395(8)
The Physical Database Structures
395(5)
The Logical Database Structures
400(1)
The Data Dictionary
400(3)
Two-Minute Drill
403(1)
List the Architectural Components of an Oracle Database
403(1)
Explain the Memory Structures
403(1)
Describe the Background Processes
403(1)
Explain the Relationship Between Logical and Physical Storage Structures
403(1)
Self Test
404(2)
Self Test Answers
406(3)
Chapter 13 Instance Management
409(32)
Use Database Management Tools
410(6)
Working with SQL*Plus
410(1)
Log On as a Normal or Privileged User
411(1)
Working with Database Express
412(4)
Understand Initialization Parameter Files
416(8)
Static and Dynamic Parameter Files
416(1)
Static and Dynamic Parameters and the Initialization Parameter File
417(2)
The Basic Parameters
419(1)
Changing Parameters
420(4)
Start Up and Shut Down an Oracle Database Instance
424(7)
Starting the Database Listener
424(1)
Database Startup and Shutdown
425(6)
View the Alert Log and Access Dynamic Performance Views
431(3)
The Alert Log
431(1)
The DDL Log
432(1)
The Dynamic Performance Views
432(2)
Two-Minute Drill
434(1)
Use Database Management Tools
434(1)
Understand Initialization Parameter Files
434(1)
Start Up and Shut Down an Oracle Database Instance
435(1)
View the Alert Log and Access Dynamic Performance Views
435(1)
Self Test
435(3)
Self Test Answers
438(3)
Chapter 14 Oracle Networking
441(28)
Configure Oracle Net Services
442(10)
Oracle Net and the Client-Server Paradigm
442(1)
Establishing a Session
443(2)
Creating a Database Listener
445(1)
Dynamic Service Registration
446(1)
Shared Server
446(6)
Use Tools for Configuring and Managing the Oracle Network
452(3)
The Net Manager
452(1)
The Net Configuration Assistant
452(1)
The Listener Control Utility
452(2)
The TNS_ADMIN Environment Variable
454(1)
Configure Client-Side Network
455(5)
Easy Connect Name Resolution
455(1)
Local Naming Name Resolution
455(1)
Directory Naming and External Naming
456(1)
Testing Oracle Net Connectivity
457(3)
Understand Database Resident Connection Pooling
460(1)
Configure Communication Between Databases
461(1)
Two-Minute Drill
462(1)
Configure Oracle Net Services
462(1)
Use Tools for Configuring and Managing the Oracle Network
462(1)
Configure Client-Side Network
463(1)
Understand Database Resident Connection Pooling
463(1)
Configure Communication Between Databases
463(1)
Self Test
463(3)
Self Test Answers
466(3)
Chapter 15 Oracle Storage
469(38)
Describe the Storage of Table Row Data in Blocks
470(6)
The Oracle Data Storage Model
470(2)
Segments, Extents, Blocks, and Rows
472(4)
Create and Manage Tablespaces
476(12)
Creating Tablespaces
476(3)
Altering Tablespaces
479(4)
Dropping Tablespaces
483(1)
Extent Management
483(1)
Segment Space Management
484(1)
Oracle Managed Files
485(3)
Explain How Oracle Database Server Automatically Manages Space
488(3)
Segment Space Assignment
488(2)
Automatic Segment Space Management
490(1)
Save Space by Using Compression
491(1)
Proactively Monitor and Manage Tablespace Space Usage
492(1)
Use the Segment Advisor
493(1)
Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
494(2)
Manage Resumable Space Allocation
496(1)
Two-Minute Drill
497(2)
Describe the Storage of Table Row Data in Blocks
497(1)
Create and Manage Tablespaces
497(1)
Explain How Oracle Database Server Automatically Manages Space
498(1)
Save Space by Using Compression
498(1)
Proactively Monitor and Manage Tablespace Space Usage
498(1)
Use the Segment Advisor
498(1)
Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
498(1)
Manage Resumable Space Allocation
499(1)
Self Test
499(4)
Self Test Answers
503(4)
Chapter 16 Oracle Security
507(38)
Create and Manage Database User Accounts
508(9)
User Account Attributes
508(4)
Authentication Methods
512(3)
Creating Accounts
515(2)
Grant and Revoke Privileges
517(5)
System Privileges
518(2)
Object Privileges
520(2)
Create and Manage Roles
522(5)
Creating and Granting Roles
522(2)
Predefined Roles
524(1)
Enabling Roles
524(1)
Privilege Analysis
525(2)
Create and Manage Profiles
527(2)
Password Profile Limits
527(1)
Creating and Assigning Profiles
528(1)
Explain DBA Responsibilities for Security and Auditing
529(5)
Reasons for Auditing
530(1)
Auditing Techniques
530(4)
Enable Standard Database Auditing and Unified Auditing
534(4)
Enable Standard Auditing
534(1)
Enable Unified Auditing
535(3)
Two-Minute Drill
538(1)
Create and Manage Database User Accounts
538(1)
Grant and Revoke Privileges
538(1)
Create and Manage Roles
538(1)
Create and Manage Profiles
539(1)
Explain DBA Responsibilities for Security and Auditing
539(1)
Enable Standard Database Auditing and Unified Auditing
539(1)
Self Test
539(3)
Self Test Answers
542(3)
Chapter 17 Moving and Re-organizing Data
545(28)
Describe Ways to Move Data
546(1)
Create and Use Directory Objects
546(2)
Use SQL*Loader to Load Data from a Non-Oracle Database
548(4)
Using SQL*Loader
548(2)
SQL*Loader Express Mode
550(2)
Use External Tables to Move Data via Platform-Independent Files
552(2)
Explain the General Architecture of Oracle Data Pump
554(2)
Use Data Pump Export and Import to Move Data Between Oracle Databases
556(5)
Capabilities
556(1)
Using Data Pump with the Command-Line Utilities
556(1)
Tablespace Export and Import
557(4)
Use Data Pump in a Multitenant Environment
561(4)
Export from Non-CDB and Import into PDB
561(2)
Export and Import Between PDBs
563(1)
Export from PDB and Import into Non-CDB
564(1)
Full Transportable Export and Import
564(1)
Transporting a Database Over the Network
565(1)
Use SQL*Loader in a Multitenant Environment
565(1)
Two-Minute Drill
565(2)
Describe Ways to Move Data
565(1)
Create and Use Directory Objects
566(1)
Use SQL*Loader to Load Data from a Non-Oracle Database
566(1)
Use External Tables to Move Data via Platform-Independent Files
566(1)
Explain the General Architecture of Oracle Data Pump
566(1)
Use Data Pump Export and Import to Move Data Between Oracle Databases
566(1)
Use Data Pump in a Multitenant Environment
566(1)
Use SQL*Loader in a Multitenant Environment
567(1)
Self Test
567(3)
Self Test Answers
570(3)
Chapter 18 The AWR and the Alert System
573(18)
Manage the Automatic Workload Repository
574(3)
Gathering AWR Statistics
574(1)
Managing the AWR
575(2)
Use the Automatic Database Diagnostic Monitor
577(1)
Describe and Use the Advisory Framework
578(2)
The Memory Advisors
578(1)
The SQL Advisors
579(1)
The Automatic Undo Advisor
579(1)
The Mean Time to Recover Advisor
579(1)
The Data Recovery Advisor
579(1)
The Segment Advisor
580(1)
The SQL Repair Advisor
580(1)
Set Alert Thresholds
580(4)
Alert Condition Monitoring and Notifications
580(1)
Setting Thresholds
581(3)
Use Automated Tasks
584(2)
The Autotasks
584(1)
Controlling the Autotasks
585(1)
Two-Minute Drill
586(1)
Manage the Automatic Workload Repository
586(1)
Use the Automatic Database Diagnostic Monitor
586(1)
Describe and Use the Advisory Framework
586(1)
Set Alert Thresholds
586(1)
Use Automated Tasks
587(1)
Self Test
587(2)
Self Test Answers
589(2)
Chapter 19 Performance Tuning
591(30)
Use Enterprise Manager to Monitor Performance
592(4)
A Performance Tuning Methodology
592(1)
Performance Monitoring Data
593(1)
The Database Express Performance Pages
594(2)
Use Automatic Memory Management
596(6)
PGA Memory Management
596(2)
SGA Memory Management
598(2)
Automatic Memory Management
600(2)
Use the Memory Advisor to Size Memory Buffers
602(2)
Manage Optimizer Statistics
604(5)
Object Statistics
604(1)
How the Optimizer Uses Statistics
605(2)
Gathering Statistics Manually
607(2)
Use the SQL Tuning Advisor
609(3)
The Capabilities of the SQL Tuning Advisor
610(1)
The SQL Tuning Advisor API: The DBMS_SQLTUNE Package
610(2)
Use the SQL Access Advisor to Tune Workload
612(2)
The Capabilities of the SQL Access Advisor
612(1)
Using the SQL Access Advisor with DBMS ADVISOR
613(1)
Two-Minute Drill
614(1)
Use Enterprise Manager to Monitor Performance
614(1)
Use Automatic Memory Management
615(1)
Use the Memory Advisor to Size Memory Buffers
615(1)
Manage Optimizer Statistics
615(1)
Use the SQL Tuning Advisor
615(1)
Use the SQL Access Advisor to Tune Workload
615(1)
Self Test
615(3)
Self Test Answers
618(3)
Chapter 20 The Resource Manager
621(24)
Configure the Database Resource Manager
622(6)
The Need for Resource Management
622(1)
The Resource Manager Architecture
623(3)
Resource Manager Configuration
626(2)
Access and Create Resource Plans
628(9)
CPU Method
628(3)
Use of the Ratio CPU Method
631(1)
The Active Session Pool Method
632(1)
Limiting the Degree of Parallelism
633(1)
Controlling Jobs by Execution Time
633(1)
Terminating Sessions by Idle Time
634(1)
Restricting Generation of Undo Data
635(2)
Monitor the Resource Manager
637(1)
Two-Minute Drill
638(1)
Configure the Database Resource Manager
638(1)
Access and Create Resource Plans
639(1)
Monitor the Resource Manager
639(1)
Self Test
639(3)
Self Test Answers
642(3)
Chapter 21 The Scheduler
645(18)
Use Oracle Scheduler to Simplify Management Tasks
646(6)
The Scheduler Architecture
646(1)
Scheduler Objects
647(5)
Use Job Chains to Perform a Series of Related Tasks
652(1)
Use Scheduler Jobs on Remote Systems
653(1)
Use Advanced Scheduler Features to Prioritize Jobs
653(4)
Using Job Classes
654(1)
Using Windows
655(2)
Two-Minute Drill
657(1)
Use Oracle Scheduler to Simplify Management Tasks
657(1)
Use Job Chains to Perform a Series of Related Tasks
657(1)
Use Scheduler Jobs on Remote Systems
657(1)
Use Advanced Scheduler Features to Prioritize Jobs
657(1)
Self Test
658(1)
Self Test Answers
659(4)
Part IV DBA2*
Chapter 22 Configuring the Database for Backup and Recovery
663(22)
Possible Failures and Their Resolution
664(4)
Failure Categories
664(1)
Oracle Backup and Recovery Solutions
665(1)
Instance Recovery and the Impossibility of Database Corruption
666(2)
Checkpoints and the Redo Log
668(5)
The Checkpointing Mechanism
668(2)
Protecting the Online Redo Log Files
670(2)
Archivelog Mode and the Archiver Processes
672(1)
Backup and Recovery: Configuration
673(2)
Configure the Fast Recovery Area
675(1)
Configure ARCHIVELOG Mode
676(2)
Two-Minute Drill
678(1)
Possible Failures and Their Resolution
678(1)
Checkpoints and the Redo Log
678(1)
Configure the Fast Recovery Area
678(1)
Configure ARCHIVELOG Mode
679(1)
Configure Control Files and Redo Log Files for Recoverability
679(1)
Self Test
679(3)
Self Test Answers
682(3)
Chapter 23 Back Up with RMAN
685(38)
Backup Theory and Basic Syntax
686(10)
Backup Concepts
686(2)
RMAN Basic Syntax
688(4)
Persistent RMAN Settings
692(4)
Some Advanced RMAN Capabilities
696(15)
The Recovery Catalog
696(3)
Create and Use RMAN Stored Scripts
699(2)
Incremental Backups
701(4)
Other Capabilities
705(6)
Two-Minute Drill
711(3)
Create Consistent Database Backups
711(1)
Back Up Your Database Without Shutting It Down
711(1)
Create Incremental Backups
711(1)
Automate Database Backups
711(1)
Manage Backups and the RMAN Repository
711(1)
Use Various RMAN Backup Types and Strategies
712(1)
Perform Full and Incremental Backups
712(1)
Use Techniques to Improve Backups
713(1)
Self Test
714(5)
Self Test Answers
719(4)
Chapter 24 Restore and Recover with RMAN
723(32)
Perform Complete and Incomplete Recovery
724(12)
Restore and Recovery in One Page
724(1)
Using the RMAN RESTORE and RECOVER Commands
725(1)
Performing Complete Recovery of a Noncritical Datafile
725(2)
Performing Complete Recovery of a Critical Datafile
727(1)
Performing Incomplete Recovery Using RMAN
727(3)
Recovering Using Incrementally Updated Backups
730(1)
Switching to Image Copies for Fast Recovery
731(5)
Perform Recovery for Spfiles, Controlfiles, and Online Redo Log Files
736(8)
Restoring the Spfile from the Autobackup
736(1)
Restoring the Controlfile
737(1)
Recovering from a Lost Redo Log Group
738(5)
Backing Up and Restoring the Password File
743(1)
Recovering from a Lost Tempfile
743(1)
Two-Minute Drill
744(3)
Perform Complete and Incomplete Recovery
744(1)
Perform Recovery for Spfiles, Controlfiles, and Online Redo Log Files
745(2)
Perform Recovery of Tempfiles
747(1)
Self Test
747(4)
Self Test Answers
751(4)
Chapter 25 Diagnosing Failures
755(22)
Describe the Automatic Diagnostic Workflow
756(9)
Understanding the ADR
756(3)
Using the ADRCI Tool
759(2)
Understanding Alerts, Problems, and Incidents
761(1)
Using the Health Monitor
762(3)
Handle Block Corruption
765(6)
Block Corruption
765(1)
Using Block Media Recovery
766(3)
Using the Data Recovery Advisor
769(2)
Two-Minute Drill
771(2)
Describe the Automatic Diagnostic Workflow
771(1)
Handle Block Corruption
772(1)
Self Test
773(1)
Self Test Answers
774(3)
Chapter 26 Flashback
777(38)
Describe the Flashback Technologies
778(3)
Flashback Database
778(1)
Flashback Query, Transaction, and Table
778(1)
Flashback Drop
779(1)
Flashback Data Archive
780(1)
When to Use Flashback Technology
780(1)
Use Flashback to Query Data
781(10)
Basic Flashback Query
781(2)
Flashback Table Query
783(2)
Flashback Versions Query
785(2)
Flashback Transaction Query
787(3)
Flashback and Undo Data
790(1)
Perform Flashback Table Drop Operations
791(7)
The Implementation of Flashback Drop
792(1)
Using Flashback Drop
793(4)
Managing the Recycle Bin
797(1)
Perform Table Recovery from Backups
798(1)
Describe and Use Flashback Data Archive
799(2)
Perform Flashback Database
801(7)
Flashback Database Architecture
801(2)
Configuring Flashback Database
803(1)
Monitoring Flashback Database
804(1)
Using Flashback Database
805(3)
Two-Minute Drill
808(1)
Describe the Flashback Technologies
808(1)
Use Flashback to Query Data
808(1)
Perform Flashback Table Operations
808(1)
Perform Table Recovery from Backups
808(1)
Describe and Use Flashback Data Archive
808(1)
Perform Flashback Database
809(1)
Self Test
809(3)
Self Test Answers
812(3)
Chapter 27 Duplicating a Database
815(18)
Describe and Use Transportable Tablespaces and Databases
816(5)
Configuring Transportable Tablespaces
816(2)
Transporting Tablespaces
818(2)
Transporting a Database
820(1)
Duplicate a Database
821(6)
Using a Duplicate Database
822(1)
Duplicate from the Active Database
822(3)
Duplicate from Backup
825(2)
Two-Minute Drill
827(2)
Describe and Use Transportable Tablespaces and Databases
827(1)
Choose a Technique for Duplicating a Database
828(1)
Create a Backup-Based Duplicate Database
828(1)
Duplicate a Database
829(1)
Self Test
829(2)
Self Test Answers
831(2)
Chapter 28 Encrypting, Securing, Monitoring, and Tuning RMAN Backups
833(22)
Create RMAN-Encrypted Backups
834(4)
Configuring and Using Transparent Encryption
834(3)
Using Password Encryption
837(1)
Using Dual-Mode Encryption
837(1)
Configure and Use Oracle Secure Backup
838(2)
Installing and Configuring Oracle Secure Backup
838(1)
Using RMAN with Oracle Secure Backup
838(1)
Miscellaneous obtool Commands
839(1)
Monitor and Tune RMAN Performance
840(7)
Monitoring RMAN Sessions and Jobs
841(2)
Tuning RMAN Performance
843(1)
Identifying Backup and Restore Steps
844(1)
Parallelizing Backupsets
844(1)
Understanding RMAN Multiplexing
845(1)
Tuning RMAN Channels
846(1)
Tuning the BACKUP Command
846(1)
Two-Minute Drill
847(1)
Create RMAN-Encrypted Backups
847(1)
Configure and Use Oracle Secure Backup
847(1)
Tune RMAN Performance
847(1)
Self Test
848(2)
Self Test Answers
850(5)
Part V Upgrades and Multitenant
Chapter 29 Upgrading Oracle Database Software and Migrating Data
855(12)
Describe Upgrade Methods
856(3)
Software Upgrade
856(2)
Database Upgrade: DBUA or Manual
858(1)
Describe Data Migration Methods
859(1)
Describe the Upgrade Process
859(1)
Migrate Data by Using Oracle Data Pump
860(2)
Two-Minute Drill
862(1)
Describe Upgrade Methods
862(1)
Describe Data Migration Methods
862(1)
Describe the Upgrade Process
862(1)
Migrate Data by Using Oracle Data Pump
862(1)
Self Test
863(1)
Self Test Answers
864(3)
Chapter 30 Upgrading an Oracle Database
867(16)
Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
868(1)
Oracle Label Security and Oracle Data Vault
868(1)
Oracle Warehouse Builder
869(1)
Use the Pre-Upgrade Information Tool Before Performing an Upgrade
869(1)
Prepare the New Oracle Home Prior to Performing an Upgrade
870(1)
Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant
871(3)
Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
874(1)
Migrate to Unified Auditing
875(1)
Perform Postupgrade Tasks
876(1)
Two-Minute Drill
877(1)
Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
877(1)
Use the Pre-Upgrade Information Tool Before Performing an Upgrade
877(1)
Prepare the New Oracle Home Prior to Performing an Upgrade
877(1)
Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant
878(1)
Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
878(1)
Migrate to Unified Auditing
878(1)
Perform Post-Upgrade Tasks
878(1)
Self Test
878(3)
Self Test Answers
881(2)
Chapter 31 Multitenant Container and Pluggable Database Architecture
883(12)
Describe the Multitenant Container Database Architecture
884(7)
Multitenant Concepts
884(3)
The Drivers for Multitenant
887(1)
The CDB and the Root Container
888(1)
PDBs: Pluggable Containers
889(2)
Explain Pluggable Database Provisioning
891(1)
Techniques for Provisioning Pluggable Containers
891(1)
Communications Between Containers
891(1)
Two-Minute Drill
892(1)
Describe the Multitenant Container Database Architecture
892(1)
Explain Pluggable Database Provisioning
893(1)
Self Test
893(1)
Self Test Answers
894(1)
Chapter 32 Creating and Managing Multitenant Container and Pluggable Databases
895(30)
Create a Container Database
896(4)
Use DBCA to Create a CDB
896(2)
Using SQL*Plus to Create a CDB
898(2)
Create Pluggable Containers
900(7)
Using PDB$SEED to Create a New PDB
901(1)
Cloning a PDB to Create a New PDB
902(2)
Plug a Non-CDB into a CDB
904(2)
Plug an Unplugged PDB into a CDB
906(1)
Unplug and Drop a PDB
907(1)
Migrate a Pre-12.1 Non-CDB Database to CDB
907(1)
Establish Connections to CDBs and PDBs
908(3)
Understanding CDB and PDB Service Names
908(2)
Creating Services for CDBs or PDBs
910(1)
Switching Connections Within a CDB
910(1)
Start Up and Shut Down a CDB and Open and Close PDBs
911(7)
CDB Instance Startup
912(2)
Open and Close a PDB
914(2)
CDB Instance Shutdown
916(1)
Automating PDB Startup
916(2)
Changing PDB Status
918(1)
Evaluate the Impact of Parameter Value Changes
918(2)
Understanding the Scope of Parameter Changes
919(1)
Using ALTER SYSTEM in a Multitenant Environment
919(1)
Two-Minute Drill
920(1)
Create a Container Database
920(1)
Create Pluggable Containers
920(1)
Migrate a Pre-12.1 Non-CDB Database to CDB
920(1)
Establish Connections to CDBs and PDBs
920(1)
Start Up and Shut Down a CDB and Open and Close PDBs
921(1)
Evaluate the Impact of Parameter Value Changes
921(1)
Self Test
921(2)
Self Test Answers
923(2)
Chapter 33 Managing Storage, Security, Availability, and Performance in a CDB and PDBs
925(36)
Space Management in a Multitenant Environment
926(4)
Tablespace Architecture
926(1)
Using CREATE TABLESPACE
927(1)
Default Permanent and Temporary Tablespaces in a PDB
928(2)
Manage Common and Local Users, Roles, and Privileges
930(8)
Common and Local Users
930(2)
Grant Privileges Commonly and Locally
932(1)
Manage Common and Local Roles
933(1)
Enable Common Users to Access Data in Specific PDBs
934(3)
Audit in the Multitenant Environment
937(1)
Multitenant Backup and Recovery
938(2)
Back Up a CDB and Individual PDBs
938(2)
Restore and Recovery
940(1)
Duplicate PDBs Using RMAN
940(1)
Mulitenant Performance Monitoring and Tuning
941(3)
Tuning the Instance
941(2)
Using Memory Advisors
943(1)
Manage Allocation of Resources Between PDBs and Within a PDB
944(5)
Using Shares to Manage Inter-PDB Resources
944(1)
Creating and Modifying Resource Manager Plans
945(4)
Perform Database Replay
949(2)
Capture Source Database Workloads
949(1)
Process Workloads on the Target System
950(1)
Replay Workloads on Target CDB: Consolidated Replay
950(1)
Two-Minute Drill
951(4)
Manage Permanent and Temporary Tablespaces in CDB and PDBs
951(1)
Manage Common and Local Users
951(1)
Manage Common and Local Privileges
951(1)
Manage Common and Local Roles
952(1)
Enable Common Users to Access Data in Specific PDBs
952(1)
Perform Backups of a CDB and PDBs
952(1)
Recover PDB from PDB Datafiles Loss
952(1)
Use Data Recovery Advisor
953(1)
Duplicate PDBs Using RMAN
953(1)
Monitor Operations and Performance in a CDB and PDBs
953(1)
Manage Allocation of Resources Between PDBs and Within a PDB
954(1)
Perform Database Replay
954(1)
Self Test
955(3)
Self Test Answers
958(3)
Appendix About the CD-ROM 961(4)
System Requirements
962(1)
Total Tester Premium Practice Exam Software
962(1)
Installing and Running Total Tester Premium Practice Exam Software
962(1)
PDF Copy of the Book
962(1)
Technical Support
963(2)
McGraw-Hill Education Content Support
963(1)
Total Seminars Technical Support
963(2)
Glossary 965(18)
Index 983
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.





Roopesh Ramklass  is an Oracle Certified Master with expertise in middleware and database architecture. He has worked for Oracle Global Support, Advanced Customer Services, and Oracle University. He is actively involved in the Oracle community, speaking at Oracle conferences, serving as an executive of the Toronto Oracle Users Group, and participating in the Oracle ACE program. Roopesh is the author of several Oracle technology books and blogs and is passionate about serving others through education.





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.