Database Administration and Management BS 5 Semester/Term University Of Sargodha (UOS) 2026

Nae Pb

{s compulsory:

a a where needed)

University of Sargodha

BS 1% Semester (5th Intake) Examination 2026

Subject: BS.IT paper: Database Administration & Management (ITDC-6201)

Time Allowed: 2:30 Hours Maximum Marks: 40

Note: Objective Part is Compulsory. Attempt any three Question form Subjective Part.

Objective Part (Compulsory)

Q.1. Write short answers of the following in 2-3 lines each on your answer sheet. ~~ (2*8)

i. Define Oracle Enterprise Manager

ii. What is Oracle Instance?

iii. Whatis SPFILE?

iv. Mention one function of the Data Dictionary.

v. What is a rollback segment?

vi. What is a tablespace in Oracle?

vik Define instance recovery.

{ cL Define the role of Oracle Managed File:

Subjective Part (3*8)

Q.2. Discuss the functions and significance of background processes in managing

and maintaining Oracle Database operations.

Q.3. Explain the function and configuration of the listener process in Oracle

networking.

Q4. Explain the procedure for configuring Oracle Database in archive log mode and

describe its importance for data recovery.

Q.5. Explain the concepts of PCTFREE and PCTUSED and their impact on space

management.

Q.6. Explain the methods employed to prevent dynamic allocation in Oracle storage

and describe how they contribute 10 efficient database performance.

—LK-9097/22-04-2026-(F-25)--—-—--mmm-meoeeee

AoW

0 . 0

ACN C

a } ustadni.com