0 — Test 634
Page 1 of 3
Question 1
A normal index on last_name will usually NOT be used by:
FPSC - Database Administrator Model Papers -2026
Question 2
What does ALTER INDEX idx UNUSABLE do?
FPSC - Database Administrator Model Papers -2026
Question 3
What does ALTER INDEX idx COALESCE do?
FPSC - Database Administrator Model Papers -2026
Question 4
Which index type supports full-text searches in Oracle?
FPSC - Database Administrator Model Papers -2026
Question 5
How does CHAR(10) store the value 'AB'?
FPSC - Database Administrator Model Papers -2026
Question 6
Which data type stores large binary objects such as images?
FPSC - Database Administrator Model Papers -2026
Question 7
What is a virtual column?
FPSC - Database Administrator Model Papers -2026
Question 8
Which clause creates an auto-incrementing column in Oracle 12c and later?
FPSC - Database Administrator Model Papers -2026
Question 9
Which statement makes a table read-only in Oracle 11g and later?
FPSC - Database Administrator Model Papers -2026
Question 10
Which statement adds a description to a table in the data dictionary?
FPSC - Database Administrator Model Papers -2026