1 $Which of the following best defines 'data' in the context of digital information?$

A.

Software applications used for analysis

B.

Raw, unorganized facts and figures

C.

Processed information ready for decision making

D.

Visual charts and graphs

2 $Which type of data resides in fixed fields within a record or file, such as Relational Database Management Systems (RDBMS)?$

A.

Semi-structured Data

B.

Structured Data

C.

Unstructured Data

D.

Abstract Data

3 $Emails, videos, and social media posts are primarily examples of which type of data?$

A.

Structured Data

B.

Normalized Data

C.

Semi-structured Data

D.

Unstructured Data

4 $XML and JSON files are classic examples of which data category?$

A.

Structured Data

B.

Unstructured Data

C.

Semi-structured Data

D.

Raw Data

5 $What is a major limitation of traditional databases (RDBMS) when dealing with modern big data?$

A.

They cannot perform mathematical calculations

B.

Difficulty in scaling horizontally and handling unstructured data

C.

They lack security features

D.

They cannot handle structured data

6 $OLTP stands for:$

A.

Offline Transaction Protocol

B.

Online Transaction Processing

C.

Online Analytical Processing

D.

Online Text Processing

7 $What is the primary goal of an OLTP system?$

A.

Fast query processing and data integrity for transactions

B.

Complex data analysis

C.

Historical data archiving

D.

Generating executive dashboards

8 $Which system is primarily used for decision support, planning, and problem-solving?$

A.

OLTP

B.

RDBMS

C.

OLAP

D.

ATM Systems

9 $In the context of data volatility, how do OLTP and OLAP differ?$

A.

Both are highly volatile

B.

Both are non-volatile

C.

OLTP data is static; OLAP data is volatile

D.

OLTP data is volatile; OLAP data is non-volatile

10 $Business Intelligence (BI) can best be described as:$

A.

The process of backing up database files

B.

Strategies and technologies used for data analysis and management

C.

A method for securing network connections

D.

A specific software tool for writing SQL queries

11 $Which of the following is an early predecessor to modern BI, designed for middle managers?$

A.

MIS (Management Information Systems)

B.

IoT (Internet of Things)

C.

AI (Artificial Intelligence)

D.

EIS (Executive Information Systems)

12 $What is the primary function of an Executive Information System (EIS)?$

A.

To manage customer support tickets

B.

To provide senior executives with easy access to internal and external data

C.

To process daily operational transactions

D.

To compile code for software developers

13 $What is a Digital Dashboard?$

A.

A hardware component in a server

B.

A data visualization tool that displays the current status of metrics and KPIs

C.

A type of unstructured data

D.

A database backup utility

14 $Why is BI needed at the Operational Level of an organization?$

A.

To optimize daily workflows and immediate decision making

B.

To analyze ten years of historical data

C.

To plan 5-year strategies

D.

To design the company logo

15 $Descriptive Analytics in BI answers which question?$

A.

Why did it happen?

B.

What happened?

C.

How can we make it happen?

D.

What will happen?

16 $Predictive Analytics is associated with which time frame?$

A.

None of the above

B.

Future

C.

Past

D.

Present

17 $Which data type accounts for the largest percentage of data growth in the modern world?$

A.

Structured Data

B.

Numeric Data

C.

Unstructured Data

D.

Boolean Data

18 $In an OLAP system, 'Drill-down' capability allows a user to:$

A.

Export data to a text file

B.

View data at a more detailed level

C.

Summarize data to a higher level

D.

Delete data permanently

19 $Which of the following is NOT a characteristic of Structured Data?$

A.

High degree of organization

B.

Flexible, schema-less format

C.

Stored in tables

D.

Easy to query using SQL

20 $Which BI component is responsible for extracting, transforming, and loading data?$

A.

Dashboard

B.

Data Mining

C.

OLAP Cube

D.

ETL

21 $Diagnostic Analytics focuses on:$

A.

Raw data collection

B.

Real-time monitoring

C.

Understanding why something happened

D.

Forecasting future trends

22 $Prescriptive Analytics attempts to:$

A.

Suggest a course of action

B.

Diagnose the present

C.

Describe the past

D.

Visualize static data

23 $What is a 'Data Silo'?$

A.

A secure type of database

B.

A visualization tool

C.

An isolated collection of data not accessible to other parts of the organization

D.

A cloud storage solution

24 $Which represents the hierarchy of data understanding from bottom to top?$

A.

Knowledge -> Wisdom -> Data -> Information

B.

Wisdom -> Knowledge -> Information -> Data

C.

Data -> Information -> Knowledge -> Wisdom

D.

Information -> Data -> Wisdom -> Knowledge

25 $Tactical BI is primarily used by:$

A.

CEOs only

B.

Business Analysts and Line Managers

C.

Clerks

D.

External Customers

26 $Metadata is best described as:$

A.

Deleted data

B.

Data about data

C.

Large volumes of data

D.

Corrupted data

27 $The evolution of BI moved from Mainframe reporting to:$

A.

None of the above

B.

Paper-only records

C.

Abacus calculation

D.

Client-Server based BI

28 $Which of the following is a key feature of a Digital Dashboard?$

A.

Requires SQL coding to view

B.

Slow data refresh rates

C.

Text-only output

D.

Visual presentation of Key Performance Indicators (KPIs)

29 $In the context of RDBMS limitations, what is the 'Variety' problem?$

A.

SQL has too many commands

B.

Databases represent too many colors

C.

Traditional databases struggle to manage diverse data formats (video, text, sensor data)

D.

There are too many brands of databases

30 $OLTP systems are generally characterized by:$

A.

Complex queries involving aggregations

B.

Low concurrency

C.

Read-mostly operations

D.

Short, atomic transactions

31 $The term 'Latency' in BI refers to:$

A.

The number of users logged in

B.

The time lag between data generation and actionable insight

C.

The cost of the software

D.

The size of the hard drive

32 $Which of the following creates a bridge between the 'Past' and 'Future' in BI analysis?$

A.

Data Deletion

B.

Trend Analysis

C.

System Reboot

D.

Data Entry

33 $Spreadsheets (like Excel) generally handle which type of data best?$

A.

Unstructured Video

B.

Real-time streaming audio

C.

Large-scale Big Data

D.

Structured Data

34 $What is the main role of a Data Warehouse in BI?$

A.

To process live transactions

B.

To store centralized, historical data for analysis

C.

To act as an email server

D.

To host the company website

35 $Semi-structured data often contains:$

A.

Only binary code

B.

Purely random noise

C.

Fixed length fields

D.

Tags or markers to separate elements

36 $Which level of management is most concerned with Strategic BI?$

A.

IT Support

B.

Top-level Executives

C.

Middle Management

D.

Operational Staff

37 $What limits a standard database's ability to handle 'Velocity'?$

A.

I/O bottlenecks when writing massive amounts of high-speed data

B.

The color of the server

C.

The speed of light

D.

The number of columns allowed

38 $Querying a NoSQL database is often required for:$

A.

Small address books

B.

Highly relational financial ledgers

C.

Unstructured or Semi-structured Big Data

D.

Fixed asset registers

39 $Which is an example of 'Present' BI?$

A.

Audit of last month's logs

B.

Sales forecast for next year

C.

Real-time stock market monitoring

D.

Year-end financial report

40 $What distinguishes Information from Data?$

A.

Information is digital; Data is analog

B.

There is no difference

C.

Data is always larger than Information

D.

Information is processed data with context and meaning

41 $Decision Support Systems (DSS) primarily rely on:$

A.

Manual paper filing

B.

Guesswork

C.

Strict transaction processing

D.

Models and data to solve semi-structured problems

42 $The 'Roll-up' operation in OLAP performs what function?$

A.

Deletes the cube

B.

Increases detail

C.

Rotates the axis

D.

Aggregates data (e.g., Daily to Monthly)

43 $Why is 'Data Quality' a limitation in real-world databases?$

A.

Quality is not important

B.

Inconsistent, duplicate, or missing data reduces trust in the database

C.

Computers never make mistakes

D.

Databases automatically fix all errors

44 $A CSV (Comma Separated Values) file is best described as:$

A.

Unstructured

B.

Proprietary code

C.

Executable software

D.

Structured (but usually stored as a flat file)

45 $Which of the following is NOT a benefit of BI?$

A.

Faster decision making

B.

Identified market trends

C.

Guaranteed 100% profit increase

D.

Improved operational efficiency

46 $Data Mining is most closely associated with:$

A.

Entering data manually

B.

Discovering hidden patterns and relationships in large datasets

C.

Designing web pages

D.

Backing up data to tape

47 $Which type of user typically uses OLTP systems?$

A.

Strategic Planners

B.

Clerks / Database Administrators

C.

Data Analysts

D.

CEO / Executives

48 $In the evolution of BI, what role did the 'Mainframe' play?$

A.

It provided the first centralized computing for generating static reports

B.

It utilized cloud computing

C.

It created the internet

D.

It introduced mobile dashboards

49 $Key Performance Indicators (KPIs) are essential components of:$

A.

Unstructured text

B.

Digital Dashboards

C.

Network cables

D.

OLTP transactions

50 $Why is 'Context' important in BI?$

A.

It encrypts the data

B.

It increases the file size

C.

It is not important

D.

It turns raw numbers into meaningful information

Unit 1 - Practice Quiz