DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
191. The persons who interact with the system through DML calls embedded in a program written in host language
- System developers
- System analysts
- DBA
- Application Programmers
192. This level of abstraction is concerned with the physical storage of the information.
i)Physical level
ii)Conceptual level
iii)View level
- i only
- i and ii
- i,ii and iii
- none
193. Physical level is also known as
- internal level
- external level
- conceptual level
- view level
194. Storage allocation and access paths are considered in this level.
i)Physical level
ii)Conceptual level
iii)View level
- i only
- i and ii
- i,ii and iii
- none
195. The following schema hides the details of physical storage structures and concentrates on describing entities, data types and relationships.
- internal schema
- external schema
- conceptual schema
- view schema
196. The level which has the view of whole enterprise without concern of physical storage
- internal level
- external level
- conceptual level
- view level
197. A school prepared a timetable describing the entire details of teaches,hours etc.
This does not contain any allocation of rooms etc.,This comes under which level.
- internal level
- external level
- conceptual level
- view level
198. View level is also known as
- internal level
- external level
- conceptual level
- physical level
199. The following is a restricted view of database
- internal level
- external level
- conceptual level
- physical level
200. Suppose in the time table prepared by a college,if a lecturer is interested to see only his classes and if a student is interested to see only his lecturers,then this type of view can be
- internal level
- external level
- conceptual level
- physical level