UTpaper

Free mock tests & test series

Question 101Asked in DSSSB PGT Computer Science (Technical), 11 Jul 2021

Consider the following relation schema of students. STUDENT (Rollno, Name, DOB, Marks, Gender)

Consider the following relation schema of students. STUDENT (Rollno, Name, DOB, Marks, Gender) Which of the given query is equivalent to this query in English? "Find the tuples of student having marks above 80".
  1. Aσ Marks>80 (STUDENT)
  2. BΠ Marks>80 (STUDENT)
  3. Cσ Marks<80 (STUDENT)
  4. DΠ Marks<80 (STUDENT)
Show answerHide answer

Correct answer: (A) σ Marks>80 (STUDENT)

Explanation

Selecting tuples (rows) that satisfy a condition uses σ: σ Marks>80 (STUDENT). Π selects columns, not rows.

From DSSSB PGT Computer Science PYQ (Technical), 11 Jul 2021

This is question 101 of DSSSB PGT Computer Science PYQ (Technical), 11 Jul 2021. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.