Write the name of the functions to perform the following operation: To display the name of the month in which you were born. - Computer Science (Python)

प्रश्न

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

To display the name of the month in which you were born.

एक शब्द/वाक्यांश उत्तर

उत्तर

MONTHNAME( )

shaalaa.com

Functions in SQL

या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?

Q 1. f) iii)Q 1. f) ii)Q 1. f) iv)

पाठ 9: Structured Query Language (SQL) - Exercise [पृष्ठ १७७]

APPEARS IN

एनसीईआरटी Computer Science [English] Class 12

पाठ 9 Structured Query Language (SQL)
Exercise | Q 1. f) iii) | पृष्ठ १७७

संबंधित प्रश्‍न

______ is used to get a specified day of the month for a given date.

______ keyword is used to find out the number of values in a column?

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

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 that will give the output as:

Name

(i) select Name from student where Class ='XI' and Class='XII';

(ii) select name from student where not Class='XI' and Class='XII';

(iii) select name from student where City="Agra" or City="Mumbai";

(iv) select name from student where City in("Agra", "Mumbai");

Choose the correct option:

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:

What will be the output of the following SQL statement?

SELECT DAY NAME (2022-04-08)

Assertion (A): COUNf function ignores DISTINCT

Reason (R): DISTINCT ignores the duplicate values.

Which of the following is not an aggregate function?

The char() function in MySql is an example of ______.

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

Identify Single Row function of MySQL among the following.

What will be returned by the given query? Select round(23456.1234, -2) = ______.

What will be returned by the given query? select power(3, 2) = ______.

"COUNT" keyword belongs to which categories in Mysql?

The ______ function returns m raised to the n^th power.

What will be returned by the given query? SELECT MID('BoardExamination', 2, 4) = ______.

What will be returned by the given query? SELECT INSTR('INFORMATIONFORM', 'FOR') = ______.

What will be returned by the given query? SELECT DAYOFYEAR('2015-01-10') = ______.

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

What is the general format of UPPER() return type?

Which statement is used to count the number of rows in table?

Site any two differences between Single Row Functions and Aggregate Functions.

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 YEAR(“1979/11/26”),
MONTH(“1979/11/26”), DAY(“1979/11/26”), MONTHNAME(“1979/11/26”);

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

Differentiate between count() and count(*) functions in SQL with appropriate examples.

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 type of values will not be considered by SQL while executing the following statement?

SELECT COUNT(column name) FROM inventory;

If column “Fees” contains the data set (5000,8000,7500,5000,8000), what will be the output after the execution of the given query?

SELECT SUM (DISTINCT Fees) FROM student;

Which one of the following is not an aggregate function?

Write outputs for SQL queries that are based on the given table PURCHASE:

TABLE: PURCHASE
CNO	CNAME	CITY	QUANTITY	DOP
C01	GURPREET	NEW DELHI	150	2022-06-11
C02	MALIKA	HYDERABAD	10	2022-02-19
C03	NADAR	DALHOUSIE	100	2021-12-04
C04	SAHIB	CHANDIGARH	50	2021-10-10
C05	MEHAK	CHANDIGARH	15	2021-10-20

SELECT LENGTH(CNAME) FROM PURCHASE WHERE QUANTITY>100;
SELECT CNAME FROM PURCHASE WHERE MONTH(DOP) = 3;
SELECT MOD (QUANTITY, DAY(DOP)) FROM PURCHASE WHERE CITY = ‘CHANDIGARH’;

Based on the table STUDENT given here, write suitable SQL queries for the following:

Roll No	Name	Class	Gender	City	Marks
1	Abhishek	XI	M	Agra	430
2	Prateek	XII	M	Mumbai	440
3	Sneha	XI	F	Agra	470
4	Nancy	XII	F	Mumbai	492
5	Himanshu	XII	M	Delhi	360
6	Anchal	XI	F	Dubai	256
7	Mehar	X	F	Moscow	324
8	Nishant	X	M	Moscow	429

Display gender-wise highest marks.
Display city-wise lowest marks.
Display the total number of male and female students.