Computer Science · Database Management Systems
Match List-I with List-II: List-I (Aggregate Function) (A) count(marks) (B) count() (C) avg(marks) (D) sum(marks) List-II (Description) (I) Count all rows (II) Finding average of non-null values of marks (III) Count all non-null values of marks column (IV) Finding sum of all marks Choose the correct answer from the options given below:
- 1(A) - (III), (B) - (IV), (C) - (I), (D) - (II)
- 2(A) - (I), (B) - (II), (C) - (IV), (D) - (III)
- 3(A) - (I), (B) - (III), (C) - (II), (D) - (IV)
- 4(A) - (III), (B) - (I), (C) - (II), (D) - (IV)✓
Correct answer
(A) - (III), (B) - (I), (C) - (II), (D) - (IV)
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Database Management Systems?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Management Systems