Videos

In this page, we have very short videos which give a overall broad summary of each topic:

Contents

DBA Roles and Responsibilities

After watching the video below, make a list of all the common tasks of a DBA. Please select one of them that you feel is the most important task and explain why you think so.

Tablespaces

After watching the video below, answer the following questions:  What is a tablespace? Can one datafile belong to more than one tablespace? What does tablespace contain? What is the benefit of having Temporary tablespaces? What does a SYSTEM tablespace contain? What are the two types of Tablespaces and where is the extent management information stored ?

Security

After watching the video below, please answer the following questions: What is Authentication and Authorization? What are the different ways of achieving them?

Backup