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

प्रश्न

पर्याय

sum(*)
total(*)
count(*)
return(*)

MCQ

उत्तर

count(*)

shaalaa.com

Functions in SQL

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

Q 15 Q 14 Q 16

2022-2023 (March) Sample

APPEARS IN

2022-2023 (March) Sample (with solutions)

Q 15 | 1 mark

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

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

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

Identify Single Row function of MySQL among the following.

What will be returned by the given query? Select length(trim("ABC Public School")) = ______.

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

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?

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 the specified number of characters from a particular position of the given string.

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

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)

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?

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