GATE DBMS PYQs | Problem 11 | Aggregate functions applied on NULL | GATE-2004
Автор: damn_engineering
Загружено: 2025-06-18
Просмотров: 10
Описание:
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: • GATE DBMS PYQs
#GATE2025 #GATEPrep #GATEPYQ #DBMS #SQL #GATECSE #GATENotes #DatabaseQuestions #PreviousYearQuestions #GATESQL #SQLPractice #GATEDBMS #damn_engineering
Повторяем попытку...

Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: