DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q271
The ability to modify the schema definition in one level should not affect the schema definition in the next higher level is known as _____________
  • A Data Independence
  • B Data dependence
  • C Conceptual Independence
  • D none
Answer: Option A
Q272
Modification in physical level should not affect the logical level.This is
  • A Physical data independence
  • B Logical Data independence
  • C Conceptual Independence
  • D none
Answer: Option A
Q273
Modification in logical level should not affect the external level.This is
  • A Physical data independence
  • B Logical Data independence
  • C Conceptual Independence
  • D none
Answer: Option B
Q274
A__________ collection of conceptual tools for describing data, data relationships data semantics and constraints
  • A Data model.
  • B Object oriented model
  • C both A & B
  • D none
Answer: Option A
Q275
An attribute or attributes that uniquely identify each row in a relation is called a(n)
  • A field pointer.
  • B column.
  • C primary key.
  • D foreign key.
Answer: Option C
Q276
Data modeling may be the most important part of the systems development process because
  • A data characteristics are important in the design of programs and other systems components
  • B The data in a system are generally more complex than processes, and play a central role in development
  • C Data are less stable than processes
  • D A and B.
Answer: Option D
Q277
A database is an organized collection of _____ related data.
  • A not
  • B badly
  • C physically
  • D logically
Answer: Option D
Q278
Which of the following is an entity type on which a strong entity depends?
  • A member.
  • B weak.
  • C unary.
  • D owner.
Answer: Option D
Q279
Disadvantages of traditional file processing systems include
  • A reduced data duplication.
  • B program-data dependence
  • C limited data sharing
  • D B and C.
Answer: Option D
Q280
A(n) _____ specifies the number of instances of one entity that can be associated with the each instance of another entity
  • A maximum
  • B cardinality constraint
  • C limit
  • D counter constraint
Answer: Option B

📚 More from Database

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