GATE DBMS PYQs | Problem 11 | Aggregate functions applied on NULL | GATE-2004

A table T1 in a relational database has the following rows and columns:
Roll no. Marks
1 10
2 20
3 30
4 NULL

The following sequence of SQL statements was successfully executed on table T1:
Update T1 set marks = marks + 5;
Select avg(marks) from T1;

What is the output of the select statement?
A. 18.75
B. 20
C. 25
D. Null

For more GATE DBMS PYQs watch this playlist: https://youtube.com/playlist?list=PLHV8V5iHbUHKBbXFAfctsndD2Nyd1mSSM&si=g7p7d-9kKME1gNrp

#GATE2025 #GATEPrep #GATEPYQ #DBMS #SQL #GATECSE #GATENotes #DatabaseQuestions #PreviousYearQuestions #GATESQL #SQLPractice #GATEDBMS #damn_engineering

Видео GATE DBMS PYQs | Problem 11 | Aggregate functions applied on NULL | GATE-2004 канала damn_engineering