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 : 8
A top-to-bottom relationship among the items in a database is established by a

Hierarchical schema
Network schema
Relational Schema
All of the above

Question No : 9
approach reduces time and effort required for design and lesser risk in database management.

Single global database
Multiple databases
Top-down approach
None of the above

Question No : 10
____ table store information about database or about the system.

SQL
System
Nested
None of these

Question No : 11
HSAM stands for .

Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method

Question No : 12
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

Instance
Program
Schema
Super Key

Question No : 13
SQL server stores index information in the _____system table

system indexes
syst indexes
sys indexes
sysind

Question No : 14
_____clause is an additional filter that is applied to the result.

Select
Order by
Group-by
Having