DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q191
The persons who interact with the system through DML calls embedded in a program written in host language
  • A System developers
  • B System analysts
  • C DBA
  • D Application Programmers
Answer: Option D
Q192
This level of abstraction is concerned with the physical storage of the information. i)Physical level ii)Conceptual level iii)View level
  • A i only
  • B i and ii
  • C i,ii and iii
  • D none
Answer: Option A
Q193
Physical level is also known as
  • A internal level
  • B external level
  • C conceptual level
  • D view level
Answer: Option A
Q194
Storage allocation and access paths are considered in this level. i)Physical level ii)Conceptual level iii)View level
  • A i only
  • B i and ii
  • C i,ii and iii
  • D none
Answer: Option A
Q195
The following schema hides the details of physical storage structures and concentrates on describing entities, data types and relationships.
  • A internal schema
  • B external schema
  • C conceptual schema
  • D view schema
Answer: Option C
Q196
The level which has the view of whole enterprise without concern of physical storage
  • A internal level
  • B external level
  • C conceptual level
  • D view level
Answer: Option C
Q197
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.
  • A internal level
  • B external level
  • C conceptual level
  • D view level
Answer: Option C
Q198
View level is also known as
  • A internal level
  • B external level
  • C conceptual level
  • D physical level
Answer: Option B
Q199
The following is a restricted view of database
  • A internal level
  • B external level
  • C conceptual level
  • D physical level
Answer: Option B
Q200
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
  • A internal level
  • B external level
  • C conceptual level
  • D physical level
Answer: Option B

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test