DBAM - Database Administration & Management, Past Papers

Database Administration & Management Past Paper 2026

Posted by
0
Database Administration and Management Past Paper 2026 BS IT University of Sargodha

Database Administration & Management Past Paper 2026 – BS IT | University of Sargodha (UOS)

University: University of Sargodha (UOS)
Program: BS IT (8th / 4th Semester – 5th Intake)
Subject: Information Technology
Paper: Database Administration & Management
Paper Code: ITCC-406 / ITCC-4450
Year: 2026
Time Allowed: 2 Hours 30 Minutes
Maximum Marks: 40

Why Use This Database Administration Past Paper?

This past paper helps students understand database administration concepts, Oracle architecture, recovery mechanisms, and security-related questions frequently asked in BS IT exams.

  • Understand Oracle database architecture
  • Practice DBA-level short questions
  • Prepare long theoretical answers
  • Improve command and syntax understanding

Database Administration & Management Past Paper 2026 (Complete Text)

Objective part is compulsory. Attempt any three questions from the subjective part.

Objective Part (Compulsory)

Q.1 Write short answers of the following in 2–3 lines each. (2×8)

  1. What is the purpose of a control file in Oracle?
  2. Explain the concept of a System Global Area (SGA).
  3. What is an SPFILE and how is it different from a PFILE?
  4. Describe the role of the SMON process in Oracle.
  5. What is a Program Global Area (PGA) and how does it differ from the SGA?
  6. Write a query to create a bitmap index on a table column.
  7. Explain the use of Oracle Managed Files (OMF).
  8. What are Archived Redo Logs and why are they important for recovery?

Subjective Part (Attempt Any Three)

Q.2 What is recovery? Write steps for recovering instance, data file, and control file.

Q.3 What are different ways of space management in table spaces?

Q.4 Differentiate between system privileges and object privileges with example of each.

Q.5 What are initialization parameters? Differentiate between static and dynamic parameters with example of each.

Q.6 Explain Oracle physical storage structure with examples.

Solved Short Questions (Objective)

1. Purpose of a control file in Oracle

A control file stores metadata about the database including database name, file locations, and checkpoint information required for database startup and recovery.

Reference: Oracle Docs

2. System Global Area (SGA)

SGA is a shared memory region that stores database data and control information used by Oracle processes.

Reference: Oracle Memory Structures

3. SPFILE vs PFILE

SPFILE is a binary server-managed parameter file, while PFILE is a text-based, client-managed initialization file.

Reference: Oracle Initialization Parameters

4. Role of SMON process

SMON performs system monitoring tasks such as instance recovery and cleanup of temporary segments.

Reference: Oracle Background Processes

5. PGA vs SGA

PGA is private memory for each server process, while SGA is shared memory accessible by all processes.

Reference: IBM Docs

6. Bitmap index query

A bitmap index is created using: CREATE BITMAP INDEX index_name ON table_name(column_name);

Reference: Oracle SQL Reference

7. Oracle Managed Files (OMF)

OMF allows Oracle to automatically manage database file naming and storage, reducing administrative overhead.

Reference: Oracle Storage Management

8. Archived Redo Logs

Archived redo logs store transaction history and are essential for database recovery and point-in-time restoration.

Reference: Oracle Backup & Recovery

Download Database Administration Past Paper (PDF)

Download Database Administration & Management Past Paper 2026 (PDF)

Related Past Papers

More BS IT database and system papers will be added soon.

Newer
Database Administration & Management Past Paper 2024 – BS IT | UOS
Back to list
Older Cyber Security Past Paper 2026 – BS IT | University of Sargodha (UOS)