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

Sample 4

This document is a sample paper for the Database Administration and Management course at the University of the Punjab, specifically for the seventh semester of a 4-year B.S. program. It includes short answer questions worth 30 marks and long answer questions worth 30 marks, covering topics such as data consistency, query processing, database recovery methods, and database security. The paper is structured to assess students' understanding of 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
21 views1 page

Sample 4

This document is a sample paper for the Database Administration and Management course at the University of the Punjab, specifically for the seventh semester of a 4-year B.S. program. It includes short answer questions worth 30 marks and long answer questions worth 30 marks, covering topics such as data consistency, query processing, database recovery methods, and database security. The paper is structured to assess students' understanding of 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 Data Consistency and how is it maintained in databases?


2. Explain Phases of Query Processing in databases.
3. What are Log-Based Recovery Methods?
4. Define Checkpoints and their role in database recovery.
5. What is Shadow Paging in database recovery techniques?
6. Explain the concept of Two-Tier and Three-Tier Database Architecture.
7. What is the purpose of Data Dictionary in database management?
8. Differentiate between Logical and Physical Database Design.
9. What are the major challenges in Distributed Database Systems?
10. Explain Database Locking Mechanisms and their importance.

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

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

1. (a) Describe the Transaction Processing System with a well-labeled diagram.


(b) Explain Different Types of Database Failures and their recovery techniques.
2. (a) Discuss the Storage Hierarchy in Database Management Systems.
(b) How does Query Optimization enhance database performance? Explain different
optimization techniques.
3. (a) Explain the concept of Database Security. What are different methods to ensure
security in databases?
(b) Discuss the importance of Physical Database Design and Tuning for
performance improvement.

You might also like