Multiple choice technology databases

Which one is date function of Oracle...?

  1. multiply_months(x,y)

  2. add_months(x,y)

  3. devide_months(x,y)

  4. upper(x)

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle SQL provides the add_months(x, y) function to add a specified number of months to a date. The other options, multiply_months and devide_months, do not exist in Oracle SQL, while upper(x) is a character function used to convert text to uppercase.