Home

DBMS MCQ - Multiple Choice Question and Answer

DBMS MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Download Objective type questions of DBMS PDF

Visit our PDF store

Question No : 15
The one guideline to be followed while designing the database is

A database design may be ambiguous.
It should avoid/reduce the redundancy.
Unrelated data should be in the same table so that updating the data will be easy.
An entity should not have attributes.

Question No : 16
A logical schema

is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above

Question No : 17
Which of the following is not a logical database structure?

Chain
Network
Tree
Relational

Question No : 18
_____is a full form of SQL.

Standard query language
Sequential query language
Structured query language
Server side query language

Question No : 19
______is a preferred method for enforcing data integrity

Constraints
Triggers
Stored procedure
Cursors

Question No : 20
A relational database developer refers to a record as

an attribute
a tuple
a criteria
a relation

Question No : 21
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______

Fields
Records
Relations
Keys