Database Management System MCQs Set-1

Hello Friends , this particular section is well focused on the Frequently asked Database Management System  (DBMS ) Multiple Choice Questions and Answers – MCQs in the various competitive exam. the set of questions are very basic and easily understandable by  reader.we have kept the question hardness level to very basic.

 

Practice it now

 

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

 
Try Now Database Management System MCQs based online Test/Quiz