Register

GATE IT 2004 | Question: 76

• edited by
18,318 views
58 58 votes

A table T1 in a relational database has the following rows and columns: 
$$\begin{array}{|c|c|c|} \hline \text {Roll no. } & \text {Marks} \\\hline 1&  10 \\\hline 2 & 20 \\\hline3 & 30  \\\hline 4 & \text{NULL}\\\hline \end{array}$$
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. $18.75$
  2. $20$
  3. $25$
  4. $\text{Null}$

7 Answers

–5 –5 votes
option a
Page:
Voting & Accepting an answer helps improve the community
Answer:
← Previous · GATE IT 2004 | Quest...Next → · GATE IT 2004 | Quest...
← Previous in category · GATE IT 2004 | Quest...Next in category → · GATE IT 2004 | Quest...
Position:
Show:

Related questions

51 51 votes
4 answers 4 answers
17.5k
17.5k views
Ishrat Jahan asked Nov 2, 2014
17,527 views
GATE IT 2004 | Question: 78
Consider two tables in a relational database with columns and rows as follows:$$\overset{\text{Table: Student}}{\begin{array}{|c|c|c|} \hline \textbf {Roll_no} & \textbf{...
57 57 votes
7 answers 7 answers
19.6k
19.6k views
Ishrat Jahan asked Nov 2, 2014
19,569 views
GATE IT 2004 | Question: 74
A relational database contains two tables student and department in which student table has columns roll_no, name and dept_id and department table has columns dept_id and...
50 50 votes
2 answers 2 answers
12.9k
12.9k views
Ishrat Jahan asked Nov 2, 2014
12,882 views
GATE IT 2004 | Question: 79
Consider a table $T$ in a relational database with a key field $K$. A $B$-tree of order $p$ is used as an access structure on $K$, where $p$ denotes the maximum number of...
73 73 votes
10 answers 10 answers
23.9k
23.9k views
Ishrat Jahan asked Nov 2, 2014
23,857 views
GATE IT 2004 | Question: 77
Consider the following schedule $S$ of transactions $T1$ and $T2:$$${\begin{array}{l|l}\textbf{T1}& \textbf{T2} \\\hline\text{Read(A)} \\\text{A = A – 10}\\& \text{R...