Management Msc IT 4 Semester/Term University Of Sargodha (UOS) 2021

Page 1 of 15

DBA MIT 2021

ustadni.c

Q.2.

Q.3.

0.4.

0.5.

Subject: IT

Time Allowed: 2:30 Hours

University of Sargodha

M.Sc 4" Term/Semester Exam 2021

Paper: Dershase Administration & Management IT-3441)

Maximum Marks: 80

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

ustadni.

Q.1.

Objective Part

(Compulsory)

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

(2*16)

i. Name any two of the primary types of tablespaces in an Oracle database?

il. Write the SQL statement to resize the "USERS" tablespace to 15MB.

iii.

Differentiate between Oracle database and Oracle instance.

iV.

Which data structure is used to store the values of a unique index?

v. Write SQL statement to create a view on EMP table called EMP_ INFO that contains the

columns of Employee_Number, First_Name, and Last Name only.

vi.

What is PL/SQL?

vil.

What is flashback query?

vill.

What is the purpose of DB Wn?

ix.

Differentiate between segments and extents.

x.

Which initialization parameter specifies the default block size?

xi. How index is able to find rows faster?

XiL.

What is a disk group?

xiii.

Name the standard tool for physical backups in Oracle?

XIV.

Write the commands needed to start a database in ARCHIVELOG mode

XY.

What is the impact of fragmentation on the database performance?

xVi.

Name any two types of Oracle segments?

Subjective Part

(16*3)

How online backups are implemented? Write the steps to perform an online database backup.

Write a note on automatic storage management in Oracle.

Describe basic Oracle Net architecture.

Briefly describe the bigfile, SYSTEM, SYSAUX, and TEMP tablespaces

What is the purpose of Oracle initialization parameters? How they are stored? Briefly discuss any

ustadhi.com

ustadni.com

ustadni.com