On This Page

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

Q1 | Primitive operations common to all record management system include
  • look-up
  • all of the options
  • print
  • sort
Q2 | Which of the following is not a relational database?
  • dbase iv
  • foxpro
  • reflex
  • 4th dimension
Q3 | A top-to-bottom relationship among the items in a database is established by a
  • hierarchical schema
  • all of the options
  • network schema
  • relational schema
Q4 | Choose the RDBMS which supports full fledged client server application development
  • dbase v
  • ingress
  • oracle 7.1
  • foxpro 2.1
Q5 | The highest level in the hierarchy of data organization is called
  • data base
  • data record
  • data bank
  • data file
Q6 | The management information system (MIS) structure with one main computer system is called a
  • decentralized mis structure
  • centralized mis structure
  • hierarchical mis structure
  • distributed mis structure
Q7 | In the DBMS approach, application programs perform the
  • storage function
  • access control
  • all of the options
  • processing functions
Q8 | Which of the following is not true of the traditional approach to information processing
  • it is file oriented
  • it is inflexible
  • there is common sharing of data among the various applications
  • programs are dependent on the file
Q9 | Batch processing is appropriate if
  • only a few transactions are involved
  • none of the options
  • large computer system is available
  • only a small computer system is avilbale
Q10 | Large collection of files are called
  • sectors
  • database
  • fields
  • records
Q11 | A transparent DBMS
  • both can not hide sensitive information from users and keeps its logical structure hidden from users
  • keeps its physical structure hidden from users
  • can not hide sensitive information from users
  • keeps its logical structure hidden from users
Q12 | A file produced by a spreadsheet
  • none of the options
  • is generally stored on disk in an ascii text fromat
  • can be used as is by the dbms
  • both is generally stored on disk in an ascii text fromat and can be used as is by the dbms
Q13 | The model for a record management system might be
  • all of the options
  • a business form
  • handwritten list
  • a rolodex card file
Q14 | Database management systems are intended to
  • eliminate data redundancy
  • establish relationship among records in different files
  • manage file access and maintain data integrity
  • all of the options
Q15 | The language used application programs to request data from the DBMS is referred to as the
  • ddl
  • all of the options
  • dml
  • query language
Q16 | A set of programs that handle a firm's database responsibilities is called
  • database management system (dbms)
  • data management system (dms)
  • all of the options
  • database processing system (dbps)
Q17 | In a large DBMS
  • each subschema contains every field in the logical schema
  • each user can access every subschema
  • none of the options
  • each user can "see" only a small part of the entire database
Q18 | In a large DBMS
  • none of the options
  • each user can "see" only a small part of the entire database
  • each subschema contains every field in the logical schema
  • each user can access every subschema
Q19 | A Database Management System (DBMS) is
  • collection of interrelated data
  • collection of programs to access data
  • collection of data describing one particular enterprise
  • all of the above
Q20 | Which of the following is not a level of data abstraction?
  • physical level
  • critical level
  • logical level
  • view level
Q21 | Disadvantages of File systems to store data is:
  • data redundancy and inconsistency
  • difficulty in accessing data
  • data isolation
  • all of the above
Q22 | In an Entity-Relationship Diagram Rectangles represents
  • entity sets
  • attributes
  • database
  • tables
Q23 | Which of the following is not a Storage Manager Component?
  • transaction manager
  • logical manager
  • buffer manager
  • file manager
Q24 | 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 of the above
Q25 | Which of the following is not an Schema?
  • database schema
  • physical schema
  • critical schema
  • logical schema