Question

The select operation’s function in relational algebra is identical to the _______ clause in SQL

(a) where

(b) from

(c) select

(d) none of the mentioned

The question was asked during an interview for a job.

My question is from The Relational Algebra topic in chapter Intermediate and Advanced Sql of RDBMS

Answer 1

Correct choice is (a) where

Easiest explanation: The select operation’s function in relational algebra is identical to the where clause in SQL standard. It is therefore used to check for a particular condition.