Database Administration | Question Paper 2073 | BSc.CSIT 7th Semester

Seventh Semester Question Paper 2073,
Subject: Database Administration,
BSc.CSIT | Tribhuvan University (TU),
Computer Science and Information Technology (CSc-406)

Download Question Paper File
[File Type: PDF | File Size: 409 KB | Download].
Click on Download to Start downloading the file. You can able to see the question paper without downloading too. The paper is given below;

Full Marks: 60 | Pass Marks: 24 | Time: 3 hours.
Candidates are required to give their answer in their own words as far as practicable.
The figures in the margin indicate full marks.

Section A
Attempt any Two questions. (2×10=20)

1. What do you mean by Database and database management system? Explain the SQL Plus overview.
2. Explain the managing maintaining and monitoring redo log files with appropriate example.
3. Explain the backup and recovery plan and strategy with practical example.
   Section B
   Attempt any Eight questions. (8×5=40)
4. How can you manage the control files? Explain.
5. Explain the database security and auditing.
6. Explain the testing the backup and recovery plan.
7. What do you mean by backup and recovery strategy?
8. Explain the RMAN with example.
9. What do you mean by tuning methodology?
10. Explain the virtual private database with example.
11. Explain the parallel instance recovery with practical example.
12. What are the major difference between automatic database management and automatic storage management?
13. Write short note on:
    a) DBA roles
    b) Column masking