DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q201
The highest level of abstraction of data occurs in
  • A internal level
  • B external level
  • C conceptual level
  • D physical level
Answer: Option B
Q202
Which of the following schema defines the view level
  • A internal schema
  • B external schema
  • C conceptual schema
  • D none
Answer: Option B
Q203
Which of the following schema defines the physical level
  • A internal schema
  • B external schema
  • C conceptual schema
  • D none
Answer: Option A
Q204
Which of the following include definitions of each of the various types of data
  • A internal schema
  • B external schema
  • C conceptual schema
  • D none
Answer: Option C
Q205
The ability to modify the internal schema without causing any change to the external schema
  • A Physical data independence
  • B Logical Data independence
  • C External Data independence
  • D none
Answer: Option A
Q206
The ability to modify the conceptual schema without causing any change to the application program
  • A Physical data independence
  • B Logical Data independence
  • C External Data independence
  • D none
Answer: Option B
Q207
Which of the following processes the query to identify the basic operators that are contained in query.
  • A query optimizer
  • B query processor
  • C query analyzer
  • D query manager
Answer: Option B
Q208
Which of the following arrives at an correct execution plan of sequence of basic operators..
  • A query optimizer
  • B query processor
  • C query analyzer
  • D query manager
Answer: Option A
Q209
._______decides the portions of data that should be transferred from secondary storage to the primary storage
  • A file manager
  • B query manager
  • C buffer manager
  • D database manager
Answer: Option C
Q210
The information about data in a databse is called _____
  • A Meta data
  • B Tera data
  • C hyper data
  • D none
Answer: Option A

📚 More from Database

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