Oracle SQL Oracle SQL Functions 2

Question 1

Which Oracle SQL aggregate function returns the average of a column's values?

Accepted Answer

AVG

Answer

AVG calculates the arithmetic mean of non-NULL values in a column.

Question 2

What does the CONCAT function do in Oracle SQL?

Accepted Answer

Joins two strings together

Answer

CONCAT(string1, string2) joins two strings end-to-end, equivalent to using the || operator in Oracle.

Question 3

Which Oracle SQL function returns the smallest integer greater than or equal to a number?

Accepted Answer

CEIL

Answer

CEIL (ceiling) returns the smallest integer that is greater than or equal to the input number.

Question 4

What does TO_CHAR(SYSDATE, 'YYYY-MM-DD') return in Oracle SQL?

Accepted Answer

The current date formatted as a string like '2026-03-21'

Answer

TO_CHAR converts a DATE to a VARCHAR2 string using the specified format mask, producing a readable date string.

Question 5

Which Oracle SQL function searches for a substring within a string and returns its position?

Accepted Answer

INSTR

Answer

INSTR(string, substring) returns the position of the first occurrence of substring within string, or 0 if not found.

Oracle SQL Practice Test