GATEverse
← GATE CSE 2023

Q51

NAT2 marks

Consider the following table named Student\text{Student} in a relational database. The primary key of this table is rollNum.\text{rollNum}. Student\text{Student} $\begin{array}{|c|l|c|c|} \hline \underline{\text{rollNum}} & \text{name} & \text{gender} & \text{marks} \\ \hline \hline 1 & \text{Naman} & \mathrm{M} & 62 \\ \hline 2 & \text{Aliya} & \mathrm{F} & 70 \\ \hline 3 & \text{Aliya} & \mathrm{F} & 80 \\ \hline 4 & \text{James} & \mathrm{M} & 82 \\ \hline 5 & \text{Swati} & \mathrm{F} & 65 \\ \hline \end{array}$ The SQL\text{SQL} query below is executed on this database. SELECT * FROM Student WHERE gender = 'F' AND marks > 65; The number of rows returned by the query is ___________.

Sign in to save attempts.

Loading…