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”.
Answer: A. σ Marks > 80 (STUDENT) — σ Marks > 80 (STUDENT)
- A.
σ Marks > 80 (STUDENT)
- B.
π Marks > 80 (STUDENT)
- C.
σ Marks < 80 (STUDENT)
- D.
π Marks < 80 (STUDENT)
Attempted by 895 students.
Show answer & explanation
Correct answer: A
σ Marks > 80 (STUDENT)
Loading lesson…