FPSC - Database Administrator Model Papers -2026 — Test 10
Page 1 of 3
Question 1
Which statement forces a log switch?
FPSC - Database Administrator Model Papers -2026
Question 2
Which STATUS values can a redo log group have in V$LOG?
FPSC - Database Administrator Model Papers -2026
Question 3
Which column of V$DATABASE shows whether the database is in ARCHIVELOG mode?
FPSC - Database Administrator Model Papers -2026
Question 4
Which initialization parameter specifies where archived redo logs are stored?
FPSC - Database Administrator Model Papers -2026
Question 5
Which shutdown mode leaves the database in an inconsistent state, requiring instance recovery at the next startup?
FPSC - Database Administrator Model Papers -2026
Question 6
Which shutdown mode rolls back active transactions and disconnects users, leaving a consistent database?
FPSC - Database Administrator Model Papers -2026
Question 7
What does SCN stand for?
FPSC - Database Administrator Model Papers -2026
Question 8
Which RMAN command recovers the database to a specific time in the past?
FPSC - Database Administrator Model Papers -2026
Question 9
What is block media recovery?
FPSC - Database Administrator Model Papers -2026
Question 10
What does ORA-00257 (archiver error) usually mean?
FPSC - Database Administrator Model Papers -2026