Consider the following relation schema of students. STUDENT (Rollno, Name,…

2021

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)

Attempted by 429 students.

Show answer & explanation

Correct answer: A

σ Marks > 80 (STUDENT)

Explore the full course: Up Lt Grade Assistant Teacher 2025