Database Administration and Management BS/MPhil Information Technology/MS Information Technology 5 Semester/Term University Of Sargodha (UOS) 2021

University of Sargodha

29/79

BS 5 Semester/Term Exam 2021

Subject: Information Technology

Paper: Database Administration and Management (IT-3441)

Maximum Marks: 80

Time Allowed; 02:30 Hours

ant-

U Soles

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

Objective Part dO

(Compulsory)

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

i What is the purpose of undo tablespace?

ii. What do you know about Oracle's Backup Compression?

ill.

Write the command to backup the full database using RMAN,

(2*16)

ustadni.com

iv.

Differentiate between shared and dedicated server process?

V.

What are bitmap indexes?

vi.

Differentiate between SYS and SYSDBA?

vii.

What is the purpose of Oracle Sequences?

vili.

What is the purpose of Redo Log Buffer?

ix.

Name any two Oracle Initialization Parameters.

x.

What is the purpose of SGA_TARGET initialization parameter?

xi.

Which initialization parameter specifies the default block size for the database?

xii.

What is the purpose of grant and revoke commands?

xiil.

What is meant by System Privileges in Oracle?

xiv.

Write SQL command to connect to database as sysdba.

XV.

What is the purpose of AUTOEXTEND attribute while creating a tablespace?

xvi. Oracle's Automatic SQL Tuning Advisor is used for?

Subjective Part

(3*16)

Q.2. Which utility is used to control the Listener Server Process? Discuss it main commands and how

they are used.

Q.3.

Q.4.

Discuss about Oracle Physical Storage Structures and also draw its diagram.

Describe the use of ASM Disk Groups. Write the steps to move Datafiles with alter database

method.

0.5. Write a note on Resource Management and Stored Outlines in Oracle.

Q.6.

What is database backup? Discuss in detail about the full database backups and incremental

backups.

ustad

ustadni.com

ustadni.com