Question 10 of 32beginner🔧 ApplyVery Short1 mark

Write the output produced by the following SQL statement: SELECT YEAR("1979/11/26"), MONTH("1979/11/26"), DAY("1979/11/26"), MONTHNAME("1979/11/26");

Correct Answer

1979 11 26 November

Exercise: EXERCISE | Q: 2(d) | (Page 46)
For More Understanding

Explanation

According to Table 9.15 Date Functions in the textbook, YEAR() extracts the year (1979), MONTH() returns the month in numeric form (11), DAY() returns the day part (26), and MONTHNAME() returns the month name (November) from the date "1979/11/26".

Solution Steps

  1. Step 1: YEAR("1979/11/26") extracts year → 1979

  2. Step 2: MONTH("1979/11/26") returns month number → 11

  3. Step 3: DAY("1979/11/26") returns day → 26

  4. Step 4: MONTHNAME("1979/11/26") returns month name → November

PreviousNext