60:00
0/30 Attempted
Scoreboard
Attempted 0
Correct 0
Incorrect 0
Skipped 0
Total Score 0
Marks 0
Your Progress
Attempted 0
Correct 0
Incorrect 0
Skipped 0
Score 0
Marks 0

Oracle: Database Server Architecture — Test 1

Page 1 of 3

Review Skipped Questions

0
Question 1
An Oracle instance consists of:
FPSC - Database Administrator Model Papers -2026
Question 2
What is the Oracle database?
FPSC - Database Administrator Model Papers -2026
Question 3
What is the SGA?
FPSC - Database Administrator Model Papers -2026
Question 4
What is the PGA?
FPSC - Database Administrator Model Papers -2026
Question 5
Which SGA component caches data blocks read from datafiles?
FPSC - Database Administrator Model Papers -2026
Question 6
Which two main components make up the shared pool?
FPSC - Database Administrator Model Papers -2026
Question 7
What does the library cache store?
FPSC - Database Administrator Model Papers -2026
Question 8
What does the redo log buffer hold?
FPSC - Database Administrator Model Papers -2026
Question 9
Which initialization parameter enables automatic management of SGA components?
FPSC - Database Administrator Model Papers -2026
Question 10
Which file stores initialization parameters in a binary, server-managed format?
FPSC - Database Administrator Model Papers -2026