On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 1

Q1 | Where is metadata stored in MySQL?
  • in the mysql database meta
  • in the mysql database metasql
  • in the mysql database metadata
  • in the mysql database mysql
Q2 | What MySQL property is used to create a surrogate key in MySQL?
  • identical
  • unique
  • auto_increment
  • sequence
Q3 | A relational database consists of a collection of
  • keys
  • records
  • tables
  • fields
Q4 | A Database Management System (DBMS) is:
  • collection of data describing one particular enterprise
  • collection of programs to access data
  • all options are correct
  • collection of interrelated data
Q5 | Which of the following is not a level of data abstraction?
  • view level
  • physical level
  • logical level
  • critical level
Q6 | Disadvantages of File systems to store data is:
  • data isolation
  • data redundancy and inconsistency
  • difficulty in accessing data
  • all options are correct
Q7 | In an Entity Relationship Diagram Rectangles represents
  • tables
  • attributes
  • database
  • entity sets
Q8 | Which of the following is not a Storage Manager Component?
  • transaction manager
  • logical manager
  • file manager
  • buffer manager
Q9 | Data Manipulation Language enables users to
  • retrieval of information stored in database
  • insertion of new information into the database
  • deletion of information from the database
  • all the options are correct
Q10 | Which of the following is not an Schema?
  • logical schema
  • physical schema
  • database schema
  • critical schema
Q11 | Which of the following is Database Language?
  • data definition language
  • data manipulation language
  • data query language
  • all of the options
Q12 | Which of the following in not a function of DBA?
  • network maintenance
  • schema definition
  • authorization for data access
  • routine maintenance
Q13 | Which of the following is a Data Model?
  • entity relationship model
  • object based data model
  • all of the options are correct
  • relational data model
Q14 | A Database Management System (DBMS) is
  • collection of interrelated data
  • collection of data describing one particular enterprise
  • all of the options
  • collection of programs to access data
Q15 | Which of the following is not a level of data abstraction?
  • physical level
  • view level
  • critical level
  • logical level
Q16 | Disadvantages of File systems to store data is:
  • data redundancy and inconsistency
  • data isolation
  • all of the options
  • difficulty in accessing data
Q17 | Which of the following is not a Storage Manager Component?
  • transaction manager
  • buffer manager
  • file manager
  • logical manager
Q18 | Data Manipulation Language enables users to
  • retrieval of information stored in database
  • deletion of information from the database
  • all of the above
  • insertion of new information into the database
Q19 | Which of the following is not an Schema?
  • logical schema
  • critical schema
  • database schema
  • physical schema
Q20 | Which of the following is Database Language?
  • all of the options
  • query language
  • data definition language
  • data manipulation language
Q21 | Which of the following in not a function of DBA?
  • authorization for data access
  • network maintenance
  • routine maintenance
  • schema definition
Q22 | Which of the following is a Data Model?
  • object-based data model
  • all of the options
  • entity-relationship model
  • relational data model
Q23 | Column header is refer as
  • table
  • domain
  • attributes
  • relation
Q24 | _______ allow us to identify uniquely a tuple in the relation.
  • schema
  • superkey
  • domain
  • attribute
Q25 | Minimal Superkeys are called
  • schema keys
  • attribute keys
  • candidate keys
  • domain keys