Tribhuvan University
Bachelor of Computer Application
Semester 7 · TU Board 2021
Course Title: Database Administration (CACS485)
Full Marks: 60Pass Marks: 24Time: 3 hours
Candidates are required to answer the question in their own words as far as possible.
Group B
Attempt any SIX question.(6 × 5 = 30)
- 2.5
What do you mean by oracle Instance? Explain about the different data structures used in SGA.
- 3.5
What is synonym? why it is important? explain it with example.
- 4.5
What is database archiving? why it is important? Write the steps to keep your database in archive log mode.
- 5.5
Explain the term database administrator (DBA) and describe the different roles of DBA.
- 6.5
What is CDB and PDB in oracle multitenant architecture? explain how they are related.
Answer comingAlso asked in 2025, 2023
- 7.5
What is user profile? write the commands to create the user profile and assign it to user.
- 8.5
What is job scheduling in oracle database? Explain the difference between time based and event based schedule.
Answer comingAlso asked in 2025
Group C
Attempt any TWO questions(2 × 10 = 20)
- 9.10
What do you mean by database management system? Mention the clear architecture of oracle database management system including different files, process and memory structure.
Answer comingAlso asked in 2025
- 10.10
Explain the term backup restore and recovery in oracle database. Also explain the different backups and recovery process with example using RMAN and datapump utility.
- 11.10
Write SQL commands for following i. Create the table named emp having fields (emp-id, name, address DOB, Salary) ii. Add primary key in above table iii. Add check constraints in the salary fields, value of salary> 10000 iv. Rename the table emp to employee v. V Insert some rows and delete one of the record from the table employee vi. Create the logical backup-of above table using expdp utility vii. Give select, update privilege to another user Userl. viii.Add department_id field as foreign key referencing the table department. ix. Modify the name field to increase the character length x. Rename the name field to ename.
— The End —