Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

Tribhuwan University

Institute of Science and Technology

2081

Bachelor Level / Third Year / Sixth Semester / Science

Bachelors in Information Technology (BIT352)

(Database Administration)

Full Marks: 60

Pass Marks: 24

Time: 3 Hours

Candidates are required to give their answers in their own words as for as practicable.

The figures in the margin indicate full marks.

Section A

Long Answers Questions

Attempt any TWO questions.
[2*10=20]
1.
Describe levels of locking in oracle. Discuss the methods used to acquire locks in oracle.[10]
2.
Explain architecture of oracle database with suitable diagram.[10]
3.
What is space management? How space management is done? How can you create tables without segments?[10]
Section B

Short Answers Questions

Attempt any Eight questions.
[8*5=40]
4.
What are the roles and responsibilities of Database Administrator? [5]
5.
What is tablespace and datafile in oracle? How can we add new tablespace and datafiles in oracle database? [5]
6.
What is privilege? Write commands to create user, grant privilege, revoke privilege and drop user in oracle database. [5]
7.
What is Oracle AWR? How AWR report is viewed in oracle? [5]
8.
What is Role? Explain its role in privilege management with suitable example. [5]
9.
What is SQL Tuning? Explain SQL Tuning Process in Oracle? [5]
10.
What is user profile? Create a simple user profile and assign the profile to new user in oracle. [5]
11.
What is listener? Explain about listener.ora and tnsnames.ora file in oracle database. [5]
12.
How event based schedules are created? Explain. [5]