- ホーム
- > 洋書
- > 英文書
- > Computer / General
Full Description
Meet your certification guide on the journey to Oracle DBA The Oracle DBA Certification track now consists of three levels Associate (OCA), Professional (OCP), and Master (OCM). This valuable kit helps you attain success at each level, providing clarification of the complex material along with plenty of practice that covers all exam objectives. OCP Oracle Certified Professional on Oracle 12c Certification Kit is the ideal tool for preparing for the OCA and OCP exams. With two comprehensive study guides in one package, this kit serves as a helpful companion throughout your journey to Oracle DBA certification. The OCA study guide is designed for those with some Oracle experience and a background in operational management and maintenance, covering one hundred percent of the material on exams 1Z0-061 and 1Z0-062. Once you're OCA certified, the OCP guide prepares you for exam 1Z0-063 by drawing on your experience with backup, recovery, and cloud computing to master database architecture, RMAN, multitenant architecture, and more.Along the way, you'll have access to robust study tools including review questions, bonus practice exam questions, electronic flashcards, and an appendix of additional lab exercises that give you hands-on experience in preparation for exam day. * Review data handling and the creation/maintenance of Oracle databases * Understand database architecture and the functionality of ASM * Configure projects for recoverability and backup with RMAN * Learn efficient space management, multitenant architecture, and more The addition of multitenancy to Oracle 12c makes an up-to-date study guide crucial for thorough preparation. You must be able to demonstrate your expertise in all aspects of the Oracle environment within a limited time frame, so studying early and often is the surest route to success. If you're ready to tackle these challenging exams, OCP Oracle Certified Professional on Oracle 12c Certification Kit can give you the confidence you need.
Contents
OCAExams 1Z0-061 and 1Z0-062Introduction xxAssessment Test xxxvPart I Oracle Database 12c: SQL Fundamentals 1Chapter 1 Introducing Oracle Database 12c RDBMS 3Relational Database Management Systems 4Characteristics of a Relational Database 5Oracle's Implementation of RDBMS and ORDBMS 8The Oracle Database 12c 9Oracle Database 12c Implementations 9Connecting to Oracle Database 13Database Management Tools 14Oracle Database 12c in the Cloud 19Familiarizing SQL*Plus 19Summary 30Exam Essentials 31Review Questions 32Chapter 2 Introducing SQL 35SQL Fundamentals 36Oracle Datatypes 38Operators and Literals 42Writing Simple Queries 46Using the SELECT Statement 46Filtering Rows 51Sorting Rows 62Sorting NULLs 64Limiting Rows 67Using Expressions 68Accepting Values at Runtime 72Using Ampersand Substitution Variables 73Saving a Variable for a Session 75Using Positional Notation for Variables 77Summary 78Exam Essentials 78Review Questions 80Chapter 3 Using Single-Row Functions 89Single-Row Function Fundamentals 90Functions for NULL Handling 91Using Single-Row Character Functions 95Character Function Overview 95Character Function Descriptions 96Using Single-Row Numeric Functions 108Numeric Function Overview 108Numeric Function Descriptions 109Using Single-Row Date Functions 119Date Format Conversion 119Date Function Overview 120Date Function Descriptions 121Using Single-Row Conversion Functions 131Conversion Function Overview 131Conversion Function Descriptions 133Using Other Single-Row Functions 154Miscellaneous Function Overview 154Miscellaneous Function Descriptions 155Summary 167Exam Essentials 168Review Questions 169Chapter 4 Using Group Functions 175Group Function Fundamentals 176Utilizing Aggregate Functions 177Grouping Data with GROUP BY 178Group Function Overview 182Group Function Descriptions: Part 1 184Group Function Descriptions: Part 2 194Limiting Grouped Data with HAVING 207Creating Superaggregates with CUBE and ROLLUP 208Nesting Functions 215Summary 218Exam Essentials 218Review Questions 219Chapter 5 Using Joins and Subqueries 227Writing Multiple-Table Queries 228Inner Joins 229Cartesian Joins 239Outer Joins 240Other Multiple-Table Queries 245Using Set Operators 247The UNION Operator 248The UNION ALL Operator 249The INTERSECT Operator 250The MINUS Operator 250Putting It All Together 250Using Subqueries 252Single-Row Subqueries 253Multiple-Row Subqueries 254Subquery Returns No Rows 256Correlated Subqueries 258Scalar Subqueries 259Multiple-Column Subqueries 267Subqueries in Other DML Statements 268Summary 269Exam Essentials 270Review Questions 271Chapter 6 Manipulating Data 281Using DML Statements 282Inserting Rows into a Table 283Updating Rows in a Table 289Deleting Rows from a Table 294Merging Rows 297Understanding Transaction Control 299Savepoints and Partial Rollbacks 302Data Visibility 304Summary 306Exam Essentials 307Review Questions 308Chapter 7 Creating Tables and Constraints 319Database Objects Overview 320Schema Objects 322Using Sequences 324Built-in Datatypes 325Character Datatypes 325Numeric Datatypes 329Date and Time Datatypes 330Date Arithmetic 334Binary Datatypes 336Row ID Datatypes 337Creating Tables 338Naming Tables and Columns 339Specifying Default Values for Columns 341Adding Comments 348Creating a Table from Another Table 348Modifying Tables 350Adding Columns 350Modifying Columns 353Renaming Columns 354Dropping Columns 354Hiding Columns from Table 356Dropping Tables 357Renaming Tables 357Making Tables Read-Only 358Managing Constraints 361Creating Constraints 362Dropping Constraints 367Enabling and Disabling Constraints 367Deferring Constraint Checks 369Summary 373Exam Essentials 374Review Questions 375Part II Oracle Database 12c: Installation and Administration 381Chapter 8 Introducing Oracle Database 12c Components and Architecture 383Oracle Database Fundamentals 385Relational Databases 385Oracle Database 12c Objects 386Interacting with Oracle Database 12c 388Oracle Database 12c Architecture 391User and Server Processes 394The Oracle Instance 396Oracle Storage Structures 410Summary 424Exam Essentials 425Review Questions 426Chapter 9 Creating and Operating Oracle Database 12c 431Oracle Database 12c Software Installation 432Planning the Oracle Database 12c Software Install 433Using the Oracle Universal Installer 440Using DBCA to Create an Oracle 12c Database 447Invoking the Database Configuration Assistant 447Configuring an Oracle Database Using the DBCA 472Deleting an Oracle Database Using the DBCA 472Managing Database Templates Using the DBCA 473Working with Oracle Database Metadata 475Data Dictionary Views 476Dynamic Performance Views 477Managing Initialization-Parameter Files 479Locating the Default Parameter File 484Modifying Initialization-Parameter Values 485Starting Up and Shutting Down an Oracle Instance 490Starting Up an Oracle Database 12c Instance 491Shutting Down an Oracle Database 12c Instance 495Monitoring the Database Alert Log 497Summary 503Exam Essentials 504Review Questions 506Chapter 10 Understanding Storage and Space Management 511Understanding the Physical and Logical Storage 512Contents of a Data Block 514Managing Tablespaces 516Identifying Default Tablespaces 516Creating and Maintaining Tablespaces 516Obtaining Tablespace Information 531Managing Data Files 534Performing Operations on Data Files 535Using the Oracle Managed Files Feature 539Querying Data File Information 544Managing Space 547Automatic Space Management Features 547Monitoring Tablespace Free Space 551Using Segment Advisor 554Avoiding Out-of-Space Errors 559Summary 562Exam Essentials 563Review Questions 565Chapter 11 Managing Data Concurrency and Undo 569Managing Data Changes Using DML 570Understanding "Change" 571Differentiating Undo and Redo 572Configuring and Monitoring Undo 576Managing Data Concurrency 584Understanding Locks and Transactions 585Maximizing Data Concurrency 587Detecting and Resolving Lock Conflicts 590Summary 595Exam Essentials 595Review Questions 597Chapter 12 Understanding Oracle Network Architecture 603Introducing Network Configurations 604Single-Tier Architecture 605Two-Tier Architecture 605n-Tier Architecture 606An Overview of Oracle Net Features 607Connectivity 608Manageability 608Scalability 609Security 611Accessibility 613Configuring Oracle Net on the Server 613Understanding the Oracle Listener 614Managing Oracle Listeners 618Dynamically Registering Services 634Oracle Net Logging and Tracing on the Server 635Configuring Oracle Net for the Client 637Client-Side Names Resolution Options 637The Host Naming Method 638The Oracle Easy Connect Method 639The Local Naming Method 641Troubleshooting Client-Side Connection Problems 646An Overview of Oracle Shared Server 648Dedicated Server vs. Shared Server 648Advantages and Disadvantages of Shared Server 650Oracle Shared Server Infrastructure 651Configuring the Oracle Shared Server 653Managing a Shared Server 658Understanding Database Resident Connection Pooling 661Configuring DRCP 662Comparing Connection Architectures 663Communicating Between Databases 666Introduction to Database Links 666Creating Database Links 667Summary 669Exam Essentials 670Review Questions 672Chapter 13 Implementing Security and Auditing 677Creating and Managing User Accounts 678Configuring Authentication 679Assigning Tablespaces and Quotas 681Assigning a Profile and Account Settings 684Contents xvRemoving a User from the Database 686Managing Default User Accounts 687Granting and Revoking Privileges 687Granting Object Privileges 688Granting System Privileges 692Role Privileges 701Applying the Principle of Least Privilege 705Controlling Resource Usage by Users 711Implementing Password Security Features 714Auditing Database Activity 718Managing Statement Auditing 720Managing Privilege Auditing 724Managing Object Auditing 725Using SQL Developer for Audit Management 727Purging the Audit Trail 729Managing Fine-Grained Auditing 732Implementing Unified Auditing 735Summary 745Exam Essentials 746Review Questions 747Chapter 14 Maintaining the Database andManaging Performance 753Proactive Database Maintenance 754Managing Optimizer Statistics 755Gathering Performance Statistics 775Automatic Database Diagnostic Monitoring 782The Advisory Framework 793Monitoring Server-Generated Alerts 798Understanding Automatic Diagnostic Repository 801Managing Performance 806Sources of Tuning Information 807Tuning Memory 812Automatic Shared Memory Management 813Automatic SQL Execution Memory Management 815Managing Memory Using EM Cloud Control 817Summary 819Exam Essentials 820Review Questions 821Chapter 15 Using Backup and Recovery 825Understanding and Configuring Recovery Components 827Understanding Control Files 827Understanding Checkpoints 831Understanding Redo Log Files 832Understanding Archived Redo Log (ARCHIVELOG) Files 839Understanding the Fast Recovery Area 844Performing Backups 848Understanding Backup Terminology 848Backing Up the Control File 850Backing Up the Database 851Using RMAN to Perform Backups 852Managing Backups 861Understanding Types of Database Failures 864Statement Failures 865User-Process Failures 865Network Failures 866User-Error Failures 866Instance Failures 867Media Failures 868Performing Recovery Operations 868Understanding Instance Startup 868Keeping an Instance from Failing 870Recovering from Instance Failure 870Tuning Instance Recovery 871Recovering from User Errors 873Recovering from the Loss of a Control File 881Using the Data Recovery Advisor 883Recovering from the Loss of a Redo Log File 884Recovering from the Loss of a Non-System-CriticalData File 886Recovering from the Loss of a System-Critical Data File 892Table Recovery Using RMAN 893Summary 894Exam Essentials 895Review Questions 897Chapter 16 Controlling Resources and Jobs 903Resource Management with the Resource Manager 904Functions of the Resource Manager 904Understanding Resource Manager Components 905Configuring the Database Resource Manager 911Accessing and Creating Resource Plans 916Updating and Deleting Resources 924Monitoring the Resource Manager 927Task Automation with Oracle Scheduler 930Scheduler Architecture 930Using Oracle Scheduler 934Contents xviiRelating Tasks with Job Chains 943Scheduling Jobs on Remote Systems 947Prioritizing Jobs with Oracle Scheduler 948Summary 951Exam Essentials 951Review Questions 952Chapter 17 Upgrading to Oracle Database 12c 957Determining the Database Upgrade Method 958Using Direct Upgrade 959Migrating to Oracle Database 12c 961Preparing for a Database Upgrade 963Running the Pre-Upgrade Information Tool 964Preparing the Oracle Home 974Reducing Upgrade Downtime 975Upgrading the Database 976Using Database Upgrade Assistant 976Performing a Manual Upgrade 987Completing the Post-Upgrade Tasks 991Migrating to Unified Auditing 994Downgrading to an Earlier Release 995Summary 997Exam Essentials 997Review Questions 999Chapter 18 Using Grid Infrastructure and Data Movement Tools 1005Tools for Moving Data 1006Migrating Data Using Data Pump 1008Data Pump Architecture 1009Using Data Pump Clients 1012Using the Data Pump Wizard 1033Upgrading an 11g R2 Database to 12cUsing Full Transportable Export 1037Loading Data with SQL*Loader 1039Specifying SQL*Loader Command-Line Parameters 1040Specifying Control File Options 1042Populating External Tables 1046Loading External Tables Using Data Pump 1046Loading External Tables Using Loader 1048Introducing Grid Infrastructure 1050Installing Oracle Grid Infrastructure 1051Managing Oracle ASM Storage 1061Using Oracle Restart 1068Summary 1076Exam Essentials 1077Review Questions 1078Appendix A Answers to Review Questions 1083Chapter 1: Introducing Oracle Database 12c RDBMS 1084Chapter 2: Introducing SQL 1085Chapter 3: Using Single-Row Functions 1087Chapter 4: Using Group Functions 1089Chapter 5: Using Joins and Subqueries 1090Chapter 6: Manipulating Data 1092Chapter 7: Creating Tables and Constraints 1094Chapter 8: Introducing Oracle Database 12c Componentsand Architecture 1096Chapter 9: Creating and Operating Oracle Database 12c 1098Chapter 10: Understanding Storage and Space Management 1100Chapter 11: Managing Data Concurrency and Undo 1102Chapter 12: Understanding Oracle Network Architecture 1104Chapter 13: Implementing Security and Auditing 1106Chapter 14: Maintaining the Database andManaging Performance 1108Chapter 15: Using Backup and Recovery 1110Chapter 16: Controlling Resources and Jobs 1112Chapter 17: Upgrading to Oracle Database 12c 1114Chapter 18: Using Grid Infrastructure andData Movement Tools 1116Appendix B About the Additional Study Tools 1119Additional Study Tools 1120Sybex Test Engine 1120Electronic Flashcards 1120Bonus Author Materials 1120PDF of Glossary of Terms 1120Adobe Reader 1121System Requirements 1121Using the Study Tools 1121Troubleshooting 1121Customer Care 1122Index 1123OCP: Oracle Database 12c Administrator Certified Professional Study Guide: Exam 1Z0-063Introduction xxiAssessment Test xxxiiiChapter 1 Performing Oracle User-Managed Backups 1Oracle Database Data Protection Options 2What Kind of Failures Can Happen to a Database 2Physical and Logical Backups 3Tools for Backup and Recovery 3Oracle MAA Recommendations 4Understanding the Oracle Database as It Relates to Backup and Recovery 5Oracle Processes Related to Backup and Recovery 6Oracle Memory Structures Related to Backup and Recovery 8The Oracle Data Dictionary 8Oracle Data Files and Tablespaces 11Redo Logs 12Control File 14Parameter Files 15NOARCHIVELOG and ARCHIVELOG Modes 17The Oracle Instance and the Oracle Database 18Configuring the Database for Backup and Recovery 26Configuring for ARCHIVELOG Mode 26Putting the Database in ARCHIVELOG Mode 29Using ARCHIVELOG Mode Data Dictionary Views 33Performing Oracle Offline Backups 36Performing Oracle Online Backups 40The Mechanics of Online Backups 40Backing Up the Control File 46Creating a Backup Control File 46Creating a Trace File with the Create CONTROLFILE Command in It 47Summary 49Exam Essentials 50Review Questions 51Chapter 2 Performing Oracle User-Managed Database Recoveries 57Performing a Recovery in NOARCHIVELOG Mode 58Performing a Full Database Recovery in ARCHIVELOG Mode 62Preparing for the Recovery 62Recovering the Database 64Performing User-Based Incomplete Recoveries 77Requirements for and Mechanics of an Incomplete Recovery 77Preparing for an Incomplete Recovery 77Performing an Incomplete Recovery 79Performing Other Types of Recoveries 85Recovering from the Loss of a Tempfile 85Recovering from the Loss of an Online Redo Log Group 85Recovering from the Loss of a Control File 89Recovering from the Loss of the Password File 93Recovering from the Loss of Everything 93Summary 94Exam Essentials 95Review Questions 96Chapter 3 Configuring and Backing Up Oracle Databases Using RMAN 105Why Use RMAN? 107Exploring the RMAN Architecture 108Getting Started with RMAN 110Starting the RMAN Interface 110The SYSBACKUP Privilege 111The RMAN Command Line 113The RMAN Command Prompt 114Calling SQL from the RMAN Command Prompt 114Configuring RMAN 115The Fast Recovery Area 116RMAN Persistent Configuration Settings 119Unique RMAN Configuration Settings 120Preparing RMAN for Use 121Backing Up Your Database with RMAN 136Using the RMAN Command Line 136Types of RMAN Backups 141RMAN Offline Backups 145RMAN Online Backups 145RMAN Incremental Backups 151RMAN Incrementally Updated Backups 154RMAN Multisection Backups 155RMAN Backup of Archived Redo Logs 156RMAN Backup of the Spfile and Control Files 157Backing Up RMAN Backup Sets 158Backing Up the RMAN FRA 158Creating Archival Backups 159Summary 159Exam Essentials 160Review Questions 161Chapter 4 Using the RMAN Recovery Catalog 167Introducing the Recovery Catalog 168Creating the Recovery Catalog User and Schema Objects 170Using a Recovery Catalog 172Connecting to the Recovery Catalog from RMAN 173Registering the Target Database with the Recovery Catalog 174Unregistering a Database 174Using Scripts in the RMAN Recovery Catalog 175Executing External Scripts 175Creating Stored Scripts 176Using Script Substitution Variables 177Maintaining the Recovery Catalog 177Dropping the Recovery Catalog 178Upgrading the Recovery Catalog 178Synchronizing the Recovery Catalog 178Export and Import the Recovery Catalog 178Backing Up the Recovery Catalog 179Recreating an Unrecoverable Recovery Catalog 179Using the RMAN Virtual Private Catalog 181Creating the RMAN Virtual Private Catalog 181Administering the RMAN Virtual Private Catalog 182Summary 183Exam Essentials 183Review Questions 185Chapter 5 Recovering Databases with RMAN 189RMAN Database-Recovery Basics 191Recovering a Database in NOARCHIVELOG Mode 192Recovering a Database in ARCHIVELOG Mode 194Complete Database Recovery in ARCHIVELOG Mode 195Data File or Tablespace Recovery in ARCHIVELOG Mode 200Recovering a Database Using Incomplete Recovery 209Types of Point-in-Time Recovery 209Point-in-Time Recovery Mechanics 214Using Image Copies to Recover Your Database 217Other Basic Recovery Topics 218Block Media Recovery 218Recovering the Control File 219Recovering the Spfile 224Recovering the Database Password File 229Clearing Redo Logs 229Summary 230Exam Essentials 230Review Questions 232Chapter 6 Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow 239Overview of the RMAN Report and List Commands 240Using the RMAN REPORT Command 240Using the RMAN LIST Command 247Monitoring, Administering, and Tuning RMAN 256Monitoring RMAN Operations 257Administering RMAN Operations 260Tuning RMAN Operations 263The Oracle Database Fault Diagnostic Framework 264Overview of the Oracle Database FaultDiagnostic Framework 265The Oracle ADR 267Problems and Incidents 269The Automatic Diagnostic Workflow-Managing Problems and Incidents 270Components Related to the Fault Diagnosability Framework 271Enterprise Manager Support Workbench 272The ADRCI Command-Line Utility 273Summary 275Exam Essentials 275Review Questions 277Chapter 7 Performing Oracle Advanced Recovery 283Switching between RMAN Incarnations 285Overview of RMAN Database Duplication 287RMAN Database Duplication Basics 287Performing an RMAN Database Duplication 289Performing an RMAN Tablespace Point-in-Time Recovery 299TSPITR Overview 300Checking the Transport Set 302Lost Objects 303Rules, Rules, and More Rules 304TSPITR Aftereffects 304Restoring a Database to a New Host 308Using RMAN to Move a Database 308Oracle Data Pump, Oracle GoldenGate and Oracle Data Guard 310Complete Disaster 310Backup Best Practices for Data Warehouses 311The First Execution of the Command 312The Second Execution of the Command 313The Third Execution of the Command 313Restoring from Incrementally Updated Backups 315Performing Table and Partition Recovery from Backups 315Things to Check Before Trying to Restore and Recover Database Tables and Partitions 316Restrictions When Restoring and Recovering Database Tables and Partitions 317Options to Consider When Performing Table or Table Partition Restores 317An Example of Using RMAN to Restore and Recover a Database Table 318ASM-Related Backups 320Quick ASM Overview 321ASM Diskgroup Metadata Backups 321Restoring ASM Disk Groups 323Configuring and Using Oracle Secure Backup 323What Is OSB? 324How Does OSB Interface with RMAN? 325The OSB Architecture 325Installing and Configuring OSB 327Oracle Database 12c Multitenant Architecture and RMAN 329Architecture Overview 329Backing Up CDBs with RMAN 330Backing Up PDBs with RMAN 331Recovering CDBs and PDBs with RMAN 332Duplicating a PDB with RMAN 333Oracle Data Pump and Oracle Multitenant 334The Data Recovery Advisor 335Summary 339Exam Essentials 340Review Questions 341Chapter 8 Understanding Flashback Technology 349Describe the Flashback Technologies 351Managing Undo Automatically 352Uncovering Undo 352Working with Automatic Undo Management 354Preserving Data with Undo Retention 355Employing Flashback Technologies 357Recovering Tables and Objects with Flashback Drop and the Recycle Bin 357Use Flashback to Query Data 368Recovering Data with Flashback Version Query 373Detecting Changes with Flashback Transaction Query 376Perform Flashback Table Operations 379Describe and Use Flashback Data Archive 383Perform Flashback Database Operations 385Summary 390Exam Essentials 391Review Questions 392Chapter 9 Diagnosing the Database and Managing Performance 399Diagnosing Failures 400Setting Up the Automatic Diagnostic Repository 400Using the Support Workbench 404Performing Block Media Recovery 414Managing Database Performance 416Using the SQL Tuning Advisor 417Using the SQL Access Advisor to Tune a Workload 424Perform Database Replay 430Summary 448Exam Essentials 449Review Questions 450Chapter 10 Managing Database Resources 455Managing Storage 456Managing Resumable Space Allocation 456Managing Transportable Tablespaces 466Managing Transportable Databases 479Shrinking Segments 486Managing Storage in a CDB and PDBs 494Manage Permanent and Temporary Tablespaces in CDB and PDBs 495Summary 497Exam Essentials 497Review Questions 498Chapter 11 Creating Oracle Multitenant Databases 503Multitenant Container and Pluggable Database Architecture 504Describing the Multitenant Architecture 504Explaining Pluggable Database Provisioning 507Creating Multitenant Container Databases and Pluggable Databases 508Creating and Configuring a CDB 508Creating a PDB Using Different Methods 517Unplugging and Dropping a PDB 534Migrating a Pre-12.1 Non-CDB Database to a CDB 542Summary 544Exam Essentials 544Review Questions 545Chapter 12 Managing Oracle Multitenant Databases 551Establishing Connections to CDB/PDB 552User Accounts in a CDB 553Establishing Connections to a CDB 554Establishing Connections to a PDB 558Start Up and Shut Down a CDB and Open and Close PDBs 564Starting Up the CDB Using SQL*Plus 564Shutting Down the CDB 567Opening a PDB 570Shutting Down or Closing a PDB 572Evaluate the Impact of Parameter Value Changes 574AUDIT_FILE_DEST 574AUDIT_SYS_OPERATIONS 575AUDIT_SYSLOG_LEVEL 575AUDIT_TRAIL 575ENABLE_PLUGGABLE_DATABASE 576LDAP_DIRECTORY_ACCESS 576MAX_STRING_SIZE 576NONCDB_COMPATIBLE 576PDB_FILE_NAME_CONVERT 577RESOURCE_MANAGER_PLAN 577SESSIONS 577Summary 578Exam Essentials 578Review Questions 580Chapter 13 Oracle Utilities 585Moving Data, Performing Security Operations, and Interacting with Other Oracle Products 586Using Data Pump 587Understanding and Using SQL*Loader 595Audit Operations 603Using Other Products with CDBs and PDBs-Database Vault, Data Guard, LogMiner 606Summary 616Exam Essentials 616Review Questions 618Chapter 14 Oracle Security in CDBs and PDBs 623Managing Security in a CDB and PDBs 624Managing Common and Local Users 625Managing Common and Local Privileges 636Managing Common and Local Roles 642Enabling Common Users to Access Data in Specific PDBs 648Summary 653Exam Essentials 654Review Questions 655Appendix A Answers to Review Questions 661Chapter 1: Performing Oracle User-Managed Backups 662Chapter 2: Performing Oracle User-Managed Database Recoveries 664Chapter 3: Configuring and Backing Up Oracle Databases Using RMAN 666Chapter 4: Using the RMAN Recovery Catalog 668Chapter 5: Recovering Databases with RMAN 669Chapter 6: Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow 671Chapter 7: Performing Oracle Advanced Recovery 672Chapter 8: Understanding Flashback Technology 674Chapter 9: Diagnosing the Database and Managing Performance 676Chapter 10: Managing Database Resources 678Chapter 11: Creating Oracle Multitenant Databases 680Chapter 12: Managing Oracle Multitenant Databases 681Chapter 13: Oracle Utilities 682Chapter 14: Oracle Security in CDBs and PDBs 684Appendix B About the Additional Study Tools 687Additional Study Tools 688Sybex Test Engine 688Electronic Flashcards 688Bonus Lab Exercises 688Glossary 688Adobe Reader 689System Requirements 689Using the Study Tools 689Troubleshooting 689Customer Care 690Index 691
