Oracle SQL Oracle SQL Functions

Question 1

Which Oracle SQL function converts a string to uppercase?

Accepted Answer

UPPER

Answer

INITCAP

Answer

CAPITALIZE

Answer

UCASE

Question 2

What does the NVL function do in Oracle SQL?

Accepted Answer

Replaces a NULL value with a specified substitute value

Answer

Returns NULL if both arguments are equal

Answer

Counts non-NULL values

Answer

Converts a number to NULL

Question 3

Which Oracle SQL function returns the number of characters in a string?

Accepted Answer

LENGTH

Answer

SIZE

Answer

LEN

Answer

STRLEN

Question 4

What does the ROUND function do in Oracle SQL when called as ROUND(45.678, 1)?

Accepted Answer

Returns 45.7

Answer

Returns 45

Answer

Returns 46

Answer

Returns 45.68

Question 5

Which Oracle SQL function extracts a portion of a string starting at a given position?

Accepted Answer

SUBSTR

Answer

MID

Answer

LEFT

Answer

EXTRACT

Question 6

What does the TRUNC(45.789) function return in Oracle SQL?

Accepted Answer

45

Answer

46

Answer

45.8

Answer

45.79