DBAM Past Paper 2025 BSCS UOS

DBAM – Database Administration & Management Past Paper 2025 – BSCS 7th Semester University of Sargodha

Are you a BSCS 7th Semester student at the University of Sargodha preparing for your Database Administration & Management (CSEC-409) exam? This post brings you the official past paper from the 2025 examination, offering valuable insights into the types of questions asked and the format of the paper.

Exam Details:

• Subject: Computer Science
• Course: Database Administration & Management (CSEC-409)
• Semester: BS 7th Semester Examination 2025
• Time Allowed: 02:30 Hours
• Maximum Marks: 60

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

Objective Part (Compulsory) – (2*12 = 24 Marks)

1. Write short answers of the following in 2-3 lines each on your answer sheet:
   1. What is the purpose of control files in Oracle?
   2. How are redo log files managed in Oracle databases?
   3. Define a tablespace in Oracle.
   4. What are the main operations you can perform on tablespaces?
   5. Explain the role of data files in Oracle.
   6. What are Undo Data Statistics in Oracle?
   7. What is the purpose of Indexes in Oracle?
   8. How do you maintain data integrity using constraints in Oracle?
   9. Difference between Oracle Net Manager and Oracle Enterprise Manager.
   10. Explain Oracle Memory Structures.
   11. Describe the host naming and local naming methods in Oracle Net.
   12. What is the purpose of Oracle Net Assistant?

Subjective Part (3*12 = 36 Marks)

2. Explain the startup and shutdown sequence of an Oracle database. What are the different stages, and how does the alert log file assist a DBA during this process?
3. Describe the architectural components of an Oracle server. What are the major responsibilities of the Oracle Instance in this architecture?
4. Differentiate between system privileges and object privileges with example of each.
5. Compare and contrast the roles of user processes, server processes, and background processes in Oracle architecture.
6. Discuss backup and recovery strategies in Oracle, including instance and media recovery and configuration of archive log mode.

This past paper is an excellent resource for students to understand the exam pattern, important topics, and the level of detail required in answers. Good luck with your preparations!