Database Administration and Management/Information Management/Management BS 1/5 Semester/Term UOS — University of Sargodha 2026

Discussion

Ask a question about this paper, or help someone else with theirs. Answers are emailed to whoever asked.

No questions yet — be the first to ask.

See all

Subject: L.T

University of Sargodha

BS 1" Semester (5" Intake) Examination 2026

Paper: DB Administration & Management (ITDC-6201)

Maximum Marks: 40

Time Allowed: 2:30 Hours

Note: Objective Part is compulsory. Attempt any three Questions from subjective part.

Objective Part (Compulsory)

Q.1. Write short answers of the following in 2-3 lines each on your answer sheet.

i. Name two background processes in Oracle.

ii. Mention the two main components of the Oracle architecture.

ili.

What is the Data Dictionary?

iv.

What is the purpose of a control file?

What are locks used for?

VI.

Define latch in Oracle.

vii. Why is monitoring index usage important?

viii. Which SQL command grants privileges to a user?

Subjective Part (3*8)

Q.2. Discuss the functions of the PFILE and SPFILE in Oracle instance configuration, highlighting

their differences and significance in database startup.

Q.3. Discuss the structure and components of Oracle Net architecture, including their functions in

establishing, maintaining, and managing network connections.

Q.4: Discuss the architecture of the Oracle Shared Server, detailing the functions and interactions of

its core components.

Q.5.

Q.6:

Describe methods for sizing the shared pool and buffer cache effectively.

Explain the role of the Oracle Net Listener in database connectivity. Discuss the common

listener issues that may occur and the methods used to diagnose and fix them.

ustadni.co

-LK-9097-/28-08-2026----(S-26.)-

ustadni.com