Scroll to top button

Oracle Database 11g: Administration I - OCA

ISBN : 9781616911898

The Oracle Certified Associate (OCA) credential is the first step toward achieving the Oracle Certified Professional (OCP) certification. OCA shows that you have the fundamental knowledge and skills to support an Oracle Database 12c database. It is required part to the certification and is a core exam for Oracle Database 11g Administrator Certified Professional and Oracle Database 11g Administrator Certified Master.

Certification is proof of your knowledge and shows that you have the skills required to support Oracle core products. The Oracle certification program can help a company identify proven performers who have demonstrated their skills and who can support the company's investment in Oracle technology. It demonstrates that you have a solid understanding of your job role and the Oracle products used in that role.

Lessons
Lessons
10+
Exercises
770+
Quizzes
464+
Flashcards
214+
Glossary of terms
214+
TestPrep
Pre Assessment Questions
15+
Full Length Tests
14+
Post Assessment Questions
55+

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
48+
Minutes
27+
  • Overview
  • Oracle Database Fundamentals
  • Relational Databases
  • Oracle Database 11g Objects
  • Interacting with Oracle 11g
  • Oracle 11g Architecture
  • User Processes
  • The Oracle Instance
  • Oracle Storage Structures
  • Installing Oracle 11g
  • Review the Documentation
  • Review the System Requirements
  • Plan Your Install
  • Using the Oracle Universal Installer
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Using DBCA to Create Oracle 11g Databases
  • Working with Oracle 11g Metadata
  • Managing Initialization-Parameter Files
  • Starting Up and Shutting Down an Oracle Instance
  • Monitoring the Database Alert Log
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Tablespaces and Data Files Overview
  • Managing Tablespaces
  • Managing Data Files
  • Working with Schema Objects
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Introducing Network Configurations
  • An Overview of Oracle Net Features
  • Configuring Oracle Net on the Server
  • Configuring Oracle Net for the Client
  • An Overview of Oracle Shared Server
  • Oracle Shared Server Infrastructure
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Creating and Managing User Accounts
  • Granting and Revoking Privileges
  • Controlling Resource Usage by Users
  • Auditing Database Activity
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Manipulating Data through SQL
  • Identifying PL/SQL Objects
  • Monitoring Locks and Resolving Lock Conflicts
  • Leveraging Undo Management
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Proactive Database Maintenance
  • Managing Performance
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Understanding and Configuring Recovery Components
  • Performing Backups
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Understanding Types of Database Failure
  • Performing Recovery Operations
  • Summary
  • Exam Essentials
  • Review Questions
  • Overview
  • Understanding Data Pump
  • Loading Data with SQL*Loader
  • Populating External Tables
  • Using EM Support Workbench
  • Using EM to Manage Patches
  • Summary
  • Exam Essentials
  • Review Questions
×