UGC NET June-2019 CS Paper-2
August 13, 2024Computer-Networks
August 13, 2024Database-Management-System
|
Question 5
|
Consider the relational database with the following four schemas and their respective instances.
Student(sNo, sName, dNo) Dept(dNo, dName)
Course(cNo, cName, dNo)
Register(sNo, cNo)
The number of rows returned by the above SQL query is___________.
Student(sNo, sName, dNo) Dept(dNo, dName)
Course(cNo, cName, dNo)
Register(sNo, cNo)
The number of rows returned by the above SQL query is___________.
|
2
|
Question 5 Explanation:
Final result of the given SQL query is:
—–+———+——+
| sNo | sName | dNo |
+—–+———+——+
| S01 | James | D01 |
| S04 | Jane | D01 |
+—–+———+——+
—–+———+——+
| sNo | sName | dNo |
+—–+———+——+
| S01 | James | D01 |
| S04 | Jane | D01 |
+—–+———+——+
Correct Answer: A
Question 5 Explanation:
Final result of the given SQL query is:
—–+———+——+
| sNo | sName | dNo |
+—–+———+——+
| S01 | James | D01 |
| S04 | Jane | D01 |
+—–+———+——+
—–+———+——+
| sNo | sName | dNo |
+—–+———+——+
| S01 | James | D01 |
| S04 | Jane | D01 |
+—–+———+——+