[go: up one dir, main page]
Scribd
Upload
15 views1 page

Sample 1

This document is a sample paper for the B.S. 4 Years Program in Database Administration and Management at the University of the Punjab. It includes short questions worth 30 marks and long questions worth 30 marks, covering topics such as database models, ACID properties, database security, and the role of a Database Administrator. The paper emphasizes both theoretical concepts and practical applications in database management.

Uploaded by

Enzy boy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views1 page

Sample 1

This document is a sample paper for the B.S. 4 Years Program in Database Administration and Management at the University of the Punjab. It includes short questions worth 30 marks and long questions worth 30 marks, covering topics such as database models, ACID properties, database security, and the role of a Database Administrator. The paper emphasizes both theoretical concepts and practical applications in database management.

Uploaded by

Enzy boy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

UNIVERSITY OF THE PUNJAB

B.S. 4 Years Program: Seventh Semester


Sample Paper - Database Administration and management
Time: 3 Hrs.
Marks: 60
Course Code: DI-324

Q.1: Answer the following short questions. (10x3=30 Marks)

(Each question carries 3 marks, answer briefly.)

1. What is the difference between Object Relational and Object-Oriented Database


Models?
2. Explain the concept of File Organization in Databases. Name two types.
3. What is ACID property in Transaction Processing?
4. Define Concurrency Control and explain its importance in databases.
5. What are Dynamic Performance Views in Oracle?
6. Explain the purpose of Redo Log Files in database recovery.
7. What is the difference between System Privileges and Object Privileges in database
security?
8. Define Database Tuning and mention two techniques for performance optimization.
9. What is the role of Database Administrator (DBA) in Enterprise Database Systems?
10. Explain the concept of Distributed Database Systems.

Q.2: Answer the following long questions. (3x10=30 Marks)

(Each question carries 10 marks, answer in detail.)

1. (a) Explain the Architecture of Oracle Database with a labeled diagram.


(b) Discuss the responsibilities of a Database Administrator (DBA) in managing a
database system.
2. (a) Explain the Backup and Recovery Strategies in database management. Discuss
different types of failures that require recovery.
(b) What is Archive Log Mode? How does switching to archive log mode help in
database recovery?
3. (a) What is Query Optimization? Explain different query processing techniques to
improve database performance.
(b) Describe the Import/Export Mechanism in database management. What are the
different export and import modes?

You might also like