Questions

Answer the following questions to test your knowledge of this chapter:

1. What is the output of the following statement?

   select ADD_MONTHS(TO_DATE('31.1.2023',
                             'DD.MM.YYYY'),
                     1)
     from dual;

   1. February 28, 2023
   2. February 29, 2023
   3. February 31, 2023
   4. An exception is raised
2. Select the right statement:
   1. The MONTHS_BETWEEN function can provide a negative value if the second parameter value is greater than the first
   2. The MONTHS_BETWEEN function provides only an integer value, not the numerical representation, generally
   3. If the output value of the MONTHS_BETWEEN function is negative, an exception is raised
   4. The internal implementation of the MONTHS_BETWEEN function takes both values and swaps them...