DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q311
Aborting a transaction
  • A removes changes made so far in the current transaction.
  • B removes changes made in a transaction after it has committed.
  • C is only possible in Microsoft Access.
  • D results in deadlock.
Answer: Option B
Q312
interaction with the file manager is the responsibility of _______
  • A data base manager
  • B data base designer
  • C data base administrator
  • D none.
Answer: Option A
Q313
back up and recovery is the responsibility of ___________
  • A data base manager
  • B data base designer
  • C data base administrator
  • D none.
Answer: Option C
Q314
_________ is the person having central control over data and programs accessing that data.
  • A data base manager
  • B data base designer
  • C data base administrator
  • D none.
Answer: Option C
Q315
the following are the roles of data base designer
  • A schema definition
  • B storage structure and access method definition
  • C schema and physical organization modification
  • D all the above.
Answer: Option D
Q316
making a change in the conceptual schema by not effecting the external schema is called
  • A physical data independence
  • B logical data independence
  • C functional dependency
  • D none.
Answer: Option B
Q317
Select the correct statement/s from among the following on proper naming of schema constructs:
  • A Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type
  • B In the narrative description of the database requirements, verbs tend to indicate the names of relationship types.
  • C The nouns arising from a database requirement description can be considered as names of attributes.
  • D Additional nouns which are appearing in the narrative description of the database requirements represent the weak entity type names.
Answer: Option B
Q318
Which of the following statement(s) is (are) true for database management systems?
  • A Provide protection for data against unexpected loss, damage or destruction.
  • B Allow maintenance of high quality, consistent and up to date data.
  • C Keep data and the programs that manipulate it together.
  • D both a & b
Answer: Option D
Q319
Which of the following statement(s) is (are) components of DBMS?
  • A Data dictionary/directory subsystem
  • B Security and integrity subsystem.
  • C Database administrator.
  • D both a & b
Answer: Option D
Q320
a table consists of ________
  • A spread sheet
  • B tuples and attributes
  • C descriptors
  • D none
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