Home / CSE MCQs / DBMS MCQs :: RDBMS

CSE MCQs :: DBMS MCQs

  1. Which one of the following is a procedural language ?
  2. A.
    Domain relational calculus
    B.
    Tuple relational calculus
    C.
    Relational algebra
    D.
    Query language

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
  4. A.
    Select
    B.
    Join
    C.
    Union
    D.
    Intersection

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
  6. A.
    Join
    B.
    Cartesian product
    C.
    Intersection
    D.
    Set difference

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. The _______operation performs a set union of two "similarly structured tables
  8. A.
    Union
    B.
    Join
    C.
    Product
    D.
    Intersect

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
  10. A.
    Join
    B.
    Projection
    C.
    Select
    D.
    Union

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
  12. A.
    Union
    B.
    Intersect
    C.
    Difference
    D.
    Projection

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
  14. A.
    Schema diagram
    B.
    Relational algebra
    C.
    Database diagram
    D.
    Schema flow

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. The _________ provides a set of operations that take one or more relations as input and return a relation as an output
  16. A.
    Schematic representation
    B.
    Relational algebra
    C.
    Scheme diagram
    D.
    Relation flow

    View Answer

    Workspace

    Discuss Discuss in Forum