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
301. ____________ data models are used to describe data at the lowest level
- Logical data model
- Physical data model
- Network data model
- None of the above
302. The data type which contains raw binary data otherwise the same as a LONG column is
- BFILE
- CLOB
- BLOB
- LONGRAW
303. A __________ provides the data security
- view
- Queries
- Commands
- All of the above
304. A ________ is an organized collection of logically related data.
- Column
- Composite attribute
- Database
- All of the above
305. . A ________ is an organized collection of logically related data.
- Column
- Composite attribute
- Database
- All of the above
306. Once the DBMS informs the user that a transaction has successfully completed, its effects should persist even if the system crashes before all its changes are reflected on disk. This property is called.
- consistency
- isolation
- durability
- atomicity
307. Name the buffer in which all the commands that are typed in are stored
- EDIT buffer
- STORE buffer
- both A & B
- none
308. How do you communicate with an RDBMS?
- using SQL
- using ORACLE
- using VC++
- none.
309. Deadlock occurs when
- transactions compete for the same resource.
- the DBMS cannot decide what to do next.
- the user requests a cascade abort
- a transaction cannot decide what to do next.
310. The role of a DBA includes which of the following topics?
- User interfaces, salary budgeting, performance monitoring.
- Supporting all programming languages which might be used with a database.
- Loading data, evaluating new database systems, performance monitoring.
- Installing databases, C++ programming, user support.