1
GATE CSE 2013
MCQ (Single Correct Answer)
+2
-0.6

Consider the following relational schema.

Students(rollno: integer, sname: string)

Courses(courseno: integer, cname: string)

Registration(rollno: integer, courseno: integer, percent: real)

Which of the following queries are equivalent to this query in English?

"Find the distinct names of all students who score more than 90% in the course numbered 107"

(I) SELECT DISTINCT S.sname 
FROM Students as S, Registration as R 
WHERE R.rollno=S.rollno AND 
R.courseno=107 AND R.percent >90

(II) ∏snamecourseno = 107 ∧ percent > 90 (Registration ⋈ Students))

(III) { T | ∃S ∈ Students, ∃R ∈ Registration ( S.rollno=R.rollno ∧ R.courseno=107 ∧ R.percent > 90 ∧ T.sname=S.sname)}

(iv) { < SN >| ∃SR∃RP ( < SR, SN > ∈ Students ∧ ∈ Registration ∧ RP > 90)}

A
I, II, III and IV
B
I, II and III only
C
I, II and IV only
D
II, III and IV only
2
GATE CSE 2013
MCQ (Single Correct Answer)
+1
-0.3
The smallest integer that can be represented by an $$8$$-bit number in $$2's$$ complement form is
A
$$-256$$
B
$$-128$$
C
$$-127$$
D
$$0$$
3
GATE CSE 2013
MCQ (Single Correct Answer)
+1
-0.3
Which one of the following expressions does NOT represent exclusive NOR of $$x$$ and $$y?$$
A
$$xy+x'y'$$
B
$$x \otimes y'$$
C
$$x' \otimes y$$
D
$$x' \otimes y'$$
4
GATE CSE 2013
MCQ (Single Correct Answer)
+1
-0.3
In the following truth table $$V=1$$ if and only if the input is valid. GATE CSE 2013 Digital Logic - Combinational Circuits Question 14 English

What function does the truth table represent?

A
Priority encoder
B
Decoder
C
Multiplexer
D
Demultiplexer
EXAM MAP
Medical
NEET
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
CBSE
Class 12