BCA 7th Semester
Database Administration Board Question Paper 2025

Views: ...
tribhuvan university logo

Tribhuvan university

Faculty of Humanities & Social Science
OFFICE OF THE DEAN

2025

Bachelor In Computer Application

Course Title: Database Administration

Code No: CACS 485

Semester:VII

Full Marks:60 Pass Marks:24 Time: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.
[6x5=30]
2.

What are data files? How it is related with tablespace? Write a command to add a datafile in existing tablespace.

3.

Explain the different methods of network configuration to connect to the oracle database.

4.

Explain the different privileges in an oracle database and explain how you can grant and revoke the privileges to the user with examples.

5.

What is profile? Why is it important? Explain with an example.

6.

Explain how PDBs are related to CDB in multitenant architecture. Also mention the common things that they share with each other.

7.

What is multiplexing? Why is it needed? Write the steps of multiplexing the control files.

8.

Explain the use of sequence in oracle database with example.

Group C

Attempt any TWO questions

[2x10=20]
9.

Discuss backup, restore and recovery in oracle database. As a DBA of an organization, explain your backup and recovery strategy. Explain how you can recover the database in case of different types of failure. Also explain the process of media recovery.

10.

Explain oracle database architecture in detail including memory, process, and storage structure of oracle database.

11.

What is scheduler and why scheduler is important in oracle database? Explain the different components of the scheduler with their workflow. Also explain the difference between time-based scheduling and event-based scheduling.