Home
Home >> Computer>> DBMS

DBMS MCQ Question with Answer

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

Download DBMS MCQ Question Answer PDF

Try DBMS Mock Test

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.
View Answer   Discuss

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
View Answer   Discuss

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

Chain
Network
Tree
Relational
View Answer   Discuss

Question No : 18
_____is a full form of SQL.

Standard query language
Sequential query language
Structured query language
Server side query language
View Answer   Discuss

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

Constraints
Triggers
Stored procedure
Cursors
View Answer   Discuss

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

an attribute
a tuple
a criteria
a relation
View Answer   Discuss

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
View Answer   Discuss

Wanna test your skill? Here are some exams we prepared for you. So if you need to test your skill just attempt any exam from bellow.

Exam Name No. Of Q Link
Computer set 1 30 Start
Computer set 2 30 Start
Computer set 3 30 Start
Computer set 4 30 Start
Computer set 5 30 Start
Computer set 6 30 Start
Computer set 7 30 Start
Computer set 8 30 Start
Computer set 9 30 Start
Computer set 10 30 Start
Computer set 11 30 Start
Computer set 12 30 Start