Information Technology BS 5/4 Semester/Term University Of Sargodha (UOS) 2024

Discussion

Ask a question about this paper, or help someone else with theirs. Answers are emailed to whoever asked.

No questions yet — be the first to ask.

University of Sargodha

Subject:

BS gt/5t" Intake (4") Term Exam 2024

Paper:

Information Technology

Time Allowed: 02:30 Hours

Database Administration & Management (ITCC-406/ITCC-4450)

Maximum Marks: 40

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

con

Objective Part

(Compulsory)

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

What are Undo Data Statistics in Oracle?.-

(2*8)

How do you manage tables and users in Oracle?

vi.

vii.

Explain Oracle Memory Structures.

Ditference between Oracle Not Manager and Oracle Enterprise Manages adini.COM

What is the purpose of Indexes in Oracle?

How do you maintain data integrity using constraints in Oracle?

vili.

What is System Global Area?

Elaborate Program Global Area.

2.2.

Q.3.

Q.4.

Q.5.

Q.6.

Subjective Part

(3*8)

What are Initialization Parameters? Differentiate between static and dynamic parameters with

example of each.

Explain the role and functioning of Oracle Server and Oracle Instance.

Differentiate between system privileges and object privileges with example of each.

What is database schema? Explain different Schema objects in oracle databases.

Discuss backup and recovery strategies in Oracle, including instance and media recovery and

configuration of archive log mode.

- LK-6448/23-12-24

ustadni.com