CACS485 Database Administration

Database Administration: most repeated questions

Questions that have come up in more than one paper, matched by what they ask rather than exact wording. Most repeated first.

  1. 3×Asked in 2025, 2023, 2021
    Explain how PDBs are related to CDB in multitenant architecture. Also mention the common things that they share with each other.Answer coming5
    See the wording in each paper
  2. 2×Asked in 2025, 2021
    Explain oracle database architecture in detail including memory, process, and storage structure of oracle database.Answer coming10
    See the wording in each paper
  3. 2×Asked in 2025, 2021
    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.Answer coming10
    See the wording in each paper
  4. 2×Asked in 2025, 2023
    What is multiplexing? Why is it needed? Write the steps of multiplexing the control files.Answer coming5
    See the wording in each paper