How to retrieve data from relation ‘Professor’ where department name is…

2024

How to retrieve data from relation ‘Professor’ where department name is ‘Mathematics’ and salary is greater than ’65,000’?

  1. A.

    σdept_name = “Mathematics” ⋀ salary>65000 (Professor)

  2. B.

    σ “Mathematics” ⋀ salary>65000 (Professor)

  3. C.

    σdept_name = “Mathematics” and salary>65000 (Professor)

  4. D.

    σ salary>65000 (Professor) ⋀ dept_name = “Mathematics”

Attempted by 229 students.

Show answer & explanation

Correct answer: A

Ans : A

Solution

The select operation selects tuples that satisfy a given predicate. The lowercase Greek letter sigma (σ) is used to denote selection. The predicate appears as a subscript to (σ). The argument relation is in parentheses after the σ.

Explore the full course: Cognizant Preparation