Relational Algebra Operations and Set Theory MCQ (Multiple Choice Questions) PDF Download

The types of binary operations includes

1. union
2. intersection
3. set difference
4. all of above

Consider two tuples X and Y, the operation whose result includes tuples that are only in X but not in Y is classified as

1. square of relation X and Y
2. union of relation X and Y
3. intersection of relation X and Y
4. difference of relation X and Y

The compatibility condition which states that the relations for union and intersection operations must consist of same type of tuples is classified as

1. union compatibility
2. intersect compatibility
3. row compatibility
4. column compatibility

Consider two tuples A and B, the operation whose result includes tuples that are included in both relations is classified as

1. intersection of relation A and B
2. difference of relation A and B
3. square of relation A and B
4. union of relation A and B

The process in which tuple is created by having combined attributes from two relations is classified as

1. Cartesian compatibility
2. Cartesian multiples
3. Cartesian product
4. Cartesian ordinate