Computer Quiz : DBMS Set – 3

Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in DBMS. It will be very useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.

1. Which of the following is/are advantages of DBMS?
   A. Increased Security
   B. Data Integrity
   C. Avoids Data redundancy
   D. All of the Above
   
   Answer

   D. All of the Above
   
   
2. The process of keeping information uniform is called _______
   A. Data consistency
   B. Data redundancy
   C. Increased Security
   D. None of the Above
   
   Answer

   A. Data consistency
   
   
3. _________ is a form of database management that keeps data separated from all programs that make use of it.
   A. Data independence
   B. Data redundancy
   C. Increased Security
   D. None of the Above
   
   Answer

   A. Data independence
   
   
4. The specific representation of an external view, that is, the end user’s view of the data environment is known as __________
   A. External Schema
   B. Internal schema
   C. Both (A) and (B)
   D. None of the Above
   
   Answer

   A. External Schema
   
   
5. The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________
   A. access control
   B. query language
   C. table generator
   D. security system
   
   Answer

   B. query language
   
   
6. All fields for a specific entity can be grouped together as a __________
   A. database
   B. file
   C. field
   D. record
   
   Answer

   D. record
   
   
7. A record consists of a _______
   A. group of files
   B. character
   C. collection of related records
   D. set of one or more fields
   
   Answer

   D. set of one or more fields
   
   
8. The design of a _________ database recognizes the use of historical and aggregated data.
   A. multiuser
   B. data warehouse
   C. single-user
   D. production
   
   Answer

   B. data warehouse
   
   
9. The ________ is a specialized database that stores data in a format optimized for decision support.
   A. production database
   B. distributed database
   C. workgroup database
   D. data warehouse
   
   Answer

   D. data warehouse
   
   
10. Another name for a production database is a _______ database.
    A. data mining
    B. development
    C. warehousing
    D. transactional
    
    Answer

    D. transactional