Oracle SQL Oracle SQL Functions

Question 1

Which Oracle SQL function converts a string to uppercase?

Accepted Answer

UPPER

Answer

The UPPER function converts all characters in a string to uppercase letters.

Question 2

What does the NVL function do in Oracle SQL?

Accepted Answer

Replaces a NULL value with a specified substitute value

Answer

NVL(expr, replacement) returns the replacement value when expr is NULL, otherwise returns expr unchanged.

Question 3

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

Accepted Answer

LENGTH

Answer

The LENGTH function returns the number of characters in a string, or NULL if the string is NULL.

Question 4

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

Accepted Answer

Returns 45.7

Answer

ROUND(45.678, 1) rounds to one decimal place, returning 45.7.

Question 5

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

Accepted Answer

SUBSTR

Answer

SUBSTR(string, start, length) extracts a substring starting at the given position for a specified number of characters.

Oracle SQL Practice Test