Database Administration and Management MPhil Information Technology/MS Information Technology/MSc Information Technology 4 Semester/Term University Of Sargodha (UOS) 2024

Subject: Information Technology

Time Allowed: 02:30 Hours

University of Sargodha

M.Sc. 4"' Term Examination 2024

Paper: Database Administration & Management (IT-3441)

Maximum Marks: 60

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

dni.com

Q.1.

Objective Part

(Compulsory)

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

1.

What is SPFILE?

Write a query for creating a reverse key index.

iii

V

Difference between Oracle Net Manager and Oracle Enterprise Manager.

Oracle Memory Structures.

System Global Area.

Program Global Area.

vi

Define SMON.

Describe Oracle Managed Files (OMF)

Views.

X

Schemas.

User Profiles.

Xiiv

Archived Redo Logs.

(2*12)

Subjective Part

(3*12)

Q.2.

0.3.

Q.4.

09.5.

Q.6.

What are different naming methods available in oracle net?

What are different ways of space management in table spaces?

Differentiate between system privileges and object privileges with example of each.

What is database schema? Explain different Schema objects in oracle databases.

What are different stages of starting and shutting down oracle database?

ustadni.co

ustadni.com

LK-5488/15-01-24 -

dni.com

ustadni.com