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
56
Questions
Question Type Legends

Easy

Medium

Difficult

Multiple Choice Questions for Relational Algebra

  • 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 and Evaluate

Follow Us
© 2020 - Subject Expert