Course Details

Previous Page


Oracle Database 11g Release 2: Storage Structures and User Security


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number



Overview/Description
An Oracle database is divided into logical storage units called tablespaces. Oracle also provides Oracle-Managed Files (OMF), which eliminate the need for the DBA to directly manage the operating system files in the Oracle database. To access the database, a user must specify a valid database user account and successfully authenticate as required by that user account. What the user can execute once they are logged in is controlled by privileges granted to them, which can be system or object. Privileges can be better controlled by using roles and profiles, which control resource consumption and account status and passwords.This course describes the purpose and functions of tablespaces, and provides details on how to create and manage database user accounts. It also discusses creating privileges, roles, and profiles, as well as using the password file and assigning quotas to users. 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).

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g Release 2: Storage Structures and User Security

  • recognize how table data is stored
  • create a new tablespace
  • manage the storage of information in a database
  • create and authenticate database user accounts
  • grant and manage privileges
  • create and manage roles
  • implement user profiles and user security
  • create a new tablespace
  • create and configure profiles
  • create a role
  • Course Number:
    od_odas_a04_it_enus