FPSC - Database Administrator Model Papers -2026 — Test 8
Page 1 of 3
Question 1
Which Oracle function works like IF-THEN-ELSE by comparing an expression with search values?
FPSC - Database Administrator Model Papers -2026
Question 2
Which expression is the ANSI-standard way to apply conditional logic in a SELECT?
FPSC - Database Administrator Model Papers -2026
Question 3
What does COALESCE(a, b, c) return?
FPSC - Database Administrator Model Papers -2026
Question 4
What does NVL2(expr, a, b) return?
FPSC - Database Administrator Model Papers -2026
Question 5
What does INITCAP('oracle database') return?
FPSC - Database Administrator Model Papers -2026
Question 6
What does ROUND(45.926, 2) return?
FPSC - Database Administrator Model Papers -2026
Question 7
What does TRUNC(45.926, 1) return?
FPSC - Database Administrator Model Papers -2026
Question 8
What does MOD(10, 3) return?
FPSC - Database Administrator Model Papers -2026
Question 9
What is the result of ADD_MONTHS('31-JAN-2026', 1)?
FPSC - Database Administrator Model Papers -2026
Question 10
What does MONTHS_BETWEEN(date1, date2) return?
FPSC - Database Administrator Model Papers -2026