DBMS MCQ Questions and Answers

Take Exam

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

221. A ___________ is a structure that stores and protects data

  • Instance
  • Snapshot
  • Persistent
  • Repository
Show Answer Report

222. A ___________ is a sequence of database operations.

  • Instance
  • Snapshot
  • Persistent
  • Transaction
Show Answer Report

223. The following is not a level of abstraction

  • conceptual
  • view
  • persistent
  • internal
Show Answer Report

224. The network model uses the concept of

  • Node
  • Tree
  • Queue
  • Stack
Show Answer Report

225. The relation model is truly a_______________ based model

  • Mathematically
  • Physically
  • Chemically
  • none
Show Answer Report

226. What is the language used for queries in RDBMS

  • Perl
  • Cobol
  • SQL
  • None
Show Answer Report

227. The instance of a class used in OO model is

  • Object
  • Subject
  • Structure
  • Union
Show Answer Report

228. State True or false , != ,<>,^= denote the same operation

  • True
  • False
  • Cannot say
  • None
Show Answer Report

229. The data model that is widely accepted and used is

  • RDBMS
  • Network model
  • Hierarchical model
  • Cannot say
Show Answer Report

230. A _________ is a collection of facts

  • System
  • Data
  • Star
  • None
Show Answer Report
Questions and Answers for Competitive Exams Various Entrance Test