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
211. The _______ takes care of accessing the physically stored file
- file manager
- query manager
- buffer manager
- database manager
212. One of the following is not a Object Based logical model
- ER model
- Object Oriented model
- Binary Model
- Network model
213. .___________ is an association among several entities
- Cardinality
- Mapping
- Relationship
- class
214. Objects that contain the same types of values and same methods are grouped into
- relations
- classes
- attributes
- tuples
215. This model has fixed format records
- ER model
- Object Oriented model
- Record based logical model
- Relational model
216. Which model(s) is(are) implementation data model s i)ER model ii)Relational iii.)Network iv)Hierarchical model
- i only
- i and ii
- i ,ii and iii
- i ,ii ,iii and iv
217. The collection of allocated memory and the running processes on the server is called
- snapshot
- instance
- both a and b
- none
218. The property of existence of data is called
- Persistent
- transient
- snapshot
- instance
219. Which DBMS allows a single database to be split apart such that its pieces reside at geographically separated sites.
- Object Oriented DBMS
- ER model
- Distributed DBMS
- Centralized DBMS
220. To store both numbers and characters in database which data type u prefer?
- Number
- Character
- Varchar
- String