Database Administration and Management M.Sc. 4 Semester/Term UOS — University of Sargodha 2017

University of Sargodha

M.Sc. 4th Term Examination 2017

Subject: Information Technology

Paper: Data Base Administration (IT-3441)

Time Allowed: 2.30 Hours

Maximum Marks: 80

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

Objective Part (Compulsory)

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

i. Oracle server:

ii. Oracle instance:

iii. Global Area (SGA)

iv. background processes

v. Backup Compression

vi. Flash Recovery Area

vii. Validating Backups

viii. Recovery Operations

ix. Define different types of Data Encryption Standard?

x. Define system privileges and object privileges?

xi. Difference between SMON and PMON?

xii. What is Database object Metadata?

xiii. What is DATA BLOCK?

xiv. Define control file and redo file?

xv. How we maintain Data Integrity?

xvi. What is DATA PUMP?

Subjective Part (4*12=48)

Q. No.2. Explain different administration tools available in oracle 11 g.

Q. No.3. What is optimal flexible Architecture (OFA). Elaborate with an example?

Q. No.4. Write Steps for creating a database from template with Database configuration Assistant?

Q. No.5. Graphically draw the difference between manual and automatic Storage Management?

Q. No.6. Explain Backgrounds Process with its types?

Q. No.7. What is Data Block? Write the steps for moving data file with ALTER DATABASE & ALTER TABLESPACE