book

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

by John Watson, Roopesh Ramklass, Bob Bryla

September 2009

Intermediate to advanced

1050 pages

29h 36m

English

McGraw Hill Computing

Read now

Unlock full access

Exam ObjectivesOracle Product StackOracle Server FamilyOracle Development ToolsOracle ApplicationsPrerequisite ConceptsOracle ConceptsSQL ConceptsOperating System ConceptsSingle-Instance ArchitectureSingle-Instance Database ArchitectureDistributed Systems ArchitecturesInstance Memory StructuresThe Database Buffer CacheThe Log BufferThe Shared PoolThe Large PoolThe Java PoolThe Streams PoolInstance 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 ProcessesDatabase Storage StructuresThe Physical Database StructuresThe Logical Database StructuresThe Data DictionaryTwo-Minute DrillSingle-Instance ArchitectureInstance Memory StructuresInstance Process StructuresDatabase Storage StructuresSelf TestSelf Test Answers
Exam ObjectivesIdentify the Tools for Administering an Oracle DatabaseThe Oracle Universal InstallerDatabase Creation and Upgrade ToolsTools for Issuing Ad Hoc SQL: SQL*Plus and SQL DeveloperOracle Enterprise ManagerOther Administration ToolsPlan an Oracle Database InstallationChoice of Operating SystemHardware and Operating System ResourcesOptimal Flexible ArchitectureEnvironment VariablesInstall the Oracle Software by Using the Oracle Universal Installer (OUI)Create a Database by Using the Database Configuration AssistantThe Instance, the Database, and the Data DictionaryUsing the DBCA to Create a DatabaseThe Scripts and Other Files Created by the DBCAThe DBCA’s Other FunctionsTwo-Minute DrillIdentify the Tools for Administering an Oracle DatabasePlan an Oracle Database InstallationInstall the Oracle Software by Using the Oracle Universal Installer (OUI)Create a Database by Using the Database Configuration AssistantSelf TestSelf Test Answers
Exam ObjectivesSet Database Initialization ParametersStatic and Dynamic Parameters and the Initialization Parameter FileThe Basic ParametersDescribe the Stages of Database Startup and ShutdownStarting and Connecting to Database ControlStarting the Database ListenerStarting SQL*PlusDatabase Startup and ShutdownUse the Alert Log and Trace FilesUse Data Dictionary and Dynamic Performance ViewsThe Data Dictionary ViewsThe Dynamic Performance ViewsTwo-Minute DrillDescribe the Stages of Database Startup and ShutdownSet Database Initialization ParametersUse the Alert Log and Trace FilesUse Data Dictionary and Dynamic Performance ViewsSelf TestSelf Test Answers

Exam ObjectivesConfigure 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 AliasesFilenames and the TNSADMIN Environment VariableDatabase LinksUse the Oracle Shared Server ArchitectureThe Limitations of Dedicated Server ArchitectureThe Shared Server ArchitectureConfiguring Shared ServerWhen to Use the Shared ServerTwo-Minute DrillConfigure and Manage the Oracle NetworkUse the Oracle Shared Server ArchitectureSelf TestSelf Test Answers
Exam ObjectivesOverview of Tablespaces and DatafilesThe Oracle Data Storage ModelSegments, Extents, Blocks, and RowsFile Storage TechnologiesCreate and Manage TablespacesTablespace CreationAltering TablespacesDropping TablespacesOracle-Managed Files (OMF)Space Management in TablespacesExtent ManagementSegment Space ManagementTwo-Minute DrillOverview of Tablespaces and DatafilesCreate and Manage TablespacesSpace Management in TablespacesSelf TestSelf Test Answers
Exam ObjectivesCreate and Manage Database User AccountsUser Account AttributesAuthentication MethodsCreating AccountsGrant and Revoke PrivilegesSystem PrivilegesObject PrivilegesCreate and Manage RolesCreating and Granting RolesPredefined RolesEnabling RolesCreate and Manage ProfilesPassword ManagementResource LimitsCreating and Assigning ProfilesDatabase Security and Principle of Least PrivilegePublic PrivilegesSecurity-Critical Instance ParametersWork with Standard Database AuditingAuditing SYSDBA ActivityDatabase AuditingValue-Based Auditing with TriggersFine-Grained Auditing (FGA)Two-Minute DrillCreate and Manage Database User AccountsGrant and Revoke PrivilegesCreate and Manage RolesCreate and Manage ProfilesDatabase Security and Principle of Least PrivilegeWork with Standard Database AuditingSelf TestSelf Test Answers
Exam ObjectivesCategorize the Main Database ObjectsObject TypesNaming 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 Needed?Types of IndexCreating and Using IndexesModifying and Dropping IndexesConstraintsThe Types of ConstraintDefining 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 TablesConstraintsIndexesViewsSynonymsSequencesSelf TestSelf Test Answers
Exam ObjectivesData Manipulation Language (DML) StatementsINSERTUPDATEDELETETRUNCATEMERGEDML Statement FailuresControl TransactionsDatabase TransactionsExecuting SQL StatementsTransaction Control: COMMIT, ROLLBACK, SAVEPOINT, SELECT FOR UPDATEIdentify and Administer PL/SQL ObjectsStored and Anonymous PL/SQLPL/SQL ObjectsMonitor and Resolve Locking ConflictsShared and Exclusive LocksThe Enqueue MechanismLock ContentionDeadlocksOverview of UndoTransactions and Undo DataManaging UndoError Conditions Related to UndoParameters for Undo Management, and Retention GuaranteeSizing and Monitoring the Undo TablespaceCreating and Managing Undo TablespacesTwo-Minute DrillDescribe Each Data Manipulation Language (DML) StatementControl TransactionsManage Data Using DMLIdentify and Administer PL/SQL ObjectsMonitor and Resolve Locking ConflictsOverview of UndoTransactions and Undo DataManaging UndoSelf TestSelf Test Answers
Exam ObjectivesList the Capabilities of SQL SELECT StatementsIntroducing the SQL SELECT StatementThe DESCRIBE Table CommandCapabilities of the SELECT StatementData NormalizationCreate the Demonstration SchemasThe HR and WEBSTORE 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 ClauseAmpersand SubstitutionSubstitution VariablesDefine and VerifyTwo-Minute DrillList 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
Exam ObjectivesDescribe and Use Character, Number, and Date Functions in SQLDefining a FunctionTypes of FunctionsUsing Case Conversion FunctionsUsing Character Manipulations 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 Functions Available in SQLUse Character, Number, and Date Functions in SELECT StatementsDescribe 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
Exam ObjectivesThe 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 FunctionsIdentify the Available Group FunctionsGroup Data Using the GROUP BY ClauseInclude or Exclude Grouped Rows Using the HAVING ClauseSelf TestSelf Test Answers
Exam ObjectivesWrite SELECT Statements to Access Data from More Than One TableUsing Equijoins and Nonequijoins Types of JoinsJoining Tables Using SQL:1999 SyntaxQualifying Ambiguous Column NamesThe NATURAL JOIN ClauseThe Natural JOIN USING ClauseThe Natural 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
Exam ObjectivesDefine SubqueriesDescribe the Types of Problems That the Subqueries Can SolveUse of a Subquery Result Set for Comparison PurposesGenerate a Table from Which to SELECTGenerate Values for ProjectionGenerate Rows to Be Passed to a DML StatementList the Types of SubqueriesSingle- and Multiple-Row SubqueriesCorrelated SubqueriesWrite Single-Row and Multiple-Row SubqueriesDescribe 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 SolveList 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
Exam ObjectivesBackup and Recovery IssuesCategories of FailuresStatement FailureUser Process FailureNetwork FailureUser ErrorsMedia FailureInstance FailureInstance RecoveryThe Mechanics of Instance RecoveryThe Impossibility of Database CorruptionTuning Instance RecoveryThe MTTR Advisor and Checkpoint Auto-TuningCheckpointingPreparing the Database for RecoverabilityProtecting the ControlfileProtecting the Online Redo Log FilesArchivelog Mode and the Archiver ProcessProtecting the Archive Redo Log FilesThe Flash Recovery AreaRecovery FilesConfigure the Flash Recovery AreaFlash Recovery Area Space UsageTwo-Minute DrillIdentify the Types of Failure That Can Occur in an Oracle DatabaseDescribe Ways to Tune Instance RecoveryIdentify the Importance of Checkpoints, Redo Log Files, and Archived Log FilesConfigure ARCHIVELOG ModeConfigure Multiple Archive Log File Destinations to Increase AvailabilityOverview of the Flash Recovery AreaConfigure the Flash Recovery AreaUse the Flash Recovery AreaSelf TestSelf Test Answers
Exam ObjectivesBackup Concepts and TerminologyUsing the RMAN BACKUP Command to Create BackupsServer-Managed Consistent BackupsServer-Managed Open BackupsIncremental BackupsImage CopiesProtect Your BackupsParallelizing Backup OperationsEncrypting BackupsConfiguring RMAN DefaultsManaging and Monitoring RMAN BackupsThe LIST, REPORT, and DELETE CommandsArchival BackupsThe Dynamic Performance ViewsCrosschecking BackupsTwo-Minute DrillCreate Consistent Database BackupsBack Up Your Database Without Shutting It DownCreate Incremental BackupsAutomate Database BackupsManage Backups, View Backup Reports, and Monitor the Flash Recovery AreaDefine, Apply, and Use a Retention PolicyCreate Image File BackupsCreate a Whole Database BackupEnable Fast Incremental BackupCreate Duplex Backups and Back Up Backup SetsCreate an Archival Backup for Long-Term RetentionCreate a Multisection, Compressed, and Encrypted BackupReport On and Maintain BackupsConfigure Backup SettingsAllocate Channels to Use in Backing UpConfigure Backup OptimizationSelf TestSelf Test Answers
Exam ObjectivesThe Data Recovery AdvisorThe Health Monitor and the ADRThe Capabilities and Limitations of the DRAUsing the Data Recovery AdvisorDatabase Restore and RecoveryComplete Recovery from Data File Loss Using RMANRecovery of Datafiles in Noarchivelog ModeRecovery of a Noncritical File in Archivelog ModeRecovering from Loss of a Critical DatafileIncomplete RecoveryAutobackup and Restore of the ControlfileUsing Image Copies for RecoveryBlock RecoveryDetection of Corrupt BlocksBlock Media RecoveryThe BLOCK RECOVER CommandTwo-Minute DrillDescribe the Data Recovery AdvisorUse the Data Recovery Advisor to Perform Recovery (Controlfile, Redo Log File, and Datafile)Perform Complete Recovery from a Critical or Noncritical Data File Loss Using RMANPerform Incomplete Recovery Using RMANRecover Using Incrementally Updated BackupsSwitch to Image Copies for Fast RecoveryRecover Using a Backup Control FilePerform Block Media RecoverySelf TestSelf Test Answers
Exam ObjectivesThe Recovery CatalogThe Need for a Recovery CatalogCreating and Connecting to the CatalogThe Virtual Private CatalogProtecting and Rebuilding the CatalogStored ScriptsUsing RMAN to Create DatabasesTablespace Point-in-Time Recovery (TSPITR)The TSPITR MethodologyPerform Automated TSPITRRMAN Performance and MonitoringMonitoring RMAN Sessions and JobsTuning RMANTuning the BACKUP CommandConfigure RMAN for Asynchronous I/OTwo-Minute DrillIdentify Situations That Require an RMAN Recovery CatalogCreate and Configure a Recovery CatalogSynchronize the Recovery CatalogCreate and Use RMAN Stored ScriptsBack Up the Recovery CatalogCreate and Use a Virtual Private CatalogCreate a Duplicate DatabaseUse a Duplicate DatabaseRestore a Database onto a New HostPerform Disaster RecoveryIdentify the Situations That Require TSPITRPerform Automated TSPITRMonitor RMAN Sessions and JobsTune RMANConfigure RMAN for Asynchronous I/OSelf TestSelf Test Answers
Exam ObjectivesBackup and Recovery in One PageUser-Managed Database BackupBackup in Noarchivelog ModeBackup in Archivelog ModeBackup of the Password and Parameter FilesMedia Failure That Does Not Affect DatafilesRecovery from Loss of a Multiplexed ControlfileRecovery from Loss of a Multiplexed Online Redo Log FileRecovery from Loss of a TempfileRecovery from Loss of DatafilesRecovery of Datafiles in Noarchivelog ModeRecovery of a Noncritical Datafile in Archivelog ModeRecovering a Critical Datafile in Archivelog ModeUser-Managed Incomplete RecoveryTwo-Minute DrillRecover from a Lost TEMP FileRecover from a Lost Redo Log GroupRecover from the Loss of a Password FilePerform User-Managed Complete Database RecoveryPerform User-Managed Incomplete Database RecoveryPerform User-Managed BackupsIdentify the Need for Backup ModeBack Up and Recover a ControlfileSelf TestSelf Test Answers
Exam ObjectivesThe Different Flashback TechnologiesFlashback DatabaseFlashback Query, Transaction, and TableFlashback DropFlashback Data ArchiveWhen to Use Flashback TechnologyFlashback DatabaseFlashback Database ArchitectureConfiguring Flashback DatabaseMonitoring Flashback DatabaseUsing Flashback DatabaseLimiting the Amount of Flashback Data GeneratedFlashback DropThe Implementation of Flashback DropUsing Flashback DropManaging the Recycle BinFlashback QueryBasic Flashback QueryFlashback Table QueryFlashback Versions QueryFlashback Transaction QueryFlashback and Undo DataThe Flashback Data ArchiveTwo-Minute DrillRestore Dropped Tables from the Recycle BinPerform Flashback QueryUse Flashback TransactionPerform Flashback Table OperationsConfigure and Monitor Flashback Database and Perform Flashback Database OperationsSet Up and Use a Flashback Data ArchiveSelf TestSelf Test Answers
Exam ObjectivesThe Purpose of a Logical Volume ManagerRAID LevelsVolume SizesChoice of RAID LevelASM Compared with Third-Party LVMsThe ASM ArchitectureThe Cluster Synchronization ServiceThe ASM Disks and Disk GroupsThe ASM InstanceThe RDBMS InstanceThe ASM FilesCreating Raw DevicesCreating, Starting, and Stopping an ASM InstanceCreating ASM Disk GroupsCreating and Using ASM FilesASM and RMANThe ASMCMD UtilityTwo-Minute DrillDescribe Automatic Storage Management (ASM)Set Up Initialization Parameter Files for ASM and Database InstancesStart Up and Shut Down ASM InstancesAdminister ASM Disk GroupsSelf TestSelf Test Answers
Exam ObjectivesThe Need for Resource ManagementThe Resource Manager ArchitectureConsumer GroupsResource Manager PlansResource Manager Configuration ToolsManaging Users and Consumer GroupsResource Manager 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 DataAutomatic Consumer Group SwitchingAdaptive Consumer Group MappingTwo-Minute DrillUnderstand the Database Resource ManagerCreate and Use Database Resource Manager ComponentsSelf TestSelf Test Answers
Exam ObjectivesThe Scheduler ArchitectureScheduler ObjectsJobsProgramsSchedulesJob ClassesWindowsPrivilegesCreating and Scheduling JobsA Self-Contained JobUsing Programs and SchedulesEvent-Driven JobsJob ChainsLightweight JobsUsing Classes, Windows, and the Resource ManagerUsing Job ClassesUsing WindowsTwo-Minute DrillCreate a Job, Program, and ScheduleUse a Time-Based or Event-Based Schedule for Executing Scheduler JobsCreate Lightweight JobsUse Job Chains to Perform a Series of Related TasksCreate Windows and Job ClassesUse Advanced Scheduler Concepts to Prioritize JobsSelf TestSelf Test Answers
Exam ObjectivesSQL*LoaderExternal TablesDirectoriesUsing External TablesData PumpData Pump ArchitectureDirectories and File LocationsDirect Path or External Table Path?Using Data Pump Export and ImportCapabilitiesUsing Data Pump with the Command-Line UtilitiesUsing Data Pump with Database ControlTablespace Export and ImportResumable Space AllocationSegment ReorganizationRow Chaining and MigrationSegment ShrinkTwo-Minute DrillDescribe and Use Methods to Move Data (Directory Objects, SQL*Loader, External Tables)Explain the General Architecture of Oracle Data PumpUse Data Pump Export and Import to Move Data Between Oracle DatabasesDescribe the Concepts of Transportable Tablespaces and DatabasesManage Resumable Space AllocationReclaim Wasted Space from Tables and Indexes by Using the Segment Shrink FunctionalitySelf TestSelf Test Answers
Exam ObjectivesThe Automatic Workload RepositoryGathering AWR StatisticsManaging the AWRStatistics, Metrics, and BaselinesThe DBMS_WORKLOAD_REPOSITORY PackageThe Database Advisory FrameworkThe Automatic Database Diagnostic MonitorThe AdvisorsAutomatic Maintenance JobsUsing the Server-Generated Alert SystemAlert Condition Monitoring and NotificationsSetting ThresholdsThe Notification SystemTwo-Minute DrillUse and Manage the Automatic Workload RepositoryUse the Advisory FrameworkManage Alerts and ThresholdsSelf TestSelf Test Answers
Exam ObjectivesManaging MemoryPGA Memory ManagementSGA Memory ManagementAutomatic Memory ManagementThe Memory AdvisorsThe SQL Tuning AdvisorThe Capabilities of the SQL Tuning AdvisorUsing the SQL Tuning Advisor with Enterprise ManagerThe SQL Tuning Advisor API: the DBMS_SQLTUNE PackageThe SQL Access AdvisorUsing the SQL Access Advisor with Database ControlUsing the SQL Access Advisor with DBMS_ADVISORIdentifying and Fixing Invalid and Unusable ObjectsInvalid ObjectsUnusable IndexesDatabase ReplayDatabase Replay Workload CaptureDatabase Replay Workload PreprocessingLaunch the ReplayDatabase Replay Analysis and ReportingTwo-Minute DrillUse Automatic Memory ManagementUse Memory AdvisorsTroubleshoot Invalid and Unusable ObjectsImplement Automatic Memory ManagementManually Configure SGA ParametersConfigure Automatic PGA Memory ManagementUse the SQL Tuning AdvisorUse the SQL Access Advisor to Tune a WorkloadUnderstand Database ReplaySelf TestSelf Test Answers
Exam ObjectivesGlobalization Requirements and CapabilitiesCharacter SetsLanguage SupportTerritory SupportOther NLS SettingsUsing Globalization Support FeaturesChoosing a Character SetChanging Character SetsGlobalization Within the DatabaseGlobalization at the Instance LevelClient-Side Environment SettingsSession-Level Globalization SettingsStatement Globalization SettingsLanguages and Time ZonesLinguistic Sorting and SelectionThe Locale BuilderUsing Time ZonesTwo-Minute DrillCustomize Language-Dependent Behavior for the Database and Individual SessionsWork with Database and NLS Character SetsSelf TestSelf Test Answers
Exam ObjectivesThe Enterprise Manager Support WorkbenchThe Automatic Diagnostic Repository (ADR)Problems and IncidentsThe ADR Command-Line Interface (ADRCI)The Support WorkbenchPatchesTypes of PatchIntegration with MetaLink and the Patch AdvisorApplying PatchesTwo-Minute DrillUse the Enterprise Manager Support WorkbenchManage PatchesSet Up the Automatic Diagnostic RepositorySelf TestSelf Test Answers
Steps to Download MasterExamSystem RequirementsMasterExamHelpRemoving InstallationTechnical SupportLearnKey Technical Support

Overview

A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053

Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exams 1Z0-051, 1Z0-052, and 1Z0-053, including:

Instance management
Networking and storage
Security
SQL
Oracle Recovery Manager and Oracle Flashback
Oracle Automatic Storage Management
Resource manager
Oracle Scheduler
Automatic workload repository
Performance tuning
Three bonus exams available with free online registration

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.

Start your free trial

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

Publisher Resources

ISBN: 9780071629188

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

by John Watson, Roopesh Ramklass, Bob Bryla

Overview

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.

You might also like

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

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

OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)

Oracle Database 11g & MySQL 5.6 Developer Handbook

Publisher Resources

Overview

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.

You might also like

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

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

OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)

Oracle Database 11g & MySQL 5.6 Developer Handbook

Publisher Resources

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.