Database Administration and Management BS University Of Sargodha (UOS) 2021

University of Sargodha

Bs Sii Semester/Term Exam 2021

Paper: Database Administration and Manarement (1T-3441)

SubiectilL

Time Allowed: 02: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.

(2*

16)

i. - Ligatey awo responsibilities of'a DBA?

stadal.

Olhi are reverse key indexes?

-Differentiate between online and offline backup?

What are cache areas within the database block, baffer cache?

V.

vi.

vii.

viii.

ix.

x.

XL.

xil.

Xili.

xiN.

XV.

XVL.

-What are triggers in a database?

What is server parameter file?

- What is DUAL table?

ustadni.

- Write SOL command to resize a Bigfile tablespace dmarts. dbl 10 500 MB?

- Define segment segregation?

What is meant by read consistency?

ustadni.com

What it meant by rollback?

What is the purpose of Automatic Workload Repository?

What is the purpose of Java Pool?

-What is meant by Object Privileges in Oracle?

Name any two Oracle datatypes to store character data.

Name any two Oracle Installation Tablespaces.

Subjective Part

(3*16)

0.2. *

What is the purpose of listener.ora file? List the main parameters of listener.ora file. Also write

SQL commands to

(i) start the listener server process and

(il) show its status.

Q.3.

Q.4.

Discuss in detail about the Oracle Logical Database Structures.

Discuss the purpose of Automatic Workload Repository, Also write the steps that should be

performed to use Automatic SOL Tunning Advisor

Q.5.

What is the purpose of Database Resource Manager? How would you create a fesource plan using

CREATE_PLAN procedure?

0.6.

Write a note on Oracie background processes.

ustadni.com

ustadni.com

ustadni.com

ustadni.com