Database Management System MCQs Set-1

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