Write the name of the functions to perform the following operation: To display the day like “Monday”, and “Tuesday”, from the date when India got independence. - Computer Science (Python)

प्रश्न

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

To display the day like “Monday”, and “Tuesday”, from the date when India got independence.

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

उत्तर

DAYNAME( )

shaalaa.com

Functions in SQL

क्या इस प्रश्न या उत्तर में कोई त्रुटि है?

Q 1. f) i)Q 1. e) ii)Q 1. f) ii)

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

APPEARS IN

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

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

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

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

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 of the following is not an aggregate function?

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 day of year('2015-02-10') = ______.

What will be returned by the given query? select substr("Computer", 4) = ______.

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

"COUNT" keyword belongs to which categories in Mysql?

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

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

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') = ______.

Which of the following is not a date function?

Which of the following is not a text function?

Which function will be used to remove only the trailing spaces from a string?

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?

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

To display the specified number of characters from a particular position of the given string.

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

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?

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?

Which one of the following functions are used to find the largest value from the given data in MySQL?

In SQL, which function is used to display the current date and time?

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.

Write suitable SQL query for the following:

Display 7 characters extracted from the 7^th left character onwards from the string ‘INDIA SHINING’.

Write suitable SQL query for the following:

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

Write suitable SQL query for the following:

Round off the value 23.78 to one decimal place.

Write suitable SQL query for the following:

Display the remainder of 100 divided by 9.