Skip to content
Related Articles

Related Articles

GATE | GATE-IT-2004 | Question 76

View Discussion
Improve Article
Save Article
  • Last Updated : 28 Jun, 2021

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

Answer: (C)

Explanation: 10+5





So Answer is C

Quiz of this Question
Please comment below if you find anything wrong in the above post

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!