With respect to relational algebra, which of the following operations are included for mathematical set theory?
(a) Join
(b) Intersection
(c) Cartisian product
(d) Project
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. (b) and (c)
Explanation
Union, intersection, difference and Cartesian product come from set theory; join and project are relational operations.
More Database Management Systems questions
- In relational databases, if relation is in , then which of the following is true about relation R ?
- Which of the following key constraints is required for functioning of foreign key in the context of relational databases?
- In relational database management, which of the following is/are property/properties of candidate key? P : Uniqueness Q : Irreducibility
- Which of the following statements are DML statements? (a) Update [tablename] = Set [ columnname] VALUE (b) Delete [tablename] (c) Select *…
- Hadoop (a big data tool) works with number of related tools. Choose from the following, the common tools included into Hadoop :
- A table has attributes Employee_id (primary key) and Manager_id (foreign key referencing Employee_id with ON DELETE CASCADE), with tuples (…