BIT 6th Semester
Database Administration Board Question Paper 2079

Views: ...
BIT 352-2079 ✡
Tribhuvan University
Institute of Science and Technology
2079
✡
Bachelor Level/Third Year/Sixth Semester/Science
Bachelors in Information Technology (BIT 352)
(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 Answer Questions
Attempt any Two question.
[2x10=20]
1.

What do you mean by database management system? Mention the clear architecture of oracle database.

2.

Explain the term backup, restore and recovery in oracle database. Also explain the different backups and recovery process with example.

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

Section B

Attempt any Eight questions

[8x5=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.

What is SQL*PLUS? Also explain the functionalities of SQL*PLUS that the ORACLE DBA can use.

6.

Explain the term oracle RAC and oracle ASM.

7.

What is oracle data guard? Explain its importance in oracle database.

8.

Explain the term Database administrator (DBA) and describe the different roles of DBA.

9.

What is Job Scheduling in oracle database? How DBMS_SCHEDULER Works? Explain the different component of scheduler.

10.

Explain the different oracle net service components.

11.

What is database auditing? Explain the standard auditing in oracle database.

12.

Explain how SQL tuning advisor can be used to tune your database.