Storage Structures & Diagnostics — Test 1
Page 1 of 2
Question 1
What is the default database block size in Oracle?
FPSC - Database Administrator Model Papers -2026
Question 2
In a locally managed tablespace, how are free extents tracked?
FPSC - Database Administrator Model Papers -2026
Question 3
What is a bigfile tablespace?
FPSC - Database Administrator Model Papers -2026
Question 4
What does AUTOEXTEND ON do for a datafile?
FPSC - Database Administrator Model Papers -2026
Question 5
What does the alert log contain?
FPSC - Database Administrator Model Papers -2026
Question 6
What is the Automatic Diagnostic Repository (ADR)?
FPSC - Database Administrator Model Papers -2026
Question 7
What do the prefixes USER_, ALL_ and DBA_ in data dictionary views mean?
FPSC - Database Administrator Model Papers -2026
Question 8
What are V$ views?
FPSC - Database Administrator Model Papers -2026
Question 9
What is Oracle ASM?
FPSC - Database Administrator Model Papers -2026
Question 10
What does Oracle RAC provide?
FPSC - Database Administrator Model Papers -2026