Database Administration (CACS405) is a 3-credit subject in BCA 7th Semester at Tribhuvan University. Below you'll find notes, old question papers, and lab reports aligned with the TU BCA curriculum.
Course Code: CACS405 | Credits: 3 | Semester: 7 | Curriculum: BCA Curriculum 2018
Database administration, tuning, backup, and recovery.
This course provides the comprehensive knowledge about relational database management system in administrative approach to integrate in enterprise level of database in network environment which encompasses with oracle database Instances Management, database installment in network environment, implementing user role and privileges, multitenant database management, back and recovery.
The general objectives of this course are to provide core knowledge of administrative works on relational database management systems.
Overview of the Oracle Database Architecture (process, memory, storage structure), DBA roles and responsibilities, Familiar with SQL* Plus, Accepting Values at Runtime, Overview of SQL Command (DDL (Tables, Constraints, Indexes Views, Synonyms, Sequences Partitioning and Materialized Views), DML, Join and Subquery)
Oracle Database installation, Database creation, starting up and shutting down oracle instance, Oracle Network component, communicating between Databases; Using Dynamic Performance Views, Using the Automatic Diagnostic Repository (ADR), Using the Alert Log and Trace Files, Managing Initialization Parameter Files.
Working with Tablespaces and Data Files, Creating and adding tablespace and datafiles, Managing Control Files, Online Redo Logs and Archive logs; Multiplexing online redo logs and control files, database archiving.
Assigning Quotas to Users, Applying the Principle of Least Privilege, Creating and Assigning Profiles, Administering User Authentication Methods, Managing Oracle Database Users, Privileges, and Roles.
Overview of Network Configuration, Oracle Net Listener Configuration and Management, Oracle Net Naming Methods, Networking the Net Configuration Assistant, Configure Client Connections with Net Manager, View Listener Configuration, Start and Stop the Oracle Listener, Use TNSPING to Test Oracle Net Connectivity, connect to the Database, Configure Net Services with Enterprise Manager
Backup and Recovery Concepts, Database backup, restoration and recovery, defining a backup and recovery strategy, Backup and Recovery option; Data Dump; User-Managed Backup and Recovery; Configuring RMAN; RMAN Backups, Restore and Recovery, Perform CDB and PDB flashback.
Introduction to the Scheduler, Access Rights, Scheduler Components and Workflow, create a Job, Job Classes, Use Time Based, Event-Based Schedules, Create an Event-Based Schedule.
Laboratory works should be done covering all the topics listed above and a small work should be carried out using the concept learnt in each unit in the group. Work should be assigned on an individual basis.
The general teaching pedagogy includes class lectures, group discussions, case studies, guest lectures, research work, project work, assignments (theoretical and practical), and examinations (written and verbal), depending upon the nature of the topics. The teaching faculty will determine the choice of teaching pedagogy as per the need of the topics.