Database Administration (CSC424) — Notes, Syllabus & Past Questions

Skills for installation, configuration, and security management of databases.

Elective Course7 Chapters
Chapter 1Past Questions

Introduction

DBA Roles and Responsibilities; Database Architecture; ORACLE logical and physical database structure; Memory and Process Structure, SQLPLUS Overview, creating a database.

View Questions
Chapter 2Past Questions

Tablespace and Storage management

Working with Tablespaces and Data Files, Creating and adding tablespace and datafiles, Managing Control Files, Online Redo Logs and Archive logs; Multiplexing.

View Questions
Chapter 3Past Questions

Managing Database Objects

Working with Tables and Constraints; Working with Indexes, Views, Synonyms, and Sequences; Partitioning and Materialized Views, Introduction of PLSQL, Stored Procedure, Functions, Trigger, package.

View Questions
Chapter 4Past Questions

Database Backup, Restore, and Recovery

Backup and Recovery Overview, Database backup, restoration and recovery, defining a backup and recovery strategy, Backup and Recovery options, Data Dump, User-Managed Backup and Recovery.

View Questions
Chapter 5Past Questions

Database Security and Auditing

Database Security and Auditing, Database Authentication Methods, Database Authorization Methods, Data Encryption Techniques, Virtual Private Database, Managing Users and Security: Profiles.

View Questions
Chapter 6Past Questions

Multitenant Database Architecture

Understanding the Multitenant Architecture, Pluggable Architecture, Creating CDB, Administrating Root Container, Creating Pluggable Databases (PDBs) within a CDB, Administrating Pluggable Databases.

View Questions
Chapter 7Past Questions

Database Tuning

Tuning Application Design, Tuning Memory Usage, Tuning Data Access, Tuning Data Manipulation, Reducing Network Traffic, Using Automatic Workload Repository(AWR).

View Questions

Related Study Resources for Database Administration (CSC424)

Subject HubDatabase Administration (CSC424)Official CurriculumDatabase Administration SyllabusTU Board PapersDatabase Administration Past QuestionsSemester Directory7th Sem Subjects