Quiz  /  Business Intelligence Class 12 MCQ Questions With Answers

  • 1. 
    An entity has a set of ___________ that describe it.

  • Attributes
  • Entity
  • Tuples
  • Relations

  • 2. 
    ______________databases are owned by particular departments or business groups.

  • Informational.
  • Operational.
  • Both informational and operational.
  • Flat.

  • 3. 
    Record cannot be updated in _____________.

  • OLTP
  • files
  • RDBMS
  • data warehouse

  • 4. 
    The source of all data warehouse data is the____________.

  • operational environment.
  • informal environment.
  • formal environment.
  • technology environment.

  • 5. 
    __________describes the data contained in the data warehouse.

  • Relational data.
  • Operational data.
  • Metadata.
  • Informational data.

  • 6. 
    _________maps the core warehouse metadata to business concepts, familiar and useful to end users.

  • Application level metadata.
  • User level metadata.
  • Enduser level metadata.
  • Core level metadata.

  • 7. 
    ________________defines the structure of the data held in operational databases and used by operational applications.

  • User-level metadata.
  • Data warehouse metadata.
  • Operational metadata.
  • Data mining metadata.

  • 8. 
    ______is the structure of the database.

  • Table
  • Relation
  • Schema
  • None of these

  • 9. 
    This is an approach to selling goods and services in which a prospect explicitly agrees in advance to receive marketing information.

  • customer managed relationship
  • data mining
  • permission marketing
  • one-to-one marketing

  • 10. 
    The data is stored, retrieved & updated in ____________.

  • OLAP.
  • OLTP.
  • SMTP.
  • FTP.

  • 11. 
    The important aspect of the data warehouse environment is that data found within the data warehouseis ___________.

  • subject-oriented
  • time-variant.
  • integrated.
  • None of these

  • 12. 
    This is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions.

  • data mart
  • business information warehouse
  • business intelligence
  • data mining

  • 13. 
    This is the processing of data about customers and their relationship with the enterprise in order to improve the enterprise’s future sales and service and lower cost.

  • a. clickstream analysis
  • b. database marketing
  • c. customer relationship management
  • d. CRM analytics
  • e. B2C

  • 14. 
    Which level of database is viewed by user:

  • Internal level
  • External Level
  • Conceptual Level
  • All of these

  • 15. 
    The data Warehouse is__________.

  • A. read only.
  • B. write only.
  • C. read write only.
  • D. none.

  • 16. 
    Data warehouse architecture is based on ______________.

  • A. DBMS.
  • B. RDBMS.
  • C. Sybase.
  • D. SQL Server.

  • 17. 
    Business intelligence (BI) is a broad category of application programs which includes

  • a) Decision support
  • b) Data mining
  • c) OLAP
  • d) All of the mentioned

  • 18. 
    Data can be updated in _____environment.

  • data warehouse.
  • data mining.
  • operational.
  • informational.

  • 19. 
    __________ is the heart of the warehouse.

  • Data mining database servers.
  • Data warehouse database servers.
  • Data mart database servers.
  • Relational data base servers.
Report Question
warning
access_time
  Time