Home /University Of Sargodha (UOS) /Database Administration and Management

Database Administration and Management BS/MPhil Computer Science/MS Computer Science University Of Sargodha (UOS) 2023

Discussion

Ask a question about this paper, or help someone else with theirs. Answers are emailed to whoever asked.

No questions yet — be the first to ask.

More Database Administration and Management papers

See all

Database Administration and Management/Information Management/Management BS 1/5 Semester/Term UOS — University of Sargodha 2026 UOS — University of Sargodha · BS Uploaded 18 days ago Download ↓

Database Administration and Management BS 5 Semester/Term University Of Sargodha (UOS) 2026 University Of Sargodha (UOS) · BS Uploaded 3 months ago Download ↓

Database Administration and Management BSIT University Of Sargodha (UOS) 2025

Database Administration and Management BSIT University Of Sargodha (UOS) 2026 University Of Sargodha (UOS) · BSIT Uploaded 8 months ago Download ↓

Database Administration and Management Msc IT 4 Semester/Term University Of Sargodha (UOS) 2025 University Of Sargodha (UOS) · Msc IT Uploaded 8 months ago Download ↓

Database Administration and Management MPhil Information Technology/MS Information Technology/MSc Information Technology 4 Semester/Term University Of Sargodha (UOS) 2024 University Of Sargodha (UOS) · MPhil Information Technology Uploaded 1 year ago Download ↓

Database Administration and Management Msc IT University Of Sargodha (UOS) 2023 University Of Sargodha (UOS) · Msc IT Uploaded 1 year ago Download ↓

Paper text

ustadni.

Subject: Computer Science

Time Allowed: 2:30 Hours

University of Sargodha

BS 71* Term Examination 2023

29176

Paper: Database Administration and Management (CSEC-409)

Maximum Marks: 80

Note: Objective part is compulsory. Attempt any three questions from subjective part.

Objective Part

(Compulsory)

Write short answers of the following in 2-3 lines each on your answer sheet.

Define the Data Dictionary Cache in Oracle,

What is the Large Pool used for in Oracle?

Differentiate between User Process and Server Process in Oracle.

iv.

vi.

vii.

vili.

ix.

xi.

Xii.

xii.

XIV.

XV.

xvi.

What are Background Processes in Oracle?

What is the purpose of the Parameter File in Oracle?

How do you create an SPFILE in Oracle?

What is the role of Control Files and Redo Log Files in Oracle?

How do you manage table spaces in Oracle?

What operations can be performed with table spaces in Oracle?

Explain the concept of Data File Management in Oracle.

Define Segments and Blocks in Oracle.

How do you manage Undo Data in Oracle?

What is the significance of managing privileges in Oracle?

Explain the Oracle Net Architecture.

Name two types of networks in Oracle.

What are Oracle Shared Server and Connection Manager used for?

(2*16)

ustadni.com

Subjective Part

(3"16)

Q.2.

Q.3.

Q.4.

Q.5.

Q.6.

Describe the process of installing Oracle, including the installation steps and configuration options

Explain the role and functioning of Oracle Server and Oracle Instance.

Explain the startup and shutdown procedures for an Oracle database, including the role of the aler

log file and background trace files.

Discuss the process of creating a database and data dictionary in Oracle.

Discuss backup and recovery strategies in Oracle, including instance and media recovery an

configuration of archive log mode.

-- LK-4901/20-07-23

ustadni.com