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

Sample 2

This document is a sample paper for the Database Administration and Management course at the University of the Punjab, designed 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 Object-Oriented Databases, Transaction Processing, Integrity Constraints, and various database management techniques. The paper assesses students' understanding of database concepts, storage hierarchy, concurrency control, and network configuration in Oracle databases.

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
40 views1 page

Sample 2

This document is a sample paper for the Database Administration and Management course at the University of the Punjab, designed 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 Object-Oriented Databases, Transaction Processing, Integrity Constraints, and various database management techniques. The paper assesses students' understanding of database concepts, storage hierarchy, concurrency control, and network configuration in Oracle databases.

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 are Object-Oriented Databases, and how do they differ from relational
databases?
2. Explain the concept of Storage Structures in a database.
3. Define Transaction Processing and its role in database systems.
4. What are the different types of Integrity Constraints in a database?
5. Explain Multiplexing of Control Files in Oracle.
6. What is the purpose of Undo Data in transaction management?
7. Differentiate between Dedicated Server Process and Shared Server Process.
8. What are User-Managed Backups, and how are they performed?
9. Explain the role of Indexes in query performance optimization.
10. What are the emerging research trends in database systems?

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

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

1. (a) Explain the concept of Database Storage Hierarchy with examples.


(b) How do Datafiles and Tablespaces interact in Oracle Database Management?
2. (a) Describe different Concurrency Control Techniques used in database
transactions.
(b) Explain how Recovery Techniques are implemented to maintain database
consistency.
3. (a) Discuss Network Configuration in Oracle Database. How are Listener and
Session Configurations managed?
(b) What is the difference between System Privileges and Roles? How can a DBA
assign and revoke privileges?

You might also like