0 — Test 627
Page 1 of 3
Question 1
What does Oracle automatically create when you define a PRIMARY KEY or UNIQUE constraint?
FPSC - Database Administrator Model Papers -2026
Question 2
What is the main purpose of an index?
FPSC - Database Administrator Model Papers -2026
Question 3
What is the default index type in Oracle?
FPSC - Database Administrator Model Papers -2026
Question 4
Bitmap indexes are best suited for:
FPSC - Database Administrator Model Papers -2026
Question 5
Which statement creates an index on the LAST_NAME column?
FPSC - Database Administrator Model Papers -2026
Question 6
Which statement creates a unique index?
FPSC - Database Administrator Model Papers -2026
Question 7
What is a composite index?
FPSC - Database Administrator Model Papers -2026
Question 8
What is a function-based index?
FPSC - Database Administrator Model Papers -2026
Question 9
Which statement removes an index?
FPSC - Database Administrator Model Papers -2026
Question 10
What is a disadvantage of having many indexes on a table?
FPSC - Database Administrator Model Papers -2026