Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

Tribhuwan University

Institute of Science and Technology

2080

Bachelor Level / Third Year / Sixth Semester / Science

Bachelors in Information Technology (BIT352)

(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 Answers Questions

Attempt any TWO questions.
[2*10=20]
1.
What do you mean by database management system? Mention the clear architecture of oracle database.[10]
2.
Explain the term backup, restore and recovery in oracle database. Also explain the different backups and recovery process with example.[10]
3.
What is the importance of privileges in database security? Explain about role in oracle datanse and write command to do following: a. Create role b. Grant system and object privileges to role c. Create user d. Assign role to user e. Drop role[10]
Section B

Short Answers Questions

Attempt any Eight questions.
[8*5=40]
4.
What are data files? How it is related with tablespace. Write a command to add a datafile in existing tablespace named "users". [5]
5.
What is SQL*PLUS? Also explain the functionalities of SQL*PLUS that the ORACLE DBA can use. [5]
6.
Explain the term oracle RAC and oracle ASM. [5]
7.
What is oracle data guard? Explain its importance in oracle database. [5]
8.
Explain the term Database administrator (DBA) and describe the different roles of DBA. [5]
9.
What is Job Scheduling in oracle database? How DBMS_ SCHEDULER Works? Explain the different component of scheduler. [5]
10.
Explain the different oracle net service components. [5]
11.
What is database auditing? Explain the standard auditing in oracle database. [5]
12.
Explain how SQL tuning advisor can be used to tune your database. [5]