Database Management System (DBMS) Questions and Answers

This quiz consist of database management DBMS quiz questions in the form of multiple choice out of which only one option is correct.These questions should be prepared for various competitive exam.

Computer Science: Database Management System

1. The level of data abstraction which describes how the data is actually stored is?
[A] Physical level
[B] Conceptual level
[C] Storage Level
[D] File level
2. The level of abstraction describes only part of the entire database is called?
[A] Conceptual level
[B] View Level
[C] Procedural Level
[D] None of above
3. Object based data models are used in describing the abstraction of the following levels?
[A] Conceptual and view
[B] Only physical
[C] Physical and conceptual
[D] Only conceptual
4. An association of several structure of a data base can be expressed graphically by?
[A] Tuple
[B] Record
[C] Relationship
[D] Field
5. The overall logical structure of data base can be expressed graphically by?
[A] Data flow chart
[B] Flow chart
[C] Directed Graph
[D] Entity relationship diagram
6. In an object oriented model, one object can access data of another object by passing?
[A] Instance variable
[B] Variable
[C] Message
[D] Function
7. The collection of information stored in a database at a particular moment is?
[A] View
[B] Instance
[C] Scheme
[D] None of these
8. The overall design of a database is called?
[A] Scheme of the database
[B] The screen of database
[C] Structure of the database
[D] View of the database
9. The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
[A] entity integrity rule
[B] referential integrity constraint
[C] action assertion
[D] composite attribute
10. Three SQL, DDL, CREATE commands are ________ .
[A] Schema, Base and Table
[B] Key, Base and Table
[C] Base, Table and Schema
[D] Schema, Table and View

Comments: (Your feedback is valuable to us)

SAURAV KUMAR MAJI 1 month ago Reply collection

Shyam 1 month ago Reply


Arshad Khan 2 months ago Reply

Thank for creating such informative site. Kindly add more questions. Thanks.

kailash 6 months ago Reply

Hindi me nhi hote h kya

ritesh 7 months ago Reply

guys how to downoad pdf freom ths side ..i login many always show inactive account..

Admin 6 months ago

Hi you have to confirm your account by clicking on link we have sent in you email!

prince singh 8 months ago Reply

good work

Suman Kumar 8 months ago Reply

Nice... It would have been nicer if there were explanation

Admin 6 months ago

Hi you can contribute your explanations of all questions in discussion box. Thanks!

muhammad faisal 8 months ago Reply

its awosomeee

Emed Saleh 9 months ago Reply

very nice quiz

Kam 9 months ago Reply

Good Good

Kam 9 months ago Reply

Good Good

zubair gondal 9 months ago Reply


Indrajit Das 9 months ago Reply


Fakhry Hejazy 9 months ago Reply

good pdf

ABU TAHIR 9 months ago Reply