DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q211
The _______ takes care of accessing the physically stored file
  • A file manager
  • B query manager
  • C buffer manager
  • D database manager
Answer: Option A
Q212
One of the following is not a Object Based logical model
  • A ER model
  • B Object Oriented model
  • C Binary Model
  • D Network model
Answer: Option D
Q213
.___________ is an association among several entities
  • A Cardinality
  • B Mapping
  • C Relationship
  • D class
Answer: Option C
Q214
Objects that contain the same types of values and same methods are grouped into
  • A relations
  • B classes
  • C attributes
  • D tuples
Answer: Option B
Q215
This model has fixed format records
  • A ER model
  • B Object Oriented model
  • C Record based logical model
  • D Relational model
Answer: Option C
Q216
Which model(s) is(are) implementation data model s i)ER model ii)Relational iii.)Network iv)Hierarchical model
  • A i only
  • B i and ii
  • C i ,ii and iii
  • D i ,ii ,iii and iv
Answer: Option A
Q217
The collection of allocated memory and the running processes on the server is called
  • A snapshot
  • B instance
  • C both a and b
  • D none
Answer: Option C
Q218
The property of existence of data is called
  • A Persistent
  • B transient
  • C snapshot
  • D instance
Answer: Option A
Q219
Which DBMS allows a single database to be split apart such that its pieces reside at geographically separated sites.
  • A Object Oriented DBMS
  • B ER model
  • C Distributed DBMS
  • D Centralized DBMS
Answer: Option C
Q220
To store both numbers and characters in database which data type u prefer?
  • A Number
  • B Character
  • C Varchar
  • D String
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test