Computer Science - Class 12
Solutions to CBSE Sample Paper - Computer Science Class 12

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

(a) sum(*)

(b) total(*)

(c) count(*)

(d) return(*)

 

Answer:

The count(*) function is used to display the total number of records from a table in a database.

 

Syntax:

SELECT COUNT ( * )

FROM table_name;

 

So, the correct answer is (c).

Ask a doubt
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.