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.

Related MCQs

• Any recursive view must be defined as the union of two subqueries: a                query that is nonrecursive and a                      query.
• Relational Algebra is a                      query language that takes two relations as input and produces another relation as an output of the query.
• Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
• 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
• 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.
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• The        condition allows a general predicate over the relations being joined.
• The____condition allows a general predicate over the relations being joined.