Course Content

Other Courses

Tribhuvan university > CSIT - 2074 Syllabus > Database Administration > Old Questions > 2076
Syllabus Notes Old Questions Unit Wise Questions Question Bank

Database Administration 2076

2074 2075 2076 2077 Model
Tribhuwan University
Institute of Science and Technology
2076
Bachelor Level / Seventh Semester / Science
Computer Science and Information Technology ( CSC414 )
( Database Administration )
Full Marks: 60
Pass Marks: 24
Time: 3 hours
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.

Group A

Attempt any Two questions.(2 x 10 = 20)

1. What is profile? How is it different from user? How do you create, assign, alter, and drop profile? Explain with suitable examples. 

10 marks view

2. Why do we need recovery? Discuss undo and redo log files used in recovery?

10 marks view

3. Discuss automatic database diagnostic monitor in detail. What is SQL tuning advisor?

10 marks view

Group B

Attempt any Eight questions. (8 x 5 = 40)

4. Define role. How do you query role information?

5 marks view

5. Define index ? Why do we need index in databases?

5 marks view

6. What is backup and recovery plan? How do you test this plan?

5 marks view

7. Discuss different policy types of virtual private database.

5 marks view

8. Explain DBMS architecture. What is data independence?

5 marks view

9. How do you produce more readable output to the result returned from SQL*Plus?Explain.

5 marks view

10. Define redo log file? Why do we need this file in databases?

5 marks view

11. How do you create different control files? Discuss.

5 marks view

12. What are different solutions of database corruption?

5 marks view

13. Write short notes on:

a) RMAN

b) Database auditing

5 marks view