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

RPAD

Answer

LEFTPAD

Answer

PAD

Question 2

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

Accepted Answer

The number of complete months between two dates

Answer

The number of days between two dates

Answer

A date that is N months after date1

Answer

The month names between two dates

Question 3

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

Accepted Answer

COALESCE

Answer

NVL

Answer

NVL2

Answer

NULLIF

Question 4

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

Accepted Answer

NULL if expr1 equals expr2, otherwise expr1

Answer

expr2 if expr1 is NULL

Answer

TRUE if both expressions are NULL

Answer

expr1 only if it is not NULL

Question 5

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

Accepted Answer

ADD_MONTHS

Answer

DATE_ADD

Answer

DATEADD

Answer

MONTHS_ADD

Question 6

What does the MOD function return in Oracle SQL when called as MOD(17, 5)?

Accepted Answer

2

Answer

3

Answer

4

Answer

3.4