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.
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
An association of several structure of a data base can be expressed graphically by?
[A] Tuple
[B] Record
[C] Relationship
[D] Field
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
In an object oriented model, one object can access data of another object by passing?
[A] Instance variable
[B] Variable
[C] Message
[D] Function
The collection of information stored in a database at a particular moment is?
[A] View
[B] Instance
[C] Scheme
[D] None of these
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
Are these questions helpful for you?

Post your questions here and start a good conversation with experties and users.

Comments: (Your feedback is valuable to us)

Lakshmi 1 week ago Reply

How can it download

Mushkin 4 months ago Reply

Nice it is very use full...

vanusquarm 5 months ago Reply

That's a great piece

Ebsa Girma 7 months ago Reply


shweta 1 year ago Reply

how can i doenload it

hefza abid 1 year ago Reply

really very appriciated................
good work
keep it up.........................

sathish 2 years ago Reply

This website all questions very usefull for me

sunila 2 years ago Reply

8th question answer is schema, not scheme.please correct it.

Bless Eshun 2 years ago Reply

This site is very educative, please keep it up

nitu tiwari 2 years ago Reply

very nice coolection