The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.

Related MCQs

• A                  on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.
• For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?
• Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
•                                allows a system administrator to associate a function with a relation; the function returns a predicate that must be added to any query that uses the relation.
• The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is               false and unknown is            while unknown and unknown is            
• In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?
• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• Which of the following is the clause that makes a singleton SELECT different from the normal SELECT?
• The                operator takes the results of two queries and returns only rows that appear in both result sets.
• An attribute in a relation is a foreign key if the                key from one relation is used as an attribute in that relation.