Database Management System MCQs Set-4

PropellerAds
  1. 1. Count function in SQL returns the number of
    • values
    • distinct values
    • groups
    • columns
  2. 2. It is possible to define a schema completely using
    • VDL and DDL.
    • DDL and DML.
    • SDL and DDL.
    • VDL and DML.
  3. 3. The statement in SQL which allows to change the definition of a table is
    • Alter
    • Update
    • Create
    • select
  4. 4. E-R model uses this symbol to represent weak entity set ?
    • Dotted rectangle.
    • Diamond
    • Doubly outlined rectangle
    • None of these
  5. 5. SET concept is used in :
    • Network Model
    • Hierarchical Model
    • Relational Model
    • None of these
  6. 6. Relational Algebra is
    • Data Definition Language .
    • Meta Language
    • Procedural query Language
    • None of the above
  7. 7. The conceptual model is
    • dependent on hardware.
    • dependent on software.
    • dependent on both hardware and software .
    • independent of both hardware and software.
  8. 8. What is a relationship called when it is maintained between two entities?
    • Unary
    • Binary
    • Ternary
    • Quaternary
  9. 9. Which of the following operation is used if we are interested in only certain columns of a table?
    • PROJECTION
    • SELECTION
    • UNION
    • JOIN
  10. 10. Which of the following operations need the participating relations to be union compatible?
    • UNION
    • INTERSECTION
    • DIFFERENCEqq
    • All of the above

Practice Now – Database Management System Online tests