Current Affairs PDF

Computer Quiz : DBMS Set – 3

AffairsCloud YouTube Channel - Click Here

AffairsCloud APP Click Here

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
    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
    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
    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
    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
    B. query language

  6. All fields for a specific entity can be grouped together as a __________
    A. database
    B. file
    C. field
    D. record
    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
    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
    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
    D. data warehouse

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