A table T1 in a relational database has the following rows and columns: The…

GATE · 2004 · IT

A table T1 in a relational database has the following rows and columns:

image.png

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?

  1. A.

    18.75

  2. B.

    20

  3. C.

    25

  4. D.

    NULL

Attempted by 1019 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…