Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

Tribhuwan University

Institute of Science and Technology

2081.1

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.
What are different database administration tasks? Explain Oracle Data Guard in brief.[10]
2.
What is initialization parameter file? Differentiate between Spfile and Pfile. Explain some oracle defined roles with suitable example.[10]
3.
What is Tablespace? What is UNDO RETENTION Policy? Write different commands to manage the tablespaces in Oracle.[10]
Section B

Short Answers Questions

Attempt any Eight questions.
[8*5=40]
4.
What is privilege? Write commands to create user, grant privilege, revoke privilege and drop user in oracle database. [5]
5.
What is Oracle AWR? How AWR report is viewed in oracle? [5]
6.
What is Data Pump? Explain the procedure of exporting and importing data using Oracle Data Pump. [5]
7.
Explain the concept of Container database and Portable database. [5]
8.
What is Job and Job classes? Create an event-based schedule in Oracle. [5]
9.
What is Extent? Explain Row chaining and Migration in brief. [5]
10.
What is Role? Create a Role called “general” and grant privileges to the role general and assign that role to a user in oracle. [5]
11.
Why do you think database auditing plays a significant role? Explain. [5]
12.
Write short notes on: a. Audit Trail b. SQL Tuning Advisor [5]