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

Sample 5

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 on key topics such as the responsibilities of a Database Administrator, Oracle Instance, and backup techniques, as well as detailed questions requiring in-depth explanations of Oracle architectural components and recovery processes. The paper is structured to assess both brief knowledge and comprehensive understanding of database management concepts.

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

Sample 5

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 on key topics such as the responsibilities of a Database Administrator, Oracle Instance, and backup techniques, as well as detailed questions requiring in-depth explanations of Oracle architectural components and recovery processes. The paper is structured to assess both brief knowledge and comprehensive understanding of database management concepts.

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 the main responsibilities of a Database Administrator (DBA)?


2. Explain Oracle Instance and its components.
3. What is the role of Data Dictionary in a database?
4. Define Redo Log Files and explain their significance in database recovery.
5. What are Tablespaces, and how are they managed in Oracle?
6. Explain Automatic Undo Management and its importance.
7. What are the different types of Indexes in Oracle?
8. Differentiate between System Privileges and Object Privileges.
9. Explain the role of Oracle Shared Server and Dedicated Server processes.
10. What is Archive Log Mode, and why is it important for database recovery?

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

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

1. (a) Explain the Oracle Architectural Components with a well-labeled diagram.


(b) How does the multiplexing of Control Files enhance database reliability?
2. (a) Discuss the different Backup and Recovery techniques used in Oracle.
(b) Explain the step-by-step process of User-Managed Complete and Incomplete
Recovery.
3. (a) Describe the Import/Export utility in Oracle. Explain different export and
import modes.
(b) What are Types of Constraints in Oracle databases? How are they managed
effectively?

You might also like