Oracle SQL Oracle SQL Functions 3

Question 1

Which Oracle SQL function pads the left side of a string with a specified character to a given length?

Accepted Answer

LPAD

Answer

LPAD(string, length, pad_char) adds the pad character to the left of the string until it reaches the specified total length.

Question 2

What does MONTHS_BETWEEN(date1, date2) return in Oracle SQL?

Accepted Answer

The number of complete months between two dates

Answer

MONTHS_BETWEEN returns the number of months (including fractional months) between two dates.

Question 3

Which Oracle SQL function returns the first non-NULL value from a list of arguments?

Accepted Answer

COALESCE

Answer

COALESCE(expr1, expr2, ...) returns the first non-NULL expression in the list and accepts any number of arguments.

Question 4

What does the NULLIF(expr1, expr2) function return in Oracle SQL?

Accepted Answer

NULL if expr1 equals expr2, otherwise expr1

Answer

NULLIF returns NULL when both arguments are equal; otherwise it returns the first argument.

Question 5

Which Oracle SQL function adds a specified number of months to a date?

Accepted Answer

ADD_MONTHS

Answer

ADD_MONTHS(date, n) adds n months to the specified date, adjusting for end-of-month scenarios automatically.

Oracle SQL Practice Test