Loading, please wait ...
Open its course - Database Systems

Relational Algebra

  • Relational Algebra Operations
    • Unary Operation
      • Selection
      • Projection
    • Set Operations
      • Union
      • Set Difference
      • Intersection
      • Cartesian Product
      • Decomposing complex operations
    • Join...
      View Complete Description
      ×

      Topic Summary

      • Relational Algebra Operations
        • Unary Operation
          • Selection
          • Projection
        • Set Operations
          • Union
          • Set Difference
          • Intersection
          • Cartesian Product
          • Decomposing complex operations
        • Join Operations
          • Theta Join
          • Equijoin (a particular type of Theta join)
          • Natural join
          • Outer join
          • Semijoin
        • Division Operator
        • Aggregation Operations
        • Grouping Operations
      • Summary of Relational Algebra
Topic Questions:
63
MCQs T/F FiB SQ
30 16 14 3
Question Type Legends

Easy

Medium

Difficult
Open its course - Database Systems

Multiple Choice Questions for Relational Algebra

  • ×

    Hidden Questions!

    Some MCQs are not visible. Usually teachers hides their visibility if they are few in number. Subject Expert recommends them to have more than 70+ questions against the topic and make them public.

  • 1 Which of the following is a unary operation in relational algebra?
    1. Union
    2. Set Difference
    3. Projection
    4. Intersection

  • 2 Relational Algebra is a __________ query language that takes two relation as input and produces another relation as output of the query.
    1. Relational
    2. Structural
    3. Procedural
    4. Fundamental

  • 3 The _______ join can have all the six operators i.e. =, <>, >, <, >= and <=
    1. theta
    2. natural
    3. semi
    4. Equi

  • 4 Which type join defines a relation that contains the tuples of R that participate in the join of R with S.
    1. Semijoin
    2. Natural join
    3. Outer join
    4. Theta join

  • 5 _______ is an Equijoin of the two relations R and S over all common attributes x. One occurrence of each common attribute is eliminated from the result.?
    1. Equijoin
    2. Theta join
    3. Natural join
    4. Semijoin

Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn, Evaluate and Optimize

Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert