DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
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