FPSC - Database Administrator Model Papers (National Archives Cabinet Division)- 2026 — Part 4 (100 Q)
Page 1 of 10
Question 1
What problem does a reverse key index help avoid?
FPSC - Database Administrator Model Papers -2026
Question 2
Which access path is used for an equality search on a primary key?
FPSC - Database Administrator Model Papers -2026
Question 3
Which statement generates an execution plan without running the query?
FPSC - Database Administrator Model Papers -2026
Question 4
Which package formats and displays execution plans?
FPSC - Database Administrator Model Papers -2026
Question 5
Which procedure gathers optimizer statistics for a table?
FPSC - Database Administrator Model Papers -2026
Question 6
The Oracle Cost-Based Optimizer (CBO) chooses a plan based on:
FPSC - Database Administrator Model Papers -2026
Question 7
Which hint asks the optimizer to use a specific index?
FPSC - Database Administrator Model Papers -2026
Question 8
Which statement starts tracking whether an index is used?
FPSC - Database Administrator Model Papers -2026
Question 9
Which column is the best candidate for a B-tree index?
FPSC - Database Administrator Model Papers -2026
Question 10
Why might WHERE last_name LIKE '%son' not use a normal B-tree index?
FPSC - Database Administrator Model Papers -2026