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

MEAN

Answer

SUM/COUNT

Answer

MEDIAN

Question 2

What does the CONCAT function do in Oracle SQL?

Accepted Answer

Joins two strings together

Answer

Splits a string into parts

Answer

Finds the position of a substring

Answer

Converts a number to a string

Question 3

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

Accepted Answer

CEIL

Answer

FLOOR

Answer

ROUND

Answer

TRUNC

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

The date as a DATE data type

Answer

The number of days since epoch

Answer

An error because SYSDATE cannot be converted

Question 5

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

Accepted Answer

INSTR

Answer

SEARCH

Answer

FIND

Answer

LOCATE

Question 6

What does the DECODE function do in Oracle SQL?

Accepted Answer

Acts like a CASE expression, mapping values to results

Answer

Decodes Base64 encoded strings

Answer

Decrypts encrypted data

Answer

Converts character encoding