Computer Basics Set 29 (DBMS)

  1. DBMS stands for _______?
    A) Data Base Management System
    B) Data Basic Multiple System
    C) Data Base Multiple System
    D) Data Basic Management System
    View Answer
    Option A

  2. A database is a collection of related ____ ?
    A) program
    B) data
    C) functions
    D) hyperlink
    View Answer
    Option B

  3. A good Database Management System has which of the following property/properties?
    A) Maintains data integrity
    B) Ability to view the database from different viewpoints according to the requirements of the user
    C) Provide some level of security and access control to the data
    D) All of these
    View Answer
    Option D

  4. Which of the following is not a DBMS package?
    A) Microsoft Access
    B) PostgreSQL
    C) Adabas D
    D) All are DBMS software
    View Answer
    Option D

  5. When duplicate data is present at various places in a database, it is known as ____?
    A) Data Dependency
    B) Data Inconsistency
    C) Data Redundancy
    D) Data Efficiency
    View Answer
    Option C

    When the same data is present at various places in a database, it is known as Data Redundancy. It has a disadvantage because the content of these data at all places may differ creating a problem.
  6. If the common fields in a redundant data are not same, it is known as ______?
    A) Data Inconsistency
    B) Data Duplicity
    C) Data Efficiency
    D) Data Dependency
    View Answer
    Option A

  7. _______ is a large store of data accumulated from a wide range of sources within a company and used to guide management decisions.
    A) Data Mine
    B) Data Warehouse
    C) Data Storehouse
    D) Data Keeping
    View Answer
    Option B

    A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing.
  8. ______ is defined as a process used to extract usable data from a larger set of any raw data.
    A) Data mining
    B) Data Warehouse
    C) Data Keeping
    D) Data Storehouse
    View Answer
    Option A

  9. A _______ is a sequence of operations performed as a single logical unit of work in database.
    A) Method
    B) Function
    C) Array
    D) Transaction
    View Answer
    Option D

  10. A database _____ is a way to logically group objects such as tables, views, stored procedures
    A) Variable
    B) Schema
    C) Schedule
    D) Method
    View Answer
    Option B

Related posts