Database Administration UOS Past Paper 2019 IT-3441

Database Administration UOS Past Paper 2019 IT-3441

University of Sargodha

M.Sc. 4^th Term Examination 2019

Subject:  Information Technology                 Paper: Database Administration (IT-3441)

Time Allowed: 2:30 Hours                 Maximum Marks: 80

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

Objective Part                        (Compulsory)

Q.1.     Write short answers of the following in 2-3 lines each on your answer sheet.         (16*2)

i. What are Oracle Managed Files?

ii. Write the command to start the Listener Server Process.

iii. Write the SQL command to change the database’s default temporary teablespace to another temporary tablespace group named as TEMGRP.

iv. What is Oracle Enterprise Managed?

v. What is the advantage of operating in archivelog mode?

vi. How index works to find rows faster?

vii. Define Oracle Constraint?

viii. What is the smallest unit of storage in Oracle?

ix. What is an Oracle instance?

x. Differentiate between Shared Pool and Large Pool.

xi. What are the primary types of tablespace in Oracle?

xii. List any two of the system privileges for the administration.

xiii. Which Oracle utility is used for logical backup of a database?

xiv. What is SGA?

xv. Write SQL command to create a tablespace named “bo-02”.

xvi. What are major tasks of Database Administration?

Subjective Part           (3*16)

Q.2.     Write a note on different types of backup methods supported by RMAN.

Q.3.     Write the procedure to resize SmallfileTablespace using ALTER DATABASE.

Q.4.     Describe basic Oracle Net architecture.

Q.5.     Describe the method to move Online Redo Log Files with an example.

Q.6.     Write a note on Oracle background processes.