Database Administration and Management Msc IT University Of Sargodha (UOS) 2023

Page |1

Database Administrator and Management (past paper 2023)

3062t

usta

University of Sargodha

M.Sc. 4'h Term Examination 2023

Paper: Database Administration & Management IT- 3441)

Maximum Marks: 60

vi.

vii.

vili.

1x.

x.

xi.

xii.

Subject: I.T

Time Allowed: 02:30 hours

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

ustadn

Objective Part -

(Compulsory)

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

(2*12)

Q.1.

i.

Which of type of tablespaces consists of only one datafile and can be used for any of three primary

types of tablespaces?

Write the SQL statement to resize the Bigfile tablespace named "dmarts" to one gigabyte.

ії.

ill.

iv.

V.

Which Oracle initialization parameter specifies the default block size?

Which type of index is used for online transaction processing (OLTP) environment?

Write SOL statement to create a view on CUST table called CUST_INFO that contains the columns

of Customer_ID, Customer_Name, and Customer_Phone only.

What are partitioned tables?

What is the purpose of archive redo logs?

Name any two of the object privileges.

What is RMAN?

Write the SQL statement to start the default listener.

What is the purpose of LGWR?

Name any two constraints that are supported in Oracie.

Q.2.

Subjective Part

(3*12)

Write a note on how undo tablespaces are managed by creating, dropping, and modifying undo

Q.3.

Q.4.

0.5.

0.6.

tablespaces.

Discuss how full database backup and incremental backup can be taken using RMAN.

Describe how Oracle Net establishes network connections in shared server model.

Discuss about the permanent, undo, and temporary tablespaces in detail.

Why database files should be multiplexed? Discuss how control files and redo log files can be

multiplexed manually.

ustadni.com

• LK-13-02-5488....

ustadni.com

ustadni.com

ustadni.com