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

Download our Android App from Google Play Store and start reading Reference Notes Offline.

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

Download Question Paper File
[File Type: PDF | File Size: 421 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. Explain any detail about the DBMS architecture.
  2. What do you mean by database performance Tuning? Explain the role of ADDM and SQL Access Advisors in performance testing of oracle database.
  3. As a DBA explain how you can manage user privileges, roles and profiles? Consider you got a call from your backup DBA while you are on leave. He has corrupted all of the data files while playing with the ALTER DATABASE CONTROLFILE command. What do you do? Explain.
    Section B
    Attempt any Eight questions. (8×5=40)
  4. Differentiate between logical and physical data independence.
  5. What are the authentication method for DBA? Explain.
  6. What is redo log buffer and how do you monitor a waiting session in the redo log buffer?
  7. Differentiate between hot and cold backup. What is involved with executing a hot backup?
  8. Consider a situation that an alteration is made to the sp file which results in the instance being unable to start. As DBA how can you fix this problem?
  9. What do you mean by a view? Explain its importance.
  10. What do you mean by parallel instance recovery?
  11. What is oracle virtual private database? Explain the benefit associated with it.
  12. Write the DBA queries for the following actions:
    a. To display the size of your database
    b. Lock or unlock a user
    c. Show all connected users with their status
    d. Show the current SQLs
    e. Show what roles are granted to a user.
(Visited 104 times, 1 visits today)

Posted By : Digvijay | Comment RSS | Category : Old Question Collection, Seventh Semester
Tag :

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

Wordpress DMCA
Community | Toolbar | Android App | Founder/Developer : Hari Prasad Chaudhary | CSIT Portal Manager : Digvijay Chaudhary