Home

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 : 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

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