Multiple choice technology programming languages

Which of the following is true about add_months

  1. we can pass a numerical value in first parameter

  2. we can pass a negative value in second parameter

  3. Both a & b

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The ADD_MONTHS function in Oracle SQL takes a date as its first parameter and an integer representing months as its second parameter. Passing a negative value in the second parameter is valid and subtracts months. The first parameter cannot be a simple numerical value, making option B correct.

Keep practicing — related questions