Tribhuvan University
Bachelor of Information Technology
Semester 6 · TU Board 2080
Course Title: Database Administration (BIT352)
Full Marks: 60Pass Marks: 24Time: 3 hours
Candidates are required to give their answers in their own words as far as practicable.
Group A
Attempt any Two questions.(2 × 10 = 20)
- 1.10
Describe levels of locking in oracle. Discuss the methods used to acquire locks in oracle.
- 2.10
Explain architecture of oracle database with suitable diagram.
- 3.10
What is space management? How space management is done? How can you create tables without segments?
Group B
Attempt any Eight questions(8 × 5 = 40)
- 4.5
What are the roles and responsibilities of Database Administrator?
Answer comingAlso asked in 2079
- 5.5
What is tablespace and datafile in oracle? How can we add new tablespace and datafiles in oracle database?
- 6.5
What is privilege? Write commands to create user, grant privilege, revoke privilege and drop user in oracle database.
Answer comingAlso asked in 2081
- 7.5
What is Oracle AWR? How AWR report is viewed in oracle?
Answer comingAlso asked in 2081
- 8.5
What is Role? Explain its role in privilege management with suitable example.
- 9.5
What is SQL Tuning? Explain SQL Tuning Process in Oracle?
- 10.5
What is user profile? Create a simple user profile and assign the profile to new user in oracle.
- 11.5
What is listener? Explain about listener.ora and tnsnames.ora file in oracle database.
- 12.5
How event based schedules are created? Explain.
— The End —