Database Administration TU Board 2025 question paper

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

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

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

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

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

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

Explain the use of sequence in oracle database with example.

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.

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

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.