BIT · Semester VI
Database Administration syllabus
Official TU syllabus for Database Administration (BIT352): 10 units, 77 topics. Every unit links to its notes and solved questions.
1
Database Administration Fundamentals
3 Q- Definition and scope of database management system
- Roles and responsibilities of database administrator
- DBA tasks and activities
- Importance of database security and administration
2
Oracle Database Architecture
3 Q- Oracle database architecture overview
- Oracle background processes
- Memory structures and components
- Physical and logical structures
- Control files and contents
- Datafiles and tablespaces relationship
3
Database Startup, Shutdown and Initialization
2 Q- Database startup modes and commands
- Database shutdown modes and commands
- Initialization parameter files
- Spfile versus Pfile differentiation
- Oracle defined roles and their usage
4
Tablespace and Storage Management
6 Q- Tablespace concepts and types
- Datafile management and creation
- Adding new tablespaces and datafiles
- UNDO tablespace and UNDO RETENTION policy
- Viewing and altering UNDO RETENTION
- Space management and segment creation
- Extent and row chaining concepts
- Row migration in storage
5
Control Files and Multiplexing
1 Q- Control file definition and purpose
- Control file contents and structure
- Multiplexing control files
- Multiplexing using pfile procedures
6
User Security and Privilege Management
9 Q- User creation and management commands
- Privilege definition and importance
- System privileges and object privileges
- Grant privilege commands
- Revoke privilege commands
- Drop user commands
- Role definition and purpose
- Role creation and assignment
- Role in privilege management
- User profiles and profile assignment
7
Backup, Recovery and Data Protection
3 Q- Backup definition and necessity
- Types of database backup
- Cold backup procedures and commands
- Hot backup procedures
- Restore definition and procedures
- Recovery definition and processes
- Recovery with examples
- Oracle Data Guard concepts
- Data Guard importance and usage
8
Monitoring, Tuning and Performance
9 Q- Oracle AWR overview
- AWR report viewing procedures
- SQL tuning definition and process
- SQL Tuning Advisor usage
- Database performance tuning
- Locking levels in oracle
- Lock acquisition methods
- Database auditing concepts
- Standard auditing in oracle
- Audit trail definition
9
Job Scheduling and Automation
4 Q- Job scheduling in oracle database
- DBMS_SCHEDULER functionality
- Scheduler components
- Schedule definition and creation
- Job and job classes
- Program definition and relationship
- Event-based schedule creation
- Schedule, job and program relationships
10
Advanced Database Features and Tools
7 Q- SQL*PLUS definition and functionalities
- DBA functionalities in SQL*PLUS
- Oracle RAC concepts
- Oracle ASM concepts
- Oracle Data Pump overview
- Data Pump export procedures
- Data Pump import procedures
- Container database concepts
- Portable database concepts
- Oracle Net service components
- Listener definition and purpose
- Listener.ora file configuration
- Tnsnames.ora file configuration
Study BIT352 the smart way
Solved questions, flashcards & practice