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
Show Answer
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
Show Answer
193. Physical level is also known as
  • internal level
  • external level
  • conceptual level
  • view level
Show Answer
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
Show Answer
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
Show Answer
196. The level which has the view of whole enterprise without concern of physical storage
  • internal level
  • external level
  • conceptual level
  • view level
Show Answer
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
Show Answer
198. View level is also known as
  • internal level
  • external level
  • conceptual level
  • physical level
Show Answer
199. The following is a restricted view of database
  • internal level
  • external level
  • conceptual level
  • physical level
Show Answer
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
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test