BIT 6th Semester
Database Administration Board Question Paper 2080

Views: ...
BIT 352-2080 ✡
Tribhuvan University
Institute of Science and Technology
2080
✡
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.

Describe levels of locking in oracle. Discuss the methods used to acquire locks in oracle.

2.

Explain architecture of oracle database with suitable diagram.

3.

What is space management? How space management is done? How can you create tables without segments?

Section B

Attempt any Eight questions

[8x5=40]
4.

What are the roles and responsibilities of Database Administrator?

5.

What is tablespace and datafile in oracle? How can we add new tablespace and datafiles in oracle database?

6.

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

7.

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

8.

What is Role? Explain its role in privilege management with suitable example.

9.

What is SQL Tuning? Explain SQL Tuning Process in Oracle?

10.

What is user profile? Create a simple user profile and assign the profile to new user in oracle.

11.

What is listener? Explain about listener.ora and tnsnames.ora file in oracle database.

12.

How event based schedules are created? Explain.