In an INTERVAL YEAR TO MONTH data type,which of the following indicates a positive time interval of 2 years and 11 months?
A)2-11
B)+2-11
C)+02-11
D)11-02

Question

Quizplus · Accepted Answer

The INTERVAL YEAR TO MONTH data type has the format [+/-]YY-MM, where YY represents the number of years and MM represents the number of months. 
To represent a positive time interval of 2 years and 11 months, we need to use a plus sign (+) and pad the months with a leading zero (0) to maintain a consistent format. Thus, the correct format would be +02-11.

In an INTERVAL YEAR TO MONTH Data Type,which of the Following