Blog
Database Administration & Management Past Paper 2023
University: University of Sargodha (UOS)
Program: MSc IT
Subject: Database Administration & Management (IT-3441)
Year: 2023
Time Allowed: 2 Hours 30 Minutes
Maximum Marks: 60
You can download the original PDF of this paper here: Download Database Administration & Management Past Paper 2023 (PDF)
Why Use This Past Paper?
This Database Administration & Management past paper helps MSc IT students understand Oracle-based database concepts, exam structure, and frequently asked questions.
- Understand Oracle DBA concepts
- Practice short conceptual questions
- Prepare long theoretical answers
- Improve exam confidence and time management
Database Administration & Management Past Paper 2023 (Complete Text)
University of Sargodha
MSc 4th Term Examination 2023Subject: IT
Paper: Database Administration & Management (IT-3441)
Time Allowed: 02:30 Hours
Maximum Marks: 60Note: Objective part is compulsory. Attempt any three questions from subjective part.
Objective Part (Compulsory)
Q.1 Write short answers of the following in 2–3 lines each. (2×12)
- Which type of tablespaces consists of only one datafile and can be used for any of three primary types of tablespaces?
- Write the SQL statement to resize the Bigfile tablespace named “dmarts” to one gigabyte.
- Which Oracle initialization parameter specifies the default block size?
- Which type of index is used for online transaction processing (OLTP) environment?
- Write SQL statement to create a view on CUST table called CUST_INFO that contains Customer_ID, Customer_Name, and Customer_Phone only.
- What are partitioned tables?
- What is the purpose of archive redo logs?
- Name any two object privileges.
- What is RMAN?
- Write the SQL statement to start the default listener.
- What is the purpose of LGWR?
- Name any two constraints that are supported in Oracle.
Subjective Part (Attempt any Three)
Q.2 Write a note on how undo tablespaces are managed by creating, dropping, and modifying undo tablespaces.
Q.3 Discuss how full database backup and incremental backup can be taken using RMAN.
Q.4 Describe how Oracle Net establishes network connections in shared server model.
Q.5 Discuss about the permanent, undo, and temporary tablespaces in detail.
Q.6 Why database files should be multiplexed? Discuss how control files and redo log files can be multiplexed manually.
Solved Short Questions (Objective Part)
1. What are Bigfile Tablespaces?
Bigfile tablespaces consist of a single large datafile that simplifies management of very large databases.
Reference: Oracle Docs
2. SQL to resize Bigfile tablespace
ALTER TABLESPACE dmarts RESIZE 1G;
Reference: Oracle SQL Reference
3. Default block size parameter
The DB_BLOCK_SIZE parameter specifies the default block size.
Reference: Oracle Reference
5. View creation SQL
CREATE VIEW CUST_INFO AS SELECT Customer_ID, Customer_Name, Customer_Phone FROM CUST;
Reference: SQL Views
6. Partitioned tables
Partitioned tables divide data into smaller, manageable pieces based on defined criteria.
Reference: Oracle Partitioning
7. Purpose of archive redo logs
They store transaction history for database recovery.
Reference: Oracle Redo Logs
11. Purpose of LGWR
LGWR writes redo entries from memory to redo log files.
Reference: Oracle Processes