BIT 6th Semester
Database Administration Board Question Paper 2081

Views: ...
BIT 352-2081 ✡
Tribhuvan University
Institute of Science and Technology
2081
✡
Bachelor Level/Third Year/Sixth Semester/Science
Bachelors in Information Technology (BIT 352)
(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 Answer Questions
Attempt any Two question.
[2x10=20]
1.

What are different database administration tasks? Explain Oracle Data Guard in brief.

2.

What is initialization parameter file? Differentiate between Spfile and Pfile. Explain some oracle defined roles with suitable example.

3.

What is Tablespace? What is UNDO RETENTION Policy? Write different commands to manage the tablespaces in Oracle.

Section B

Attempt any Eight questions

[8x5=40]
4.

What is privilege? Write commands to create user, grant privilege, revoke privilege and drop user in oracle database.

5.

What is Oracle AWR? How AWR report is viewed in oracle?

6.

What is Data Pump? Explain the procedure of exporting and importing data using Oracle Data Pump.

7.

Explain the concept of Container database and Portable database.

8.

What is Job and Job classes? Create an event-based schedule in Oracle.

9.

What is Extent? Explain Row chaining and Migration in brief.

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.

11.

Why do you think database auditing plays a significant role? Explain.

12.

Write short notes on:
a. Audit Trail
b. SQL Tuning Advisor