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
201. The highest level of abstraction of data occurs in
- internal level
- external level
- conceptual level
- physical level
202. Which of the following schema defines the view level
- internal schema
- external schema
- conceptual schema
- none
203. Which of the following schema defines the physical level
- internal schema
- external schema
- conceptual schema
- none
204. Which of the following include definitions of each of the various types of data
- internal schema
- external schema
- conceptual schema
- none
205. The ability to modify the internal schema without causing any change to the external schema
- Physical data independence
- Logical Data independence
- External Data independence
- none
206. The ability to modify the conceptual schema without causing any change to the application program
- Physical data independence
- Logical Data independence
- External Data independence
- none
207. Which of the following processes the query to identify the basic operators that are contained in query.
- query optimizer
- query processor
- query analyzer
- query manager
208. Which of the following arrives at an correct execution plan of sequence of basic operators..
- query optimizer
- query processor
- query analyzer
- query manager
209. ._______decides the portions of data that should be transferred from secondary storage to the primary storage
- file manager
- query manager
- buffer manager
- database manager
210. The information about data in a databse is called _____
- Meta data
- Tera data
- hyper data
- none