Learn Bench


Introduction

  • Oracle Database 10g Express Edition (Oracle Database XE) is an
  • entry-level,
  • small-footprint database based on the Oracle Database 10g Release 2 code base that's free
  • to develop,
  • deploy,
  • and distribute;
  • fast to download;
  • and simple to administer
  • The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.

Objectives

  • Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to
  • develop,
  • deploy,
  • and distribute;
  • fast to download;
  • and simple to administer
    Architecture
  • Oracle Architecture
  • Instance architecture
  • Install software
  • Configure
  • Managing Instance
  • Enterprise Manager
  • SQL*Plus and iSQL*Plus
  • Stages of database startup
  • Database shutdown options
  • Database Structures
  • Create tablespaces
  • Manage tablespaces
  • Obtain tablespace
  • User Security
  • Create and manage roles
  • Grant and revoke privileges
  • Create and manage profiles
  • Create and modify tables
  • Constraints
  • Dropping and truncating
  • Create and use B-Tree and Bitmap
  • Implementing Oracle Database Security
  • Audit database activity
  • Implement Fine-Grained Auditing
    Managing Data and Concurrency
  • Identify and administer PL/SQL objects
  • Describe triggers
  • Levels of locking
  • Lock conflict
  • Monitor and resolve
  • Managing Undo Data
  • Monitor and administer undo
  • Configure undo retention
  • Size the undo tablespace
  • Performing Database Backup
  • Create consistent database backups
  • Back uP
  • Create incremental backups
  • Automate database backups
  • Backup a control file to trace
  • Monitor flash recovery area
  • Database Recovery
  • Control file
  • Redo log file
  • System-critical data file
  • Non system-critical data file





Certification also in






May i help u

 
Live Chat
We're with you 24/7

new products