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 three registers R1, R2 and R3 that store numbers in IEEE-754 single precision floating point format. Assume that R1 and R2 contain the values (in hexadecimal notation) 0x42200000 and 0xC1200000, respectively.
If R3 = $${{R1} \over {R2}}$$, what is the value stored in R3?
A
0x40800000
B
0x40800000
C
0xC8500000
D
0xC0800000
4
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?
