FPSC - Database Administrator Model Papers -2026 — Test 7
Page 1 of 3
Question 1
Which background process writes modified (dirty) buffers to the datafiles?
FPSC - Database Administrator Model Papers -2026
Question 2
Which background process writes redo entries from the redo log buffer to the online redo logs?
FPSC - Database Administrator Model Papers -2026
Question 3
Which process signals a checkpoint and updates control file and datafile headers?
FPSC - Database Administrator Model Papers -2026
Question 4
Which process cleans up after failed user processes and releases their resources?
FPSC - Database Administrator Model Papers -2026
Question 5
Which process copies filled online redo logs to the archive destination?
FPSC - Database Administrator Model Papers -2026
Question 6
When does LGWR write the redo log buffer to disk?
FPSC - Database Administrator Model Papers -2026
Question 7
What does a server process do?
FPSC - Database Administrator Model Papers -2026
Question 8
What is the role of the Oracle listener?
FPSC - Database Administrator Model Papers -2026
Question 9
In which startup stage does Oracle read the control file but keep datafiles closed?
FPSC - Database Administrator Model Papers -2026
Question 10
Which background process resolves failures of distributed transactions automatically?
FPSC - Database Administrator Model Papers -2026