OCA Oracle® Database 11g Administrator Certified Associate: Study Guide

Chapter 13. Managing Data and Undo

ORACLE DATABASE 11g: ADMINISTRATION I EXAM OBJECTIVES COVERED IN THIS CHAPTER:

• Managing Data and Concurrency

  • Manage data using DML

  • Identify and administer PL/SQL objects

  • Monitor and resolve locking conflicts

• Managing Undo Data

  • Overview of Undo

  • Transactions and undo data

  • Managing undo

Oracle supports manipulating data via several interfaces, but the most common are SQL and PL/SQL. Understanding how to use and manage PL/SQL programs is an important skill for any DBA. Some database functionality is delivered only as PL/SQL programs, such as fine-grained auditing, and other functionality is available in both a command-line ...