Tribhuvan University
Bachelor of Information Technology
Semester 6 · TU Board 2079
Course Title: Database Administration (BIT352)
Full Marks: 60Pass Marks: 24Time: 3 hours
Candidates are required to give their answers in their own words as far as practicable.
Group A
Attempt any Two questions.(2 × 10 = 20)
- 1.10
What do you mean by database management system? Mention the clear architecture of oracle database.
- 2.10
Explain the term backup, restore and recovery in oracle database. Also explain the different backups and recovery process with example.
- 3.10
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
Group B
Attempt any Eight questions(8 × 5 = 40)
- 4.5
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 SQLPLUS? Also explain the functionalities of SQLPLUS that the ORACLE DBA can use.
- 6.5
Explain the term oracle RAC and oracle ASM.
- 7.5
What is oracle data guard? Explain its importance in oracle database.
Answer comingAlso asked in 2081
- 8.5
Explain the term Database administrator (DBA) and describe the different roles of DBA.
Answer comingAlso asked in 2080
- 9.5
What is Job Scheduling in oracle database? How DBMS_SCHEDULER Works? Explain the different component of scheduler.
- 10.5
Explain the different oracle net service components.
- 11.5
What is database auditing? Explain the standard auditing in oracle database.
- 12.5
Explain how SQL tuning advisor can be used to tune your database.
— The End —