• Online, Self-Paced
Course Description

Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented automatically, which can sometimes cause lock conflicts. Lock conflicts can be detected and managed through Enterprise Manager or SQL statements. Managing undo data and implementing Oracle Database security are also important DBA roles. Data is manipulated using DML, and undo data exists as a copy of the original, premodified data and is captured for every transaction that changes data. Security requirements have been a matter of individual concern until recently, but now there are a variety of laws enforcing the privacy and accuracy of data. This course discusses the locking mechanism in Oracle and how to resolve lock conflicts and deadlocks. It also discusses how to manage undo data, and how to implement database auditing and maintain the audit trail. This course is one of a series in the Skillsoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).

Learning Objectives

Data Concurrency and Undo Data

  • manage locks and data concurrency
  • manage undo data operations to allow users to roll back transactions

 

Oracle Database Auditing

  • recognize how auditing is used to secure a database
  • enable and review audit information and maintain the audit trail
  • resolve lock conflicts
  • undo data in a database
  • configure database auditing

 

Framework Connections