Connections, Processing & Memory Parameters — Test 1
Page 1 of 1
Question 1
What is the difference between dedicated and shared server connections?
FPSC - Database Administrator Model Papers -2026
Question 2
What are the three main stages of SQL statement processing?
FPSC - Database Administrator Model Papers -2026
Question 3
What is a hard parse?
FPSC - Database Administrator Model Papers -2026
Question 4
Which initialization parameter caps the total size of the SGA that can be set dynamically?
FPSC - Database Administrator Model Papers -2026
Question 5
Which parameter sets the target total PGA memory for all server processes?
FPSC - Database Administrator Model Papers -2026
Question 6
What is the large pool used for?
FPSC - Database Administrator Model Papers -2026
Question 7
What is a logical read?
FPSC - Database Administrator Model Papers -2026
Question 8
Which parameter controls how long undo data is retained, in seconds?
FPSC - Database Administrator Model Papers -2026