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; - Informatics Practices

Question

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;

Options

20500
10000
20000
33500

MCQ

Solution

20500

shaalaa.com

Functions in SQL

Is there an error in this question or solution?

Q 5 Q 4 Q 6

2022-2023 (March) Sample

APPEARS IN

2022-2023 (March) Sample (with solutions)

Q 5 | 1 mark

RELATED QUESTIONS

______ 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?

The MAX () function finds the

Identify Single Row function of MySQL among the following.

What will be returned by the given query? select day of year('2015-02-10') = ______.

What will be returned by the given query? select power(3, 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.

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

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

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

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

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

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

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 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?

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’;

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:

Display the remainder of 100 divided by 9.