Database Management System MCQs Set-1

PropellerAds
  1. 1. DBMS Stand for
    • Data base marginal system
    • Directory Based Memory Standard
    • Data Base Management System
    • Dual Bus Mask Storage
  2. 2. In the relational modes, cardinality is termed as:
    • Number of tuples.
    • Number of attributes.
    • Number of tables.
    • Number of constraints.
  3. 3. Relational calculus is a
    • Procedural language.
    • Non- Procedural language.
    • Data definition language.
    • High level language.
  4. 4. The view of total database content is
    • Conceptual view.
    • Internal view.
    • External view.
    • Physical View.
  5. 5. Cartesian product in relational algebra is
    • a Unary operator.
    • a Binary operator.
    • a Ternary operator.
    • not defined.
  6. 6. DML is provided for
    • Description of logical structure of database.
    • Addition of new structures in the database system.
    • Manipulation & processing of database.
    • Definition of physical structure of database system.
  7. 7. ‘AS’ clause is used in SQL for
    • Selection operation.
    • Rename operation.
    • Join operation.
    • Projection operation.
  8. 8. Architecture of the database can be viewed as
    • two levels.
    • four levels.
    • three levels.
    • one level.
  9. 9. In a relational model, relations are termed as
    • Tuples
    • Attributes
    • Tables
    • Rows
  10. 10. The database schema is written in
    • HLL
    • DML
    • DDL
    • DCL

Practice Now – Database Management System Online tests