Give the output of the query: SELECT MONTH("2010-03-05");

Question

Given table 'StudAtt' with structure as (Rno, Attdate, Attendance). Identify the suitable command to add a primary key to the table after creation.
Note: We want to make both Rno and Attdate columns as primary key.

Answer 1

Step 1: MONTH() Function Explained.
The SQL MONTH() function retrieves the month from a date and outputs it as an integer from 1 to 12.
Step 2: Applying to the Date.
For the date “2010-03-05”: - Year: 2010
- Month: 03
- Day: 05

Step 3: Month Extraction.
Applying MONTH() to "2010-03-05" yields 3.
Step 4: Eliminating Incorrect Options.
- Option 2 (5): Represents the day, not the month.
- Option 3 (MARCH): Is text, whereas MONTH() returns a number.
- Option 4 (MAY): Corresponds to the 5th month, which is incorrect for this date.

Final Answer: \[\boxed{3}\]

List-I	List-II
(A) SUBSTR()	(II) To extract a substring from a string.
(B) TRIM()	(IV) To remove spaces from both sides of the string.
(C) INSTR()	(I) To find the position of a substring in a string.
(D) LEFT()	(III) To extract characters from the left side of the string.

ENO	SALARY
A101	4000
B109	NULL
C508	6000
A305	2000

Give the output of the query: SELECT MONTH("2010-03-05");

Show Hint

The Correct Option is A

Solution and Explanation

Top Questions on SQL

Questions Asked in CUET (UG) exam