Tribhuvan University
Bachelor of Science in Computer Science and Information Technology
Semester 7 · Model question
Course Title: Database Administration (CSC414)
Full Marks: 60Pass Marks: 24Time: 3 hours
Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.
Group A
Attempt any TWO question.(2 × 10 = 20)
- 1.10
What is multiplexing? Why is it needed? Write the steps of multiplexing the redo log files and control files with oracle commands.
- 2.10
Explain the term backup, restore and recovery in oracle database. As a DBA of an organization, explain your backup policy (guideline) of your database and also explain the different backups and recovery process with example.
- 3.10
What do you mean by database management system? Mention the clear architecture of oracle database management system including different files.
Group B
Attempt any EIGHT question.(8 × 5 = 40)
- 4.5
Explain the term Database administrator (DBA) and describe the different roles of DBA.
- 5.5
What is the importance of privileges in database security? Explain the different system and object privileges used in ORACLE database with example.
- 6.5
Write the commands to create a role having any two privileges and create a user and assign above role to the specified user.
- 7.5
What is indexing? Why is it important? Explain it with example.
- 8.5
What is database auditing? Explain about standard auditing and Fine-grained auditing.
- 9.5
What is AWR report? Write all component of AWR report.
- 10.5
Mention and explain the different startup modes of ORACLE database and types of shutdowns.
- 11.5
What is flashback database? Explain the steps of keeping your database in flashback mode.
- 12.5
What is CDB and PDB in oracle multitenant architecture? Explain how they are related.
— The End —