60:00
0/14 Attempted
Scoreboard
Attempted 0
Correct 0
Incorrect 0
Skipped 0
Total Score 0
Marks 0
Your Progress
Attempted 0
Correct 0
Incorrect 0
Skipped 0
Score 0
Marks 0

Functions, Joins & Set Operators — Test 1

Page 1 of 2

Review Skipped Questions

0
Question 1
What does INITCAP('oracle database') return?
FPSC - Database Administrator Model Papers -2026
Question 2
What does ROUND(45.926, 2) return?
FPSC - Database Administrator Model Papers -2026
Question 3
What does TRUNC(45.926, 1) return?
FPSC - Database Administrator Model Papers -2026
Question 4
What does MOD(10, 3) return?
FPSC - Database Administrator Model Papers -2026
Question 5
What is the result of ADD_MONTHS('31-JAN-2026', 1)?
FPSC - Database Administrator Model Papers -2026
Question 6
What does MONTHS_BETWEEN(date1, date2) return?
FPSC - Database Administrator Model Papers -2026
Question 7
Which function returns the last day of the month for a given date?
FPSC - Database Administrator Model Papers -2026
Question 8
Which function converts a character string into a DATE value using a format model?
FPSC - Database Administrator Model Papers -2026
Question 9
Which of the following is NOT an aggregate function?
FPSC - Database Administrator Model Papers -2026
Question 10
Which rule applies to a SELECT with GROUP BY?
FPSC - Database Administrator Model Papers -2026