Table of Contents

    Relational Algebra and Calculus

    November 30, -0001 387 views

    MCQ Section

    MCQ 1
    Which of the following is the operation developed specifically for the relational databases?
    MCQ 2
    Which of the following is the set-oriented operation?
    MCQ 3
    Which of the following is the binary operation?
    MCQ 4
    Which of the following is true for a right outer join?
    MCQ 5
    Which of the following aggregate functions is used for counting tuples or values in a relation?
    MCQ 6
    Which of the following is the component of a tuple relational calculus expression?
    MCQ 7
    The truth value of a formula can be derived as __________.
    MCQ 8
    Which of the following is the symbol for an existential quantifier?
    MCQ 9
    Which of the following statements is true?
    MCQ 10
    Which of the following is not a rule for forming formula in domain relational calculus?
    MCQ 11
    Which of the following operation requires two tables as input and the two tables must have one common column?
    MCQ 12
    Which of the following is not a valid aggregate function?
    MCQ 13
    If relation R has m tuples and relation S has n tuples, then the result of join on relations R and S will have up to_________tuples.
    MCQ 14

    The result of R(A1, A2, …, Am)XS(B1, B2, …, Bn) is a relation with__________ attributes.
    MCQ 15
    The join operation where only matching tuples are kept in the result is called__________.
    MCQ 16
    Which of the following relational algebra operations require two tables as input with exactly the same attributes?
    MCQ 17
    Which of the following operations is used to select some required attributes from a relation while discarding the other attributes?
    MCQ 18
    Intersection operation is_____________.