book

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

Name: OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition
ISBN: 9780071828079

by John Watson, Roopesh Ramklass, Bob Bryla

August 2015

Intermediate to advanced

1072 pages

29h 54m

English

McGraw Hill Computing

Read now

Unlock full access

Cover
Title Page
Copyright Page
Dedication
About the Authors
Contents
Introduction
Part I Getting Started
Chapter 1 Installing Oracle Database Software
Plan for an Oracle Database Software InstallationSupported PlatformsObtain the Oracle Database SoftwareUser AccountsDisk Space and DirectoriesThe Prerequisite ChecksInstall the Oracle Database SoftwareThe OUI InventoryThe OUI Dialog: Interactive InstallSilent Install and Response FilesWindows and Linux VariationsTwo-Minute DrillPlan for an Oracle Database Software InstallationInstall the Oracle Database SoftwareSelf TestSelf Test Answers
Chapter 2 Creating an Oracle Database Using DBCA
Create a Database by Using the Database Configuration AssistantThe Instance, the Database, and the Data DictionaryUsing the Database Configuration Assistant to Create a DatabaseThe DBCA DialogGenerate Database Creation Scripts by Using DBCAGenerating the ScriptsThe Creation ScriptsThe Initialization Parameter FileManage Database Design Templates by Using DBCAConfigure Database Options by Using DBCATwo-Minute DrillCreate a Database by Using the Database Configuration AssistantGenerate Database Creation Scripts by Using DBCAManage Database Design Templates by Using DBCAConfigure Database Options by Using DBCASelf TestSelf Test Answers

Chapter 3 Installing Oracle Grid Infrastructure for a Stand-Alone Server
Configure Storage for Oracle Automatic Storage ManagementGI ArchitectureASM ArchitectureASM DisksCreating ASM DisksInstall Oracle Grid Infrastructure for a Stand-Alone ServerTwo-Minute DrillConfigure Storage for Oracle Automatic Storage ManagementInstall Oracle Grid Infrastructure for a Stand-Alone ServerSelf TestSelf Test Answers
Chapter 4 Using Oracle Restart
Use Oracle Restart to Manage ComponentsAdministering the Oracle Restart ProcessesAdministering Registered ResourcesThe Restart CapabilityTwo-Minute DrillUse Oracle Restart to Manage ComponentsSelf TestSelf Test Answers
PART II SQL
Chapter 5 DDL and Schema Objects
Use the Client ToolsSQL*PlusSQL DeveloperCategorize the Main Database ObjectsObject TypesUsers and SchemasNaming Schema ObjectsObject NamespacesList the Data Types that Are Available for ColumnsCreate a Simple TableCreating Tables with Column SpecificationsCreating Tables from SubqueriesAltering Table Definitions After CreationDropping and Truncating TablesCreate and Use Temporary TablesIndexesWhy Indexes Are NeededTypes of IndexesCreating and Using IndexesModifying and Dropping IndexesConstraintsThe Types of ConstraintsDefining ConstraintsConstraint StateConstraint CheckingViewsWhy Use Views at All?Simple and Complex ViewsCREATE VIEW, ALTER VIEW, and DROP VIEWSynonymsSequencesCreating SequencesUsing SequencesTwo-Minute DrillCategorize the Main Database ObjectsList the Data Types that Are Available for ColumnsCreate a Simple TableCreate and Use Temporary TablesIndexesConstraintsViewsSynonymsSequencesSelf TestSelf Test Answers
Chapter 6 DML and Concurrency
Describe Each Data Manipulation Language StatementINSERTUPDATEDELETETRUNCATEMERGEDML Statement FailuresControl TransactionsDatabase TransactionsExecuting SQL StatementsTransaction Control: COMMIT, ROLLBACK, SAVEPOINT, SELECT FOR UPDATEExplain DML and Undo Data GenerationMonitor and Administer Undo DataError Conditions Related to UndoParameters for Undo ManagementSizing and Monitoring the Undo TablespaceTemporary UndoCreating and Managing Undo TablespacesDescribe the Difference Between Undo Data and Redo DataConfigure Undo RetentionConfiguring Undo Retention to Support Long-Running QueriesFlashback Query and Undo RetentionDescribe the Locking Mechanism and Data Concurrency ManagementShared and Exclusive LocksThe Enqueue MechanismAutomatic and Manual LockingMonitor and Resolve Locking ConflictsThe Causes of Lock ContentionDetecting Lock ContentionSolving Lock ContentionDeadlocks: A Special CaseTwo-Minute DrillDescribe Each Data Manipulation Language StatementControl TransactionsExplain DML and Undo Data GenerationMonitor and Administer Undo DataDescribe the Difference Between Undo Data and Redo DataConfigure Undo RetentionDescribe the Locking Mechanism and Data Concurrency ManagementMonitor and Resolve Locking ConflictsSelf TestSelf Test Answers
Chapter 7 Retrieving, Restricting, and Sorting Data Using SQL
Explain the Capabilities of SQL SELECT StatementsIntroducing the SQL SELECT StatementThe DESCRIBE Table CommandCapabilities of the SELECT StatementData NormalizationData ModelingEntities and RelationsRows and TablesCreate the Demonstration SchemasUsers and SchemasThe HR and OE SchemasDemonstration Schema CreationExecute a Basic SELECT StatementSyntax of the Primitive SELECT StatementRules Are Meant to Be FollowedSQL Expressions and OperatorsNULL Is NothingLimit the Rows Retrieved by a QueryThe WHERE ClauseComparison OperatorsBoolean OperatorsPrecedence RulesSort the Rows Retrieved by a QueryThe ORDER BY ClauseThe SQL Row-Limiting ClauseAmpersand SubstitutionSubstitution VariablesDefine and VerifyTwo-Minute DrillExplain the Capabilities of SQL SELECT StatementsExecute a Basic SELECT StatementLimit the Rows Retrieved by a QuerySort the Rows Retrieved by a QueryAmpersand SubstitutionSelf TestSelf Test Answers
Chapter 8 Single-Row and Conversion Functions
Describe and Use Character, Number, and Date Functions in SQLDefining a FunctionTypes of FunctionsUsing Case Conversion FunctionsUsing Character Manipulation FunctionsUsing Numeric FunctionsWorking with DatesDescribe Various Types of Conversion Functions Available in SQLConversion FunctionsUse the TO_CHAR, TO_NUMBER, and TO_DATE Conversion FunctionsUsing the Conversion FunctionsApply Conditional Expressions in a SELECT StatementNested FunctionsConditional FunctionsTwo-Minute DrillDescribe Various Types of Conversion Functions Available in SQLUse the TO_CHAR, TO_NUMBER, and TO_DATE Conversion FunctionsApply Conditional Expressions in a SELECT StatementSelf TestSelf Test Answers
Chapter 9 Group Functions
Describe the Group FunctionsDefinition of Group FunctionsUsing Group FunctionsGroup Data Using the GROUP BY ClauseCreating Groups of DataThe GROUP BY ClauseGrouping by Multiple ColumnsNested Group FunctionsInclude or Exclude Grouped Rows Using the HAVING ClauseRestricting Group ResultsThe HAVING ClauseTwo-Minute DrillDescribe the Group FunctionsGroup Data Using the GROUP BY ClauseInclude or Exclude Grouped Rows Using the HAVING ClauseSelf TestSelf Test Answers
Chapter 10 SQL Joins
Write SELECT Statements to Access Data from More Than One Table Using Equijoins and NonequijoinsTypes of JoinsJoining Tables Using ANSI SQL SyntaxQualifying Ambiguous Column NamesThe NATURAL JOIN ClauseThe JOIN USING ClauseThe JOIN ON ClauseN-Way Joins and Additional Join ConditionsNonequijoinsJoin a Table to Itself Using a Self-JoinJoining a Table to Itself Using the JOIN . . . ON ClauseView Data That Does Not Meet a Join Condition by Using Outer JoinsInner versus Outer JoinsLeft Outer JoinsRight Outer JoinsFull Outer JoinsGenerate a Cartesian Product of Two or More TablesCreating Cartesian Products Using Cross JoinsTwo-Minute DrillWrite SELECT Statements to Access Data from More Than One Table Using Equijoins and NonequijoinsJoin a Table to Itself Using a Self-JoinView Data that Does Not Meet a Join Condition Using Outer JoinsGenerate a Cartesian Product of Two or More TablesSelf TestSelf Test Answers
Chapter 11 Subqueries and Set Operators
Define SubqueriesDescribe the Types of Problems that the Subqueries Can SolveUse of a Subquery Result Set for Comparison PurposesStar TransformationGenerate a Table from Which to SELECTGenerate Values for ProjectionGenerate Rows to Be Passed to a DML StatementDescribe the Types of SubqueriesSingle- and Multiple-Row SubqueriesCorrelated SubqueriesWrite Single-Row and Multiple-Row SubqueriesUsing the EXISTS ConditionNull Results in a SubqueryDescribe the Set OperatorsSets and Venn DiagramsSet Operator General PrinciplesUse a Set Operator to Combine Multiple Queries into a Single QueryThe UNION ALL OperatorThe UNION OperatorThe INTERSECT OperatorThe MINUS OperatorMore Complex ExamplesControl the Order of Rows ReturnedTwo-Minute DrillDefine SubqueriesDescribe the Types of Problems that the Subqueries Can SolveDescribe the Types of SubqueriesWrite Single-Row and Multiple-Row SubqueriesDescribe the Set OperatorsUse a Set Operator to Combine Multiple Queries into a Single QueryControl the Order of Rows ReturnedSelf TestSelf Test Answers
PART III DBA1
Chapter 12 Architectural Overview of Oracle Database 12c
List the Architectural Components of an Oracle DatabaseSingle-Instance Database ArchitectureDistributed Systems ArchitecturesExplain the Memory StructuresThe Database Buffer CacheThe Log BufferThe Shared PoolThe Large PoolThe Java PoolThe Streams PoolDescribe the Background ProcessesSMON, the System MonitorPMON, the Process MonitorDBWn, the Database WriterLGWR, the Log WriterCKPT, the Checkpoint ProcessMMON, the Manageability MonitorMMNL, the Manageability Monitor LightMMAN, the Memory ManagerLREG, the Listener Registration ProcessARCn, the ArchiverRECO, the Recoverer ProcessSome Other Background ProcessesExplain the Relationship Between Logical and Physical Storage StructuresThe Physical Database StructuresThe Logical Database StructuresThe Data DictionaryTwo-Minute DrillList the Architectural Components of an Oracle DatabaseExplain the Memory StructuresDescribe the Background ProcessesExplain the Relationship Between Logical and Physical Storage StructuresSelf TestSelf Test Answers
Chapter 13 Instance Management
Use Database Management ToolsWorking with SQL*PlusLog On as a Normal or Privileged UserWorking with Database ExpressUnderstand Initialization Parameter FilesStatic and Dynamic Parameter FilesStatic and Dynamic Parameters and the Initialization Parameter FileThe Basic ParametersChanging ParametersStart Up and Shut Down an Oracle Database InstanceStarting the Database ListenerDatabase Startup and ShutdownView the Alert Log and Access Dynamic Performance ViewsThe Alert LogThe DDL LogThe Dynamic Performance ViewsTwo-Minute DrillUse Database Management ToolsUnderstand Initialization Parameter FilesStart Up and Shut Down an Oracle Database InstanceView the Alert Log and Access Dynamic Performance ViewsSelf TestSelf Test Answers
Chapter 14 Oracle Networking
Configure Oracle Net ServicesOracle Net and the Client-Server ParadigmEstablishing a SessionCreating a Database ListenerDynamic Service RegistrationShared ServerUse Tools for Configuring and Managing the Oracle NetworkThe Net ManagerThe Net Configuration AssistantThe Listener Control UtilityThe TNS_ADMIN Environment VariableConfigure Client-Side NetworkEasy Connect Name ResolutionLocal Naming Name ResolutionDirectory Naming and External NamingTesting Oracle Net ConnectivityUnderstand Database Resident Connection PoolingConfigure Communication Between DatabasesTwo-Minute DrillConfigure Oracle Net ServicesUse Tools for Configuring and Managing the Oracle NetworkConfigure Client-Side NetworkUnderstand Database Resident Connection PoolingConfigure Communication Between DatabasesSelf TestSelf Test Answers
Chapter 15 Oracle Storage
Describe the Storage of Table Row Data in BlocksThe Oracle Data Storage ModelSegments, Extents, Blocks, and RowsCreate and Manage TablespacesCreating TablespacesAltering TablespacesDropping TablespacesExtent ManagementSegment Space ManagementOracle Managed FilesExplain How Oracle Database Server Automatically Manages SpaceSegment Space AssignmentAutomatic Segment Space ManagementSave Space by Using CompressionProactively Monitor and Manage Tablespace Space UsageUse the Segment AdvisorReclaim Wasted Space from Tables and Indexes by Using the Segment Shrink FunctionalityManage Resumable Space AllocationTwo-Minute DrillDescribe the Storage of Table Row Data in BlocksCreate and Manage TablespacesExplain How Oracle Database Server Automatically Manages SpaceSave Space by Using CompressionProactively Monitor and Manage Tablespace Space UsageUse the Segment AdvisorReclaim Wasted Space from Tables and Indexes by Using the Segment Shrink FunctionalityManage Resumable Space AllocationSelf TestSelf Test Answers
Chapter 16 Oracle Security
Create and Manage Database User AccountsUser Account AttributesAuthentication MethodsCreating AccountsGrant and Revoke PrivilegesSystem PrivilegesObject PrivilegesCreate and Manage RolesCreating and Granting RolesPredefined RolesEnabling RolesPrivilege AnalysisCreate and Manage ProfilesPassword Profile LimitsCreating and Assigning ProfilesExplain DBA Responsibilities for Security and AuditingReasons for AuditingAuditing TechniquesEnable Standard Database Auditing and Unified AuditingEnable Standard AuditingEnable Unified AuditingTwo-Minute DrillCreate and Manage Database User AccountsGrant and Revoke PrivilegesCreate and Manage RolesCreate and Manage ProfilesExplain DBA Responsibilities for Security and AuditingEnable Standard Database Auditing and Unified AuditingSelf TestSelf Test Answers
Chapter 17 Moving and Re-organizing Data
Describe Ways to Move DataCreate and Use Directory ObjectsUse SQL*Loader to Load Data from a Non-Oracle DatabaseUsing SQL*LoaderSQL*Loader Express ModeUse External Tables to Move Data via Platform-Independent FilesExplain the General Architecture of Oracle Data PumpUse Data Pump Export and Import to Move Data Between Oracle DatabasesCapabilitiesUsing Data Pump with the Command-Line UtilitiesTablespace Export and ImportUse Data Pump in a Multitenant EnvironmentExport from Non-CDB and Import into PDBExport and Import Between PDBsExport from PDB and Import into Non-CDBFull Transportable Export and ImportTransporting a Database Over the NetworkUse SQL*Loader in a Multitenant EnvironmentTwo-Minute DrillDescribe Ways to Move DataCreate and Use Directory ObjectsUse SQL*Loader to Load Data from a Non-Oracle DatabaseUse External Tables to Move Data via Platform-Independent FilesExplain the General Architecture of Oracle Data PumpUse Data Pump Export and Import to Move Data Between Oracle DatabasesUse Data Pump in a Multitenant EnvironmentUse SQL*Loader in a Multitenant EnvironmentSelf TestSelf Test Answers
Chapter 18 The AWR and the Alert System
Manage the Automatic Workload RepositoryGathering AWR StatisticsManaging the AWRUse the Automatic Database Diagnostic MonitorDescribe and Use the Advisory FrameworkThe Memory AdvisorsThe SQL AdvisorsThe Automatic Undo AdvisorThe Mean Time to Recover AdvisorThe Data Recovery AdvisorThe Segment AdvisorThe SQL Repair AdvisorSet Alert ThresholdsAlert Condition Monitoring and NotificationsSetting ThresholdsUse Automated TasksThe AutotasksControlling the AutotasksTwo-Minute DrillManage the Automatic Workload RepositoryUse the Automatic Database Diagnostic MonitorDescribe and Use the Advisory FrameworkSet Alert ThresholdsUse Automated TasksSelf TestSelf Test Answers
Chapter 19 Performance Tuning
Use Enterprise Manager to Monitor PerformanceA Performance Tuning MethodologyPerformance Monitoring DataThe Database Express Performance PagesUse Automatic Memory ManagementPGA Memory ManagementSGA Memory ManagementAutomatic Memory ManagementUse the Memory Advisor to Size Memory BuffersManage Optimizer StatisticsObject StatisticsHow the Optimizer Uses StatisticsGathering Statistics ManuallyUse the SQL Tuning AdvisorThe Capabilities of the SQL Tuning AdvisorThe SQL Tuning Advisor API: The DBMS_SQLTUNE PackageUse the SQL Access Advisor to Tune WorkloadThe Capabilities of the SQL Access AdvisorUsing the SQL Access Advisor with DBMS_ADVISORTwo-Minute DrillUse Enterprise Manager to Monitor PerformanceUse Automatic Memory ManagementUse the Memory Advisor to Size Memory BuffersManage Optimizer StatisticsUse the SQL Tuning AdvisorUse the SQL Access Advisor to Tune WorkloadSelf TestSelf Test Answers
Chapter 20 The Resource Manager
Configure the Database Resource ManagerThe Need for Resource ManagementThe Resource Manager ArchitectureResource Manager ConfigurationAccess and Create Resource PlansCPU MethodUse of the Ratio CPU MethodThe Active Session Pool MethodLimiting the Degree of ParallelismControlling Jobs by Execution TimeTerminating Sessions by Idle TimeRestricting Generation of Undo DataMonitor the Resource ManagerTwo-Minute DrillConfigure the Database Resource ManagerAccess and Create Resource PlansMonitor the Resource ManagerSelf TestSelf Test Answers
Chapter 21 The Scheduler
Use Oracle Scheduler to Simplify Management TasksThe Scheduler ArchitectureScheduler ObjectsUse Job Chains to Perform a Series of Related TasksUse Scheduler Jobs on Remote SystemsUse Advanced Scheduler Features to Prioritize JobsUsing Job ClassesUsing WindowsTwo-Minute DrillUse Oracle Scheduler to Simplify Management TasksUse Job Chains to Perform a Series of Related TasksUse Scheduler Jobs on Remote SystemsUse Advanced Scheduler Features to Prioritize JobsSelf TestSelf Test Answers
Part IV DBA2
Chapter 22 Configuring the Database for Backup and Recovery
Possible Failures and Their ResolutionFailure CategoriesOracle Backup and Recovery SolutionsInstance Recovery and the Impossibility of Database CorruptionCheckpoints and the Redo LogThe Checkpointing MechanismProtecting the Online Redo Log FilesArchivelog Mode and the Archiver ProcessesBackup and Recovery: ConfigurationConfigure the Fast Recovery AreaConfigure ARCHIVELOG ModeTwo-Minute DrillPossible Failures and Their ResolutionCheckpoints and the Redo LogConfigure the Fast Recovery AreaConfigure ARCHIVELOG ModeConfigure Control Files and Redo Log Files for RecoverabilitySelf TestSelf Test Answers
Chapter 23 Back Up with RMAN
Backup Theory and Basic SyntaxBackup ConceptsRMAN Basic SyntaxPersistent RMAN SettingsSome Advanced RMAN CapabilitiesThe Recovery CatalogCreate and Use RMAN Stored ScriptsIncremental BackupsOther CapabilitiesTwo-Minute DrillCreate Consistent Database BackupsBack Up Your Database Without Shutting It DownCreate Incremental BackupsAutomate Database BackupsManage Backups and the RMAN RepositoryUse Various RMAN Backup Types and StrategiesPerform Full and Incremental BackupsUse Techniques to Improve BackupsSelf TestSelf Test Answers
Chapter 24 Restore and Recover with RMAN
Perform Complete and Incomplete RecoveryRestore and Recovery in One PageUsing the RMAN RESTORE and RECOVER CommandsPerforming Complete Recovery of a Noncritical DatafilePerforming Complete Recovery of a Critical DatafilePerforming Incomplete Recovery Using RMANRecovering Using Incrementally Updated BackupsSwitching to Image Copies for Fast RecoveryPerform Recovery for Spfiles, Controlfiles, and Online Redo Log FilesRestoring the Spfile from the AutobackupRestoring the ControlfileRecovering from a Lost Redo Log GroupBacking Up and Restoring the Password FileRecovering from a Lost TempfileTwo-Minute DrillPerform Complete and Incomplete RecoveryPerform Recovery for Spfiles, Controlfiles, and Online Redo Log FilesPerform Recovery of TempfilesSelf TestSelf Test Answers
Chapter 25 Diagnosing Failures
Describe the Automatic Diagnostic WorkflowUnderstanding the ADRUsing the ADRCI ToolUnderstanding Alerts, Problems, and IncidentsUsing the Health MonitorHandle Block CorruptionBlock CorruptionUsing Block Media RecoveryUsing the Data Recovery AdvisorTwo-Minute DrillDescribe the Automatic Diagnostic WorkflowHandle Block CorruptionSelf TestSelf Test Answers
Chapter 26 Flashback
Describe the Flashback TechnologiesFlashback DatabaseFlashback Query, Transaction, and TableFlashback DropFlashback Data ArchiveWhen to Use Flashback TechnologyUse Flashback to Query DataBasic Flashback QueryFlashback Table QueryFlashback Versions QueryFlashback Transaction QueryFlashback and Undo DataPerform Flashback Table Drop OperationsThe Implementation of Flashback DropUsing Flashback DropManaging the Recycle BinPerform Table Recovery from BackupsDescribe and Use Flashback Data ArchivePerform Flashback DatabaseFlashback Database ArchitectureConfiguring Flashback DatabaseMonitoring Flashback DatabaseUsing Flashback DatabaseTwo-Minute DrillDescribe the Flashback TechnologiesUse Flashback to Query DataPerform Flashback Table OperationsPerform Table Recovery from BackupsDescribe and Use Flashback Data ArchivePerform Flashback DatabaseSelf TestSelf Test Answers
Chapter 27 Duplicating a Database
Describe and Use Transportable Tablespaces and DatabasesConfiguring Transportable TablespacesTransporting TablespacesTransporting a DatabaseDuplicate a DatabaseUsing a Duplicate DatabaseDuplicate from the Active DatabaseDuplicate from BackupTwo-Minute DrillDescribe and Use Transportable Tablespaces and DatabasesChoose a Technique for Duplicating a DatabaseCreate a Backup-Based Duplicate DatabaseDuplicate a DatabaseSelf TestSelf Test Answers
Chapter 28 Encrypting, Securing, Monitoring, and Tuning RMAN Backups
Create RMAN-Encrypted BackupsConfiguring and Using Transparent EncryptionUsing Password EncryptionUsing Dual-Mode EncryptionConfigure and Use Oracle Secure BackupInstalling and Configuring Oracle Secure BackupUsing RMAN with Oracle Secure BackupMiscellaneous obtool CommandsMonitor and Tune RMAN PerformanceMonitoring RMAN Sessions and JobsTuning RMAN PerformanceIdentifying Backup and Restore StepsParallelizing BackupsetsUnderstanding RMAN MultiplexingTuning RMAN ChannelsTuning the BACKUP CommandTwo-Minute DrillCreate RMAN-Encrypted BackupsConfigure and Use Oracle Secure BackupTune RMAN PerformanceSelf TestSelf Test Answers
Part V Upgrades and Multitenant
Chapter 29 Upgrading Oracle Database Software and Migrating Data
Describe Upgrade MethodsSoftware UpgradeDatabase Upgrade: DBUA or ManualDescribe Data Migration MethodsDescribe the Upgrade ProcessMigrate Data by Using Oracle Data PumpTwo-Minute DrillDescribe Upgrade MethodsDescribe Data Migration MethodsDescribe the Upgrade ProcessMigrate Data by Using Oracle Data PumpSelf TestSelf Test Answers
Chapter 30 Upgrading an Oracle Database
Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle DatabaseOracle Label Security and Oracle Data VaultOracle Warehouse BuilderUse the Pre-Upgrade Information Tool Before Performing an UpgradePrepare the New Oracle Home Prior to Performing an UpgradeUpgrade the Database to Oracle Database 12c by Using the Database Upgrade AssistantPerform a Manual Upgrade to Oracle Database 12c by Using Scripts and ToolsMigrate to Unified AuditingPerform Postupgrade TasksTwo-Minute DrillDescribe Upgrade Requirements when Certain Features or Options Are Used in Oracle DatabaseUse the Pre-Upgrade Information Tool Before Performing an UpgradePrepare the New Oracle Home Prior to Performing an UpgradeUpgrade the Database to Oracle Database 12c by Using the Database Upgrade AssistantPerform a Manual Upgrade to Oracle Database 12c by Using Scripts and ToolsMigrate to Unified AuditingPerform Post-Upgrade TasksSelf TestSelf Test Answers
Chapter 31 Multitenant Container and Pluggable Database Architecture
Describe the Multitenant Container Database ArchitectureMultitenant ConceptsThe Drivers for MultitenantThe CDB and the Root ContainerPDBs: Pluggable ContainersExplain Pluggable Database ProvisioningTechniques for Provisioning Pluggable ContainersCommunications Between ContainersTwo-Minute DrillDescribe the Multitenant Container Database ArchitectureExplain Pluggable Database ProvisioningSelf TestSelf Test Answers
Chapter 32 Creating and Managing Multitenant Container and Pluggable Databases
Create a Container DatabaseUse DBCA to Create a CDBUsing SQL*Plus to Create a CDBCreate Pluggable ContainersUsing PDB$SEED to Create a New PDBCloning a PDB to Create a New PDBPlug a Non-CDB into a CDBPlug an Unplugged PDB into a CDBUnplug and Drop a PDBMigrate a Pre-12.1 Non-CDB Database to CDBEstablish Connections to CDBs and PDBsUnderstanding CDB and PDB Service NamesCreating Services for CDBs or PDBsSwitching Connections Within a CDBStart Up and Shut Down a CDB and Open and Close PDBsCDB Instance StartupOpen and Close a PDBCDB Instance ShutdownAutomating PDB StartupChanging PDB StatusEvaluate the Impact of Parameter Value ChangesUnderstanding the Scope of Parameter ChangesUsing ALTER SYSTEM in a Multitenant EnvironmentTwo-Minute DrillCreate a Container DatabaseCreate Pluggable ContainersMigrate a Pre-12.1 Non-CDB Database to CDBEstablish Connections to CDBs and PDBsStart Up and Shut Down a CDB and Open and Close PDBsEvaluate the Impact of Parameter Value ChangesSelf TestSelf Test Answers
Chapter 33 Managing Storage, Security, Availability, and Performance in a CDB and PDBs
Space Management in a Multitenant EnvironmentTablespace ArchitectureUsing CREATE TABLESPACEDefault Permanent and Temporary Tablespaces in a PDBManage Common and Local Users, Roles, and PrivilegesCommon and Local UsersGrant Privileges Commonly and LocallyManage Common and Local RolesEnable Common Users to Access Data in Specific PDBsAudit in the Multitenant EnvironmentMultitenant Backup and RecoveryBack Up a CDB and Individual PDBsRestore and RecoveryDuplicate PDBs Using RMANMulitenant Performance Monitoring and TuningTuning the InstanceUsing Memory AdvisorsManage Allocation of Resources Between PDBs and Within a PDBUsing Shares to Manage Inter-PDB ResourcesCreating and Modifying Resource Manager PlansPerform Database ReplayCapture Source Database WorkloadsProcess Workloads on the Target SystemReplay Workloads on Target CDB: Consolidated ReplayTwo-Minute DrillManage Permanent and Temporary Tablespaces in CDB and PDBsManage Common and Local UsersManage Common and Local PrivilegesManage Common and Local RolesEnable Common Users to Access Data in Specific PDBsPerform Backups of a CDB and PDBsRecover PDB from PDB Datafiles LossUse Data Recovery AdvisorDuplicate PDBs Using RMANMonitor Operations and Performance in a CDB and PDBsManage Allocation of Resources Between PDBs and Within a PDBPerform Database ReplaySelf TestSelf Test Answers
Appendix About the Download
System RequirementsInstalling and Running Total TesterAbout Total TesterTechnical Support
Glossary
Index

Overview

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, and a score report performance assessment tool
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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

OCA/OCP Oracle Database 11g All-in-One Exam Guide

Publisher Resources

ISBN: 9780071828079

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills