Muutke küpsiste eelistusi

OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060) 2nd edition [Pehme köide]

4.09/5 (16 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 528 pages, kõrgus x laius x paksus: 231x188x25 mm, kaal: 848 g, 256 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Aug-2013
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071819975
  • ISBN-13: 9780071819978
Teised raamatud teemal:
  • Pehme köide
  • Hind: 85,59 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060) 2nd editionSuurem pilt
  • Formaat: Paperback / softback, 528 pages, kõrgus x laius x paksus: 231x188x25 mm, kaal: 848 g, 256 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Aug-2013
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071819975
  • ISBN-13: 9780071819978
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780071819978.html
Märksõnad:
"A Fully Integrated Study System for OCP Exam 1Z0-060 Prepare for the Oracle Certified Professional Upgrade to Oracle Database 12c exam with this exclusive Oracle Press guide. Each chapter features step-by-step examples, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of the new features of Oracle Database 12c, including: Oracle Enterprise Manager Database Express and additional tools for database monitoring Multitenant container databases and pluggable databases Auditing, administrative privileges, data redaction, and other Oracle security features Adaptive execution plans, adaptive statistics, and automatic SQL plan management Oracle Recovery Manager backup and recovery improvements Oracle Database Resource Manager and other performance enhancements Oracle Data Pump, SQL*Loader, external tables, and online operations enhancements Improvements to information lifecycle management and storage, including automatic data optimization, in-database archiving, and temporal validity Electronic content includes: 170 practice exam questions with detailed answer explanations PDF copy of the book "--

"Prepare for the Oracle Certified Professional Upgrade to Oracle Database 12c exam with this exclusive Oracle Press guide. Each chapter features step-by-step examples, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference"--

A Fully Integrated Study System for OCP Exam 1Z0-060

Prepare for the Oracle Certified Professional Upgrade to Oracle Database 12c exam with this exclusive Oracle Press guide. Each chapter features step-by-step examples, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of the new features of Oracle Database 12c, including:

  • Oracle Enterprise Manager Database Express and additional tools for database monitoring
  • Multitenant container databases and pluggable databases
  • Auditing, administrative privileges, data redaction, and other Oracle security features
  • Adaptive execution plans, adaptive statistics, and automatic SQL plan management
  • Oracle Recovery Manager backup and recovery improvements
  • Oracle Database Resource Manager and other performanceenhancements
  • Oracle Data Pump, SQL*Loader, external tables, and online operations enhancements
  • Improvements to information lifecycle management and storage, including automatic data optimization, in-database archiving, and temporal validity

Electronic content includes:

  • 170 practice exam questions with detailed answer explanations
  • PDF copy of the book

Acknowledgments xv
Preface xvii
Introduction xix
1 Enterprise Manager and Database Monitoring 1(44)
Use Oracle Enterprise Manager Express, OUI, and DBCA (Exam Objective 1.01)
3(5)
EM Database Express
3(5)
Database Configuration Assistant: New Features Oracle SQL*Developer Enhancements
8(1)
Implement Real-Time Database Operation Monitoring (Exam Objective 1.02)
8(9)
Definition of a Database Operation
9(1)
How Real-Time Database Monitoring Helps You
10(1)
Identifying a Database Operation
10(1)
Enabling Database Operation Monitoring
11(2)
A Database Operation Monitoring Example
13(1)
Monitoring Load Database Operations
14(1)
Monitoring the Progress of a Database Operation
14(3)
Perform Emergency Monitoring and Real-Time ADDM (Exam Objective 1.03)
17(7)
Emergency Monitoring
17(2)
Real-Time ADDM
19(1)
Real-Time Connection Modes
20(1)
Real-Time ADDM Triggers
20(1)
Producing a Real-Time ADDM Report
21(1)
Combining Emergency Monitoring and Real-Time ADDM
22(1)
Generate a Compare Period ADDM Report (Exam Objective 1.04)
23(1)
How Compare Periods ADDM Helps
23(1)
Generating a Compare Period ADDM Report
24(2)
Understand ASH, ADR, and Network Enhancements (Exam Objective 1.05)
26(6)
Diagnosing Performance Issues Using Active Session History (ASH) Analytics
27(1)
ADR Enhancements
27(1)
The DDL Log
27(2)
The Debug Log
29(1)
Network-Related Enhancements
30(2)
Two-Minute Drill
32(3)
Self Test
35(5)
Self Test Answers
40(5)
2 Multitenant Databases-Architecture and Configuration 45(44)
Identify the Benefits of the Multitenant Container Database (Exam Objective 2.01)
46(2)
Configuration Options in Oracle Database 12c
47(1)
Explain Root and Multitenant Architecture (Exam Objective 2.02)
48(8)
Managing a CDB
50(1)
Organization of the Instance and Storage
50(3)
Types of Containers
53(1)
Local and Common Users
54(1)
Local and Common Roles and Privileges
55(1)
Shared and Non-Shared Objects
55(1)
Create and Configure CDBs and PDBs (Exam Objective 2.03)
56(20)
Creating a CDB
56(9)
Configuring EM Express in a CDB
65(1)
Creating and Configuring a PDB
65(10)
Dropping a Pluggable Database
75(1)
Migrate a Non-CDB to a PDB Database (Exam Objective 2.04)
76(4)
Migrating the Non-CDB Using the DBMS_PDB Package
77(1)
Plugging a Non-CDB into a CDB Using Data Pump
78(1)
Using Golden Gate Replication to Plug a Non-CDB into a PDB
78(2)
Two-Minute Drill
80(2)
Self Test
82(4)
Self Test Answers
86(3)
3 Managing CDBs and PDBs 89(58)
Establish a Connection to a CDB/PDB (Exam Objective 3.01)
90(8)
The Current Container
91(1)
Common Users and Administrative Tasks
92(1)
Connecting to the Root Container
93(2)
Connecting to a PDB
95(2)
Switching to a Container
97(1)
Start Up and Shut Down a CDB/PDB (Exam Objective 3.02)
98(9)
Starting a CDB
98(3)
PDB Modes and How to Alter Them
101(2)
Shutting Down a CDB
103(1)
Opening and Closing PDBs
104(3)
Change Instance Parameters for a CDB/PDB (Exam Objective 3.03)
107(14)
Modifying a PDB when Connected to the PDB
110(2)
Manageability Features in a CDB
112(1)
Managing Database Objects in a CDB
112(1)
Viewing Information About CDBs and PDBs
112(3)
How to Enable a Common User to Access Data in a Specific PDB
115(1)
Using Views for Monitoring CDBs and PDBs
115(2)
Querying Container Data Objects
117(4)
Manage Tablespaces in a CDB/PDB (Exam Objective 3.04)
121(3)
Creating Tablespaces
122(1)
Setting the Default Tablespace
123(1)
Managing Temporary Tablespaces
123(1)
Modifying a PDB's Settings
124(1)
Manage Users and Privileges for CDB/PDB (Exam Objective 3.05)
124(10)
Managing Users
124(3)
Managing Privileges
127(3)
Managing Roles
130(4)
Two-Minute Drill
134(3)
Self Test
137(5)
Self Test Answers
142(5)
4 Security New Features 147(60)
Enable and Configure the Unified Audit Data Trail (Exam Objective 4.01)
149(6)
How the New Auditing Architecture Works
150(5)
Create and Enable Audit Policies (Exam Objective 4.02)
155(12)
Implementing Unified Audit
155(4)
Creating Audit Policies
159(5)
Enabling, Disabling, Altering, and Dropping Audit Policies
164(2)
Capturing Application Context Data
166(1)
Viewing Audit Policies
167(1)
Use Task-Specific Administrative Privileges (Exam Objective 4.03)
167(6)
SYSBACKUP Privilege
168(1)
SYSDG Privilege
169(1)
SYSKM Privilege
169(1)
New Operating System Groups
170(1)
Support for the New Admin Privileges in the Password File
171(2)
Create, Enable, and Use Privilege Analysis (Exam Objective 4.04)
173(8)
Setting the Privilege Analysis Type
174(1)
Creating the Privilege Analysis Policy
174(4)
Starting the Privilege Analysis
178(2)
Privilege Checking During PL/SQL Calls
180(1)
Use and Manage Oracle Data Redaction Policies (Exam Objective 4.05)
181(14)
Activities Exempt from Data Redaction
183(1)
Types of Data Reduction
183(3)
Defining Redaction Policies
186(1)
Restrictions on Data Redaction
187(1)
Adding a Redaction Policy to a Table or View
187(4)
Modifying a Redaction Policy
191(1)
How to Exempt Users
192(1)
Enabling and Disabling Data Redaction Policies
192(3)
Two-Minute Drill
195(3)
Self Test
198(5)
Self Test Answers
203(4)
5 Performance Tuning Enhancements 207(40)
Use Adaptive Execution Plans (Exam Objective 5.01)
208(18)
Adaptive Query Optimization
209(5)
Adaptive Statistics
214(2)
Automatic Reoptimization
216(5)
SQL Plan Directives
221(4)
Managing SQL Plan Directives
225(1)
Use Enhanced Features of Statistics Gathering (Exam Objective 5.02)
226(8)
Online Statics Gathering for Bulk-Load
226(1)
Better Concurrent Statistics Gathering
227(4)
Enhanced Histograms
231(1)
Collecting Better Extended Statics
232(2)
Use Adaptive SQL Plan Management (Exam Objective 5.03)
234(5)
SQL Plan Management
234(2)
Automatic SPM
236(1)
New Functions in the DBMS_SPM Package
236(1)
Configuring the Automatic SPM Evolve Advisor Task
237(2)
Two-Minute Drill
239(2)
Self Test
241(3)
Self Test Answers
244(3)
6 Administration and Management New Features 247(46)
Use Resource Manager for a CDB and a PDB (Exam Objective 6.01)
249(9)
Managing Resources Between PDBs
249(1)
CDB Resource Plans and Shares
250(1)
CDB Resource Plans and Utilization Limits
251(1)
Creating a CDB Resource Plan
252(3)
Managing Resources Within a PDB
255(3)
Multiprocess Multithreaded Architecture and Using Flash Cache (Exam Objective 6.02)
258(6)
Multiprocess Multithreaded Unix/Linux Architecture
259(2)
Database Smart Flash Cache
261(2)
In-memory Parallel Query (PQ) Algorithm
263(1)
Index and Table Enhancements (Exam Objectives 6.04 and 6.05)
264(4)
Table Enhancements
264(3)
Multiple Indexes on the Same Set of Columns
267(1)
Online Operation Enhancements (Exam Objective 6.06)
268(4)
Online Redefinition of Tables with VPD
268(2)
New Online DDL Capabilities
270(2)
SQL Enhancements
272(8)
Extended Character Data Type Columns
272(2)
Using the Database Migration Assistant for Unicode
274(1)
SecureFiles as Default Storage for Large Objects
274(1)
SQL Row-Limiting Clause
275(3)
Advanced Row Compression
278(2)
Two-Minute Drill
280(3)
Self Test
283(6)
Self Test Answers
289(4)
7 RMAN Backup and Recovery New Features 293(56)
Back Up and Recover PDBs and CDBs (Exam Objective 7.01)
294(17)
Performing Backups
295(6)
Performing a Recovery with RMAN
301(10)
Perform Flashback for a CDB (Exam Objective 7.02)
311(4)
Flashing Back a CDB: An Example
311(2)
Flashing Back a CDB After a PDB Was Recovered with DBPITR
313(2)
RMAN Enhancements (Exam Objective 7.03)
315(18)
New SYBACKUP Administrative Privilege
315(1)
Using SQL in RMAN
316(1)
Multisection Backups of Image Copies
317(1)
RMAN Duplication Enhancements
318(5)
Transporting Tablespaces and Databases with Backup Sets
323(8)
Recovering Tables with RMAN's Table Recovery Feature
331(2)
New Features in Flashback Data Archive (Exam Objective 7.04)
333(3)
Flashback Data Archive for Security-Related Application Tables
334(1)
User-Context Tracking
334(1)
Hybrid Columnar Compression (HCC)
334(1)
Import and Export of History
334(1)
Optimizing the FDA History Tables
334(2)
Two-Minute Drill
336(3)
Self Test
339(5)
Self Test Answers
344(5)
8 Storage and Data Loading 349(38)
Oracle Data Pump Enhancements (Exam Objective 8.01)
350(8)
Fully Transportable Export and Import of Data
351(3)
Disabling Logging for Oracle Data Plump Import
354(1)
Exporting Views as Tables
355(1)
Compressing Data During an Import
356(1)
Creating SecureFile LOBs During Import
357(1)
SQL*Loader and External Table Enhancements (Exam Objective 8.02)
358(3)
SQL*Loader Express Mode
358(2)
SQL*Loader Support for Direct-Path Loading of Identity Columns
360(1)
Syntax Enhancements for SQL*Loader and External Tables
361(1)
Partitioning Enhancements (Exam Objective 8.03)
361(8)
Online Partition Operations
362(1)
Reference Partitioning Enhancements
363(2)
Multipartition Maintenance Operations
365(4)
Index Enhancements for Partitioned Tables (Exam Objective 8.04)
369(6)
Partial Indexes for Partitioned Tables
369(3)
Asynchronous Global Index Maintenance
372(1)
New DBMS_PART Package
373(2)
Two-Minute Drill
375(3)
Self Test
378(5)
Self Test Answers
383(4)
9 ILM: Automatic Data Optimization, In-Database Archiving, and Temporal Validity 387(44)
Use ILM Features (Exam Objective 9.01)
388(2)
Perform Tracking and Automated Data Placement (Exam Objective 9.02)
390(20)
Automatic Data Optimization
390(19)
Move a Data File Online
409(1)
Use In-Database Archiving (Exam Objective 9.03)
410(5)
Hybrid Columnar Compression
411(1)
What In-Database Archiving Is
411(4)
ILM and Temporal Validity (Exam Objective 9.04)
415(5)
Defining a Valid-Time Dimension
416(4)
Two-Minute Drill
420(4)
Self Test
424(3)
Self Test Answers
427(4)
A About the CD-ROM 431(4)
System Requirements
432(1)
Installing and Running Total Tester
432(1)
About Total Tester
432(1)
Free PDF Copy of the Book
433(1)
Technical Support
433(2)
Glossary 435(8)
Index 443
Sam R. Alapati is an experienced Oracle DBA who holds the Oracle OCP DBA (11g) certification and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of Americas national office in Irving, Texas. Previously, Sam worked for AMR Holdings (Sabre) and the Blanch Company in Dallas. Sam was a Senior Principal Consultant for Oracle Corporation in New York, in which capacity he worked at NBC and Lehman Brothers. In addition to being a professional Oracle database administrator, Sam has also taught Oracle DBA classes for many students. Sam taught college level courses at Kansas State University, University of Texas at Austin, and Rutgers University.