book

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

Name: OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)
Author: John Watson
ISBN: 9780071591034

by John Watson

May 2008

Intermediate to advanced

733 pages

17h 19m

English

McGraw Hill Computing

Read now

Unlock full access

Cover Page
OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052)
Copyright Page
CD Page
Contents
Introduction
1 Introduction to the Oracle Server Technologies
Position the Oracle Product FamilyThe Server TechnologiesThe Development Tools and LanguagesThe Oracle ApplicationsExercise 1-1: Investigate DBMSs in Your EnvironmentExplain Relational StructuresRows and TablesData NormalizationUnderstand the SQL LanguageAppreciate the DBA's RoleTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
2 Exploring the Database Architecture
Describe the Single-Instance ArchitectureSingle-Instance Database ArchitectureDistributed Systems ArchitecturesExercise 2-1: Determine if the Database Is Single Instance or Part of a Distributed SystemExplain the Memory StructuresThe Database Buffer CacheThe Log BufferThe Shared PoolThe Large PoolThe Java PoolThe Streams PoolExercise 2-2: Investigate the Memory Structures of the InstanceDescribe the Process StructuresSMON, the System MonitorPMON, the Process MonitorDBWn, the Database WriterLGWR, the Log WriterCKPT, the Checkpoint ProcessMMON, the Manageability MonitorMMNL, the Manageability Monitor LightMMAN, the Memory ManagerARCn, the ArchiverRECO, the Recoverer ProcessSome Other Background ProcessesExercise 2-3: Investigate the Processes Running in Your InstanceSummarize the Storage StructuresThe Physical Database StructuresThe Logical Database StructuresThe Data DictionaryExercise 2-4: Investigate the Storage Structures in Your DatabaseTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
3 Preparing the Database Environment
Identify the Tools for Administering an Oracle DatabaseThe Oracle Universal InstallerDatabase Creation and Upgrade ToolsTools for Issuing Ad Hoc SQL: SQL*Plus and SQL DeveloperExercise 3-1: Install SQL Developer on WindowsOracle Enterprise ManagerOther Administration ToolsPlan an Oracle Database InstallationChoice of Operating SystemHardware and Operating System ResourcesExercise 3-2: Confirm Available Hardware Resources 104 Optimal Flexible ArchitectureEnvironment VariablesInstall the Oracle Software by Using the Oracle Universal Installer (OUI)Exercise 3-3: Install the Oracle HomeTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
4 Creating an Oracle Database
Create a Database by Using the Database Configuration AssistantThe Instance, the Database, and the Data DictionaryUsing the DBCA to Create a DatabaseExercise 4-1: Use the DBCA to Create a DatabaseThe Scripts and Other Files Created by the DBCAThe DBCA's Other FunctionsTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer

5 Managing the Oracle Instance
Describe the Stages of Database Startup and ShutdownStarting and Connecting to Database ControlStarting the Database ListenerStarting SQL*PlusDatabase Startup and ShutdownExercise 5-1: Conduct a Startup and a ShutdownSet Database Initialization ParametersStatic and Dynamic Parameters, and the Initialization Parameter FileThe Basic ParametersExercise 5-2: Query and Set Initialization ParametersUse the Alert Log and Trace FilesExercise 5-3: Use the Alert LogUse Data Dictionary and Dynamic Performance ViewsThe Data Dictionary ViewsThe Dynamic Performance ViewsExercise 5-4: Query Data Dictionary and Dynamic Performance ViewsTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
6 Configuring the Oracle Network Environment
Configure and Manage the Oracle NetworkOracle Net and the Client-Server ParadigmA Word on Oracle Net and Communication ProtocolsEstablishing a SessionCreating a ListenerDatabase RegistrationTechniques for Name ResolutionThe Listener Control UtilityConfiguring Service AliasesFile Names and the TNSADMIN Environment VariableDatabase LinksExercise 6-1: Configure Oracle NetUse the Oracle Shared Server ArchitectureThe Limitations of Dedicated Server ArchitectureThe Shared Server ArchitectureConfiguring Shared ServerWhen to Use the Shared ServerExercise 6-2 (optional): Set Up a Shared Server EnvironmentTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
7 Managing Database Storage Structures
Understand Tablespaces and DatafilesThe Oracle Data Storage ModelSegments, Extents, Blocks, and RowsAutomatic Storage Management (ASM)Exercise 7-1: Investigate the Database's Data Storage StructuresCreate and Manage TablespacesTablespace CreationAltering TablespacesDropping TablespacesOracle-Managed Files (OMF)Exercise 7-2: Create, Alter, and Drop TablespacesManage Space in TablespacesExtent ManagementSegment Space ManagementExercise 7-3: Change Tablespace CharacteristicsTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
8 Administering User Security
Create and Manage Database User AccountsUser Account AttributesAuthentication MethodsCreating AccountsExercise 8-1: Create UsersGrant and Revoke PrivilegesSystem PrivilegesObject PrivilegesExercise 8-2: Grant Direct PrivilegesCreate and Manage RolesCreating and Granting RolesPredefined RolesEnabling RolesExercise 8-3: Create and Grant RolesCreate and Manage ProfilesPassword ManagementResource LimitsCreating and Assigning ProfilesExercise 8-4: Create and Use ProfilesTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
9 Managing Schema Objects
Create and Modify TablesUsers, User Accounts, Schemas, and Schema ObjectsNaming Schema ObjectsObject NamespacesDatatypesCreating TablesExercise 9-1: Create and Modify TablesManage ConstraintsThe Types of ConstraintDefining ConstraintsConstraint StateConstraint CheckingExercise 9-2: Manage ConstraintsCreate IndexesWhy Indexes Are NeededTypes of IndexCreating and Using IndexesModifying and Dropping IndexesExercise 9-3: Create IndexesCreate and Use Temporary TablesExercise 9-4: Create and Use Temporary TablesTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
10 Managing Data and Concurrency
Manage Data Using DMLDatabase TransactionsExecuting SQL StatementsTransaction Control: COMMIT, ROLLBACK, SAVEPOINTExercise 10-1: Manage Data Using DMLIdentify and Administer PL/SQL ObjectsSQL and Procedural LanguagesStored and Anonymous PL/SQLPL/SQL ObjectsExercise 10-2: Create PL/SQL ObjectsMonitor and Resolve Locking ConflictsShared and Exclusive LocksThe Enqueue MechanismLock ContentionDeadlocksExercise 10-3: Detect and Resolve Lock ContentionTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
11 Managing Undo Data
Explain the Purpose of UndoExercise 11-1: Use Undo DataUnderstand How Transactions Generate UndoExercise 11-2: Work with Transactions and Flashback QueryManage UndoError Conditions Related to UndoParameters for Undo Management, and Retention GuaranteeSizing and Monitoring the Undo TablespaceFlashback QueryCreating and Managing Undo TablespacesExercise 11-3: Work with Undo TablespacesTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
12 Implementing Oracle Database Security
Database Security and Principle of Least PrivilegePublic PrivilegesSecurity-Critical Instance ParametersExercise 12-1: Remove Some Potentially Dangerous PrivilegesWork with Standard Database AuditingAuditing SYSDBA ActivityDatabase AuditingValue-Based Auditing with TriggersFine-Grained Auditing (FGA)Exercise 12-2: Use Standard Database AuditingTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
13 Database Maintenance
Use and Manage Optimizer StatisticsObject StatisticsGathering Statistics ManuallyThe STATISTICS_LEVEL Instance ParameterExercise 13-1: Gather Optimizer Statistics with Various ToolsUse and Manage the Automatic Workload RepositoryGathering AWR StatisticsManaging the AWRStatistics, Metrics, and BaselinesThe DBMS_WORKLOAD_REPOSITORY PackageExercise 13-2: Monitor the Automatic Workload RepositoryUse the Advisory FrameworkThe Automatic Database Diagnostic MonitorThe AdvisorsAutomatic Maintenance JobsExercise 13-3: Generate an ADDM ReportManage Alerts and ThresholdsAlert Condition Monitoring and NotificationsSetting ThresholdsThe Notification SystemExercise 13-4: Configure AlertsTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
14 Performance Management
Use Automatic Memory ManagementPGA Memory ManagementSGA Memory ManagementAutomatic Memory ManagementExercise 14-1: Set the Memory Management ParametersUse Memory AdvisorsExercise 14-2: Use the Memory AdvisorsTroubleshoot Invalid and Unusable ObjectsInvalid ObjectsUnusable IndexesExercise 14-3: Repair Invalid Objects and Unusable IndexesTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
15 Backup and Recovery Concepts
Identify the Types of Failure That Can Occur in an Oracle DatabaseStatement FailureUser Process FailureUser ErrorsMedia FailureInstance FailureExercise 15-1: Correct Statement FailuresDescribe Ways to Tune Instance RecoveryThe Mechanics of Instance RecoveryThe Impossibility of Database CorruptionTuning Instance RecoveryThe MTTR Advisor and Checkpoint Auto-TuningExercise 15-2: Monitor Instance Recovery TimesIdentify the Importance of Checkpoints, Redo Log Files, and Archived Log FilesCheckpointingProtecting the Online Redo Log FilesArchivelog Mode and the Archiver Process(es)Exercise 15-3: Investigate the Redo Log ConfigurationOverview of Flash Recovery AreaExercise 15-4: Investigate the Flash Recovery Area ConfigurationConfigure ARCHIVELOG ModeExercise 15-5: Enable Archivelog ModeTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
16 Performing Database Backups
Create Consistent Database BackupsUser-Managed Consistent BackupsServer-Managed Consistent BackupsExercise 16-1: Managing Consistent User- and Server-Managed BackupsBack Up Your Database Without Shutting It DownUser-Managed Open BackupsServer-Managed Open BackupsExercise 16-2: Perform Server-Managed and User-Managed Open BackupsCreate Incremental BackupsExercise 16-3: Make an Incremental BackupAutomate Database BackupsExercise 16-4: Define an Automatic Backup JobManage Backups, View Backup Reports, and Monitor the Flash Recovery AreaThe RMAN RepositoryReports on BackupsManaging BackupsMonitoring the Flash Recovery AreaExercise 16-5: Manage RMAN BackupsTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
17 Performing Database Recovery
Overview of Data Recovery AdvisorRecovery from Loss of the ControlfileRecovery from Loss of an Online Redo Log File MemberLoss of Any Datafile in Noarchivelog ModeLoss of a Datafile in Archivelog ModeThe Health Monitor and the ADRThe Capabilities and Limitations of the DRAExercise 17-1: Use the DRA to Diagnose and Advise Upon ProblemsUse Data Recovery Advisor to Perform Recovery (Control File, Redo Log File, and Data File)Exercise 17-2: Repair a Fault with the DRATwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
18 Moving Data
Describe and Use Methods to Move Data (SQL Loader, Directory Objects, External Tables)SQL*LoaderDirectory ObjectsExternal TablesExercise 18-1: Use SQL*Loader and External TablesExplain the General Architecture of Oracle Data PumpData Pump and Export/ImportData Pump ArchitectureDirectories and File LocationsDirect Path or External Table Path?Exercise 18-2: Perform a Data Pump ExportUse Data Pump Export and Import to Move Data Between Oracle DatabasesCapabilitiesUsing Data Pump with the Command-Line UtilitiesUsing Data Pump with Database ControlExercise 18-3: Use Data Pump in Network ModeTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
19 Intelligent Infrastructure Enhancements
Use the Enterprise Manager Support WorkbenchThe Automatic Diagnostic Repository (ADR)Problems and IncidentsThe ADR Command-Line Interface (ADRCI)The Support WorkbenchExercise 19-1: Use the Support WorkbenchManage PatchesTypes of PatchIntegration with MetaLink and the Patch AdvisorApplying PatchesExercise 19-2: Download and Apply a PatchTwo-Minute DrillSelf TestLab QuestionSelf Test AnswersLab Answer
Appendix About the Download
About the DownloadSteps to Download MasterExamSystem RequirementsMasterExamHelpRemoving InstallationTechnical SupportLearnKey Technical Support
Glossary
Index
MediaCenter

Content preview from OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

11 Managing Undo Data

CERTIFICATION OBJECTIVES

11.01 Explain the Purpose of Undo

11.02 Understand How Transactions Generate Undo

11.03 Manage Undo

Two-Minute Drill

Self Test

Chapter 10 described what happens in memory, and on disk, when you execute INSERT, UPDATE, or DELETE statements—the manner in which changed data is written to blocks of table and index segments, and the old version of the data is written out to blocks of an undo segment. It also covered the theory behind this, summarized as the ACID test, which every relational database must ...

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

OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060), 2nd Edition

Publisher Resources

ISBN: 9780071591027

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

by John Watson

11 Managing Undo Data

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.