Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q261: The Join operation in relational algebra is essentially a special form of which operation?
- A: Cross Product
- B: Union
- C: Intersection
- D: Set Difference
View Answer
A
Q262: If two relations have the same number of attributes and the same domains, what operation can be performed?
- A: Set Difference
- B: Cartesian Product
- C: Intersection
- D: Union
View Answer
D
Q263: What is the symbol used for the Cartesian Product operation in relational algebra?
- A: ∪
- B: ×
- C: ∩
- D: σ
View Answer
B
Q264: In the Select operation, which symbol is used to represent the predicate?
- A: π
- B: σ
- C: ∪
- D: ∩
View Answer
B
Q265: What will be the result of applying the Project operator to a relation?
- A: A vertical subset of the table
- B: A horizontal subset of the table
- C: A new table with all attributes preserved
- D: A cross product of two relations
View Answer
A
Q266: In the given example, what attributes are selected by the Project operation on the FACULTY table?
- A: FacId and Salary
- B: facName and Dept
- C: FacId, Salary, and Rank
- D: FacId and Rank
View Answer
A
Q267: Which operation is used to find the tuples that appear in one relation but not in another?
- A: Set Difference
- B: Union
- C: Intersection
- D: Cartesian Product
View Answer
A
Q268: If two relations have different domains, what operation cannot be performed on them?
- A: Union
- B: Intersection
- C: Set Difference
- D: Cartesian Product
View Answer
D
Q269: Which operator requires that both relations have the same degree and domains?
- A: Union
- B: Cartesian Product
- C: Intersection
- D: Set Difference
View Answer
A
Q270: What will be the result of the Cartesian Product of two relations R and S with m attributes and C rows in R, and n attributes and D rows in S?
- A: A relation with m + n columns and C * D rows
- B: A relation with m + n columns and C + D rows
- C: A relation with m * n columns and C + D rows
- D: A relation with m * n columns and C * D rows
View Answer
A