Computer Awareness Quiz – Set 3 (DBMS Advanced)

Computer Awareness Quiz: Computer Awareness is one of the sections in Exams like IBPS RRB, FCI etc. So we have started this series of Quiz on Computer Awareness. These questions are most important for banking exams. So attempt all the sets now.

  1. Feature in database that a user is able to access only the information for he/she is provided access is known as?
    A) Database Protection

    B) Database Maintenance
    C) Database Abstraction
    D) Database Security
    View answer
      Option C
    Explanation: Database Abstraction
  2. Which of the following is not a Database model?
    A) Dish model

    B) Hierarchical database model
    C) Relational model
    D) Network model
    View answer
      Option A
    Explanation: There are many types of model: Hierarchical database model- Relational model; Network model; Object-oriented database model; Entity-relationship model; Document model; Entity-attribute-value model; Star schema
  3. The DBMS acts as an interface between which two components?
    A) Data and database

    B) Database and Database application
    C) Database and User
    D) User and Database application
    View answer
    Option C
    Explanation: The user extracts the data stored in the database using a DBMS tool. Hence the DBMS tool acts as a link between the database and the user
  4. Which of the following is not a component of database?
    A) metadata

    B) procedure
    C) end user
    D) reports
    View answer
    Option D
    Explanation: Database has following components- Software- The DBMS software ; Data – metadata i.e data about the data; Procedures- refer to general instructions to use a database management system.; Database Access Language; and Users
  5. The practice of examining large pre-existing databases in order to generate new information is known as?
    A) Data Factoring

    B) Data Mining
    C) Data Linking
    D) Data Searching
    View answer
    Option B
    Explanation: Data Mining
  6. _________ is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis.
    A) Text Mining

    B) Work Data
    C) Integrity Data
    D) Big Data
    View answer
    Option D
    Explanation: extremely large data sets that may be analysed computationally to reveal patterns, trends, and associations, especially relating to human behaviour and interactions.
  7. What does R stands for in RDBMS?
    A) Relational

    B) Relative
    C) Rotational
    D) Remedial
    View answer
    Option A
    Explanation: Relational Database Management Systems
  8. The technique for collecting and managing data from varied sources to provide meaningful business insights is known as?
    A) data warehouse

    B) data sourcing
    C) data outsourcing
    D) data mining
    View answer
    Option A
    Explanation: A data warehousing is defined as a technique for collecting and managing data from varied sources to provide meaningful business insights.
  9. A data ______ is a subset of a data warehouse oriented to a specific business line.
    A) mart

    B) shop
    C) bizz
    D) mall
    View answer
    Option A
    Explanation: Data Mart
  10. A _______ is a vast pool of raw data, the purpose for which is not yet defined.
    A) data warehouse

    B) data mart
    C) data pool
    D) data lake
    View answer
    Option D
    Explanation: data lake- collection of data whose end use is not known; data warehouse- collection of huge data whose purpose is known

Click Here for More Computer Quiz

Click Here for Computer Study Material

Leave a Comment

Your email address will not be published. Required fields are marked *