On This Page

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

Q1 | How many types of keys in Database Design?
  • foreign key
  • all of the options
  • candidate key
  • primary key
Q2 | Which of the following is based on Multi Valued Dependency?
  • third
  • fourth
  • first
  • second
Q3 | Which of the following is the structure of the Database?
  • table
  • none of these
  • schema
  • relation
Q4 | The minimal set of super key is called
  • primary key
  • secondary key
  • foreign key
  • candidate key
Q5 | ______________ is a classical approach to database design?
  • bottom – up approach
  • top – down approach
  • left – right approach
  • right – left approach
Q6 | _____________ refers to the correctness and completeness of the data in a database?
  • data independence
  • data integrity
  • data security
  • data constraint
Q7 | A table that displays data redundancies yields ____________ anomalies
  • insertion
  • deletion
  • update
  • all of the options
Q8 | A lock that allows concurrent transactions to access different rows of the same table is known as a
  • row-level lock
  • database-level lock
  • field-level lock
  • table-level lock
Q9 | A type of query that is placed within a WHERE or HAVING clause of another query is called
  • multi-query
  • sub query
  • super query
  • master query
Q10 | A form defined
  • none of the options
  • where data is placed on the screen
  • the width of each field
  • both where data is placed on the screen and the width of each field
Q11 | If a piece of data is stored in two places in the database, then
  • in can be more easily accessed
  • both storage space is wasted and changing the data in one spot will cause data inconsistency
  • storage space is wasted
  • changing the data in one spot will cause data inconsistency
Q12 | Which of the following is a problem of file management system?
  • data redundancy and program dependence
  • all of the options
  • difficult to update
  • lack of data independence
Q13 | Which of the following is not an advantage of the database approach
  • elimination of data redundancy
  • ability of associate deleted data
  • increased security and program/data independence
  • all of the above
Q14 | An audit trail
  • none of the options
  • is the recorded history of operations performed on a file
  • is used to make backup copies
  • can be used to restore lost information
Q15 | One approach to standardization storing of data?
  • codasyl specification
  • none of the options
  • mis
  • structured programming
Q16 | Report generators are used to
  • store data input by a user
  • answer queries
  • both retrieve information from files and answer queries
  • retrieve information from files
Q17 | Which of the following is true of a network structure?
  • it will be dominant data base of the future
  • it allows a many-to-many relationship
  • it is a physical representation of the data
  • it is conceptually simple
Q18 | A record management system
  • can handle many files of information at a time
  • always uses a list as its model
  • both can handle many files of information at a time and always uses a list as its model
  • can be used to extract information stored in a computer file
Q19 | One data dictionery software package is called
  • db/dc dictionary
  • datapac
  • total
  • access
Q20 | The function of a database is ...
  • to check all input data
  • to output data
  • to collect and organize input data
  • to check all spelling
Q21 | A command that lets you change one or more fields in a record is
  • none of the options
  • modify
  • insert
  • lookup
Q22 | What is the language used by most of the DBMSs for helping their users to access data?
  • high level language
  • 4gl
  • query language
  • sql
Q23 | Information can be transferred between the DBMS and a
  • spreadsheet program
  • word processor program
  • graphics program
  • all of the options
Q24 | The relational database environment has all of the following components except
  • users
  • database
  • query languages
  • separate files
Q25 | The ascending order of a data hirerchy is:
  • bit-byte-file-record-field-database
  • bit-byte-field-record-file-database
  • bit-byte-record-field-file-database
  • byte-bit-field-record-file-database