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”);

Question

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”);

Short/Brief Note

Solution

Year: 1979

Month: 11

Day: 26

Month Name: November

shaalaa.com

Functions in SQL

Is there an error in this question or solution?

Q 2. d)Q 2. c)Q 2. e)

Chapter 9: Structured Query Language (SQL) - Exercise [Page 177]

APPEARS IN

NCERT Computer Science [English] Class 12

Chapter 9 Structured Query Language (SQL)
Exercise | Q 2. d) | Page 177

RELATED QUESTIONS

Which method is used to get the row-id of the last modified row?

Which of the following belongs to an "aggregate function"?

The MAX () function finds the

Consider the table STUDENT given below:

RollNo	Name	Class	DOB	Gender	City	Marks
1	Anand	XI	6/6/97	M	Agra	430
2	Chetan	XII	7/5/94	M	Mumbai	460
3	Geet	XI	6/5/97	F	Agra	470
4	Preeti	XII	8/8/95	F	Mumbai	492
5	Saniyal	XII	8/10/95	M	Delhi	360
6	Maakhiy	XI	12/12/94	F	Dubai	256
7	Neha	X	8/12/95	F	Moscow	324
8	Nishant	X	12/6/95	M	Moscow	429

State the command to display the average marks scored by students of each gender who are in class XI?

(i) Select Gender, avg(Marks) from STUDENT where Class= "XI" group by Gender;

(ii) Select Gender, avg(Marks) from STUDENT group by Gender where Class="XI";

(iii) Select Gender, avg(Marks) group by Gender from STUDENT having Class="XI";

(iv) Select Gender, avg(Marks) from STUDENT group by Gender having Class = "XI";

Choose the correct option:

Assertion (A): COUNf function ignores DISTINCT

Reason (R): DISTINCT ignores the duplicate values.

Which command is used to delete a table? (in SQL)

What will be returned by the given query? SELECT RIGHT("LEFT", 2) = ______.

Name a function of MySQL which is used to remove trailing and leading spaces from a string.

Name a function of MySQL used to give position of the first occurrence of a string2 in string1.

Which of the following is not a date function?

The string function that returns the index of the first occurrence of substring is ______.

Write the name of the functions to perform the following operation:

To display your name in capital letters.

Write the output produced by the following SQL statement:

SELECT ROUND(342.9234, -1);

Write the output produced by the following SQL statement:

SELECT LEFT("INDIA", 3), RIGHT("Computer Science", 4), MID("Informatics", 3, 4), SUBSTR("Practices", 3);

Which function is used to display the total number of records from a table in a database?

Write the outputs of the SQL queries based on the relations Teacher and Placement given below:

Table: Teacher

T_ID	Name	Age	Department	Date_of_join	Salary	Gender
1	Arunan	34	Computer Sc	2019-01-10	12000	M
2	Saman	31	History	2017-03-24	20000	F
3	Randeep	32	Mathematics	2020-12-12	30000	M
4	Samira	35	History	2018-07-01	40000	F
5	Raman	42	Mathematics	2021-09-05	25000	M
6	Shyam	50	History	2019-06-27	30000	M
7	Shiv	44	Computer Sc	2019-02-25	21000	M
8	Shalakha	33	Mathematics	2018-07-31	20000	F

Table: Placement

P_ID	Department	Place
1	History	Ahmedabad
2	Mathematics	Jaipur
3	Computer Sc	Nagpur

SELECT Department, avg(salary) FROM Teacher GROUP BY Department;
SELECT MAX(Date_of_Join), MIN(Date_of_Join) FROM Teacher;
SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P WHERE T.Department = P.Department AND Salary>20000;
SELECT Name, Place FROM Teacher T, Placement P WHERE Gender = ’F’ AND T.Department = P.Department;

Predict the output of the code given below:

s="welcome2cs" 

n = len(s)
m=""
for i in range(0, n):
       if (s[i] >= 'a' and s[i] <= 'm'):
            m = m +s[i].upper()
 elif (s[i] >= 'n' and s[i] <= 'z'):
          m = m +s[i-1]
 elif (s[i].isupper()):
     m = m + s[i].lower()
 else:
     m = m +'&'
print(m)

Which one of the following is not an aggregate function?

Write suitable SQL query for the following:

Display the position of occurrence of the string ‘COME’ in the string ‘WELCOME WORLD’.