- Computer Science Engineering (CSE)
- DataBase Management System (DBMS)
- Relational Modal
- Choose the option that correctly explain...

Q. |
## Choose the option that correctly explains in words, the function of the following relational algebra expression σyear≥2009 (book ⋈ borrow) |

A. | Selects all tuples from the Cartesian product of book and borrow |

B. | Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009 |

C. | Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009 |

D. | Selects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009 |

Answer» B. Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009 |

View all MCQs in:
DataBase Management System (DBMS)

- Which of the following is a fundamental operation in relational algebra?
- Which of the following is used to denote the selection operation in relational algebra?
- Which of the following is not a binary operator in relational algebra?
- The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
- The operation which is not considered a basic operation of relational algebra is
- 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.
- What action does ⋈ operator perform in relational algebra
- What does the “x” operator do in relational algebra?
- What action does ⋈ operator perform in relational algebra

Login to Continue

It will take less than 2 minutes

Report MCQ