Consider a relational database containing the following schemas.
The primary key of each table is indicated by underlying the constituent fields.
SELECT s.sno, s.sname
FROM Suppliers s, Catalogue c
WHERE s.sno = c.sno AND
Cost > (SELECT AVG (cost)
FROM Catalogue
WHERE pno = ‘P4’
GROUP BY pno);
The number of rows returned by the above SQL query is
A
4
B
5
C
2
D
0
2
GATE CSE 2020
MCQ (Single Correct Answer)
+1
-0.33
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?
A
Rectangles with double/bold border
B
Diamonds with double/bold border
C
Ovals that contain underlined identifiers
D
Ovals with double/bold border
3
GATE CSE 2020
MCQ (Single Correct Answer)
+2
-0.67
Consider the Boolean function z(a,b,c).
Which one of the following minterm lists represents the circuit given above?
A
z = $$\sum {\left( {0,1,3,7} \right)} $$
B
z = $$\sum {\left( {1,4,5,6,7} \right)} $$
C
z = $$\sum {\left( {2,4,5,6,7} \right)} $$
D
z = $$\sum {\left( {2,3,5} \right)} $$
4
GATE CSE 2020
Numerical
+1
-0
If there are m input lines and n output lines for a decoder that is used to uniquely address a byte addressable 1 KB RAM, then the minimum value of m + n is ____.
