DBMS Multiple choice Questions and Answers-Data Models

21.	The view of total database content is
a.	Conceptual view
b.	Internal view
c.	External view
d.	Physical view

Discuss

Answer: (a).Conceptual view

22.	Architecture of the database can be viewed as
a.	two levels
b.	four levels
c.	three levels
d.	one level

Discuss

Answer: (c).three levels

23.	In the architecture of a database system external level is the
a.	physical level
b.	logical level
c.	conceptual level
d.	view level

Discuss

Answer: (d).view level

24.	In a Hierarchical model records are organized as
a.	Graph
b.	List
c.	Links
d.	Tree

Discuss

Answer: (d).Tree

25.	A logical schema
a.	is the entire database
b.	is a standard way of organizing information into accessible parts
c.	describes how data is actually stored on disk
d.	both a and c

Discuss

Answer: (a).is the entire database

26.	Conceptual design
a.	is a documentation technique.
b.	needs data volume and processing frequencies to determine the size of the database.
c.	involves modelling independent of the DBMS.
d.	is designing the relational model.

Discuss

Answer: (c).involves modelling independent of the DBMS.

Discuss

Answer: (c).the external view

Discuss

Answer: (a).Network Model

29.	The conceptual model is
a.	dependent on hardware
b.	dependent on software
c.	dependent on both hardware and software
d.	independent of both hardware and software

Discuss

Answer: (d).independent of both hardware and software

30.	Which of the following is record based logical model?
a.	Network Model
b.	Object oriented model
c.	E-R Model
d.	None of these

Discuss

Answer: (a).Network Model