Overview/Description
recognize the steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators
Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
recognize the steps for managing undo operations in Oracle Database 11g to allow users to roll back transactions.
recognize the requirements and best practices for implementing database security according to international and regional laws.
recognize the steps for enabling, specifying, maintaining, and reviewing database auditing.
recognize the process for obtaining and applying Critical Patch Updates (CPUs).
configure an Oracle Database 11g database to support retention and implement database security in a given scenario.
recognize the steps for managing and gathering optimizer statistics.
identify the steps for managing Automatic Workload Repository (AWR) statistics, using the Automatic Database Diagnostic Monitor (ADDM), and utilizing advisors.
identify the steps for viewing and configuring automated tasks and setting alert thresholds.