UGC NET CS 2014 Dec – paper-3
September 19, 2024UGC NET CS 2018-DEC Paper-2
September 19, 2024Database-Management-System
| Question 3 |
Consider the following table named Student in a relational database. The primary key of this table is rollNum.
The 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 ____?
The 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 ____?
| 2 |
Question 3 Explanation:
Given query is SELECT * FROM Student WHERE gender = ‘F’ AND marks > 65;
There are a total 5 rows present in the student table.
Among 5 rows , three rows belong to gender “F” and from that three rows also, only two rows consist of marks greater than 65.So Given query returns only two rows.
There are a total 5 rows present in the student table.
Among 5 rows , three rows belong to gender “F” and from that three rows also, only two rows consist of marks greater than 65.So Given query returns only two rows.
Correct Answer: A
Question 3 Explanation:
Given query is SELECT * FROM Student WHERE gender = ‘F’ AND marks > 65;
There are a total 5 rows present in the student table.
Among 5 rows , three rows belong to gender “F” and from that three rows also, only two rows consist of marks greater than 65.So Given query returns only two rows.
There are a total 5 rows present in the student table.
Among 5 rows , three rows belong to gender “F” and from that three rows also, only two rows consist of marks greater than 65.So Given query returns only two rows.
Subscribe
Login
0 Comments