Hello Friends,this particular section is well focused on the Frequently asked; DBMS Multiple Choice Questions with Answers 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.
 

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

 
 
You may be interested in:
Database Management System Basics MCQs
Database Management System Online Tests
Database Management System Short Questions With Answers
Database Management System Tutorials