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