Tribhuvan University
Bachelor of Computer Application
Semester 7 · TU Board 2023
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 A
Group B
Attempt any SIX question.(6 × 5 = 30)
- 2.5
What is partitioning? Explain the different method of table partitioning.
- 3.5
As a DBA, explain how you can define a backup policy in your organization.
- 4.5
What is multiplexing? Why is it needed! Write the steps of multiplexing the online redo log files.
Answer comingAlso asked in 2025
- 5.5
What is indexing? Why it is important in database? Explain the different guidelines to create index in database.
- 6.5
Explain the oracle multitenant architecture with CDB and PDB concept.
Answer comingAlso asked in 2025, 2021
- 7.5
What is database administration? Explain the roles and responsibilities of DBA.
- 8.5
Explain the different oracle net service components.
Group C
Attempt any TWO questions(2 × 10 = 20)
- 9.10
What do you mean by database recovery Explain in which situation database needs to be recovered. Explain the difference between crash recovery and media recovery. Also explain the steps involved in media recovery.
- 10.10
Describe the memory structure of oracle database. Explain how PGA differs from SGA. Also explain about oracle instance and different components of SGA.
- 11.10
What is privilege and why is it required? Explain the different system and object privileges used in ORACLE database with their importance. Write command to do following: a) Create common user and local user. b) Create a role, assign two system privileges on role and assign role to user. c) Allocate unlimited space to user on 'users' tablespace d) Create profile with following parameter. i) Failed_login_attempts 2 ii) Idle time 5 iii) Sessions per user 3 e) Assign profile to the user.
— The End —