The____condition allows a general predicate over the relations being joined.

Related MCQs

• The        condition allows a general predicate over the relations being joined.
• The ............ operator preserves unmatched rows of the relations being joined.
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
•                                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.
•              is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
• A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
• ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
• ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
• A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
• Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.