Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?

Related MCQs

• Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
• Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• The        algorithm scans each index for pointers to tuples that satisfy an individual condition.
• If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by
• In a                            operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.
• 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.
• Using the              clause retains only one copy of such identical tuples.
• Which oracle is the join condition is specified using the WHERE clause:
• Which of the following SQL clauses is used to DELETE tuples from a database table?