Back to Subject

Unit 1: Digital Data and Business Intelligence (BI) - Practice Quiz

INT323 — Database Essentials Toward Informatica 50 Questions
0 Correct 0 Wrong 50 Left
0/50

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

A. Processed information ready for decision making
B. Raw, unorganized facts and figures
C. Software applications used for analysis
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. Unstructured Data
B. Semi-structured Data
C. Structured Data
D. Abstract Data

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

A. Normalized Data
B. Unstructured Data
C. Structured Data
D. Semi-structured Data

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

A. Structured Data
B. Unstructured Data
C. Raw Data
D. Semi-structured Data

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

A. Difficulty in scaling horizontally and handling unstructured data
B. They lack security features
C. They cannot handle structured data
D. They cannot perform mathematical calculations

6 OLTP stands for:

A. Offline Transaction Protocol
B. Online Text Processing
C. Online Analytical Processing
D. Online Transaction Processing

7 What is the primary goal of an OLTP system?

A. Historical data archiving
B. Fast query processing and data integrity for transactions
C. Complex data analysis
D. Generating executive dashboards

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

A. OLAP
B. ATM Systems
C. RDBMS
D. OLTP

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

A. OLTP data is static; OLAP data is volatile
B. Both are highly volatile
C. Both are non-volatile
D. OLTP data is volatile; OLAP data is non-volatile

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

A. A method for securing network connections
B. A specific software tool for writing SQL queries
C. Strategies and technologies used for data analysis and management
D. The process of backing up database files

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

A. MIS (Management Information Systems)
B. AI (Artificial Intelligence)
C. IoT (Internet of Things)
D. EIS (Executive Information Systems)

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

A. To compile code for software developers
B. To provide senior executives with easy access to internal and external data
C. To manage customer support tickets
D. To process daily operational transactions

13 What is a Digital Dashboard?

A. A type of unstructured data
B. A hardware component in a server
C. A data visualization tool that displays the current status of metrics and KPIs
D. A database backup utility

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

A. To design the company logo
B. To analyze ten years of historical data
C. To optimize daily workflows and immediate decision making
D. To plan 5-year strategies

15 Descriptive Analytics in BI answers which question?

A. What happened?
B. Why did it happen?
C. How can we make it happen?
D. What will happen?

16 Predictive Analytics is associated with which time frame?

A. Present
B. None of the above
C. Past
D. Future

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

A. Unstructured Data
B. Structured Data
C. Boolean Data
D. Numeric Data

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

A. Summarize data to a higher level
B. View data at a more detailed level
C. Delete data permanently
D. Export data to a text file

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

A. High degree of organization
B. Easy to query using SQL
C. Stored in tables
D. Flexible, schema-less format

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

A. OLAP Cube
B. Data Mining
C. Dashboard
D. ETL

21 Diagnostic Analytics focuses on:

A. Raw data collection
B. Forecasting future trends
C. Understanding why something happened
D. Real-time monitoring

22 Prescriptive Analytics attempts to:

A. Suggest a course of action
B. Describe the past
C. Diagnose the present
D. Visualize static data

23 What is a 'Data Silo'?

A. An isolated collection of data not accessible to other parts of the organization
B. A secure type of database
C. A cloud storage solution
D. A visualization tool

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

A. Knowledge -> Wisdom -> Data -> Information
B. Information -> Data -> Wisdom -> Knowledge
C. Data -> Information -> Knowledge -> Wisdom
D. Wisdom -> Knowledge -> Information -> Data

25 Tactical BI is primarily used by:

A. Business Analysts and Line Managers
B. CEOs only
C. External Customers
D. Clerks

26 Metadata is best described as:

A. Large volumes of data
B. Corrupted data
C. Deleted data
D. Data about data

27 The evolution of BI moved from Mainframe reporting to:

A. Paper-only records
B. None of the above
C. Abacus calculation
D. Client-Server based BI

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

A. Text-only output
B. Requires SQL coding to view
C. Slow data refresh rates
D. Visual presentation of Key Performance Indicators (KPIs)

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

A. Databases represent too many colors
B. Traditional databases struggle to manage diverse data formats (video, text, sensor data)
C. There are too many brands of databases
D. SQL has too many commands

30 OLTP systems are generally characterized by:

A. Low concurrency
B. Short, atomic transactions
C. Complex queries involving aggregations
D. Read-mostly operations

31 The term 'Latency' in BI refers to:

A. The cost of the software
B. The number of users logged in
C. The size of the hard drive
D. The time lag between data generation and actionable insight

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

A. System Reboot
B. Trend Analysis
C. Data Deletion
D. Data Entry

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

A. Structured Data
B. Unstructured Video
C. Real-time streaming audio
D. Large-scale Big Data

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

A. To store centralized, historical data for analysis
B. To process live transactions
C. To act as an email server
D. To host the company website

35 Semi-structured data often contains:

A. Purely random noise
B. Fixed length fields
C. Only binary code
D. Tags or markers to separate elements

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

A. Operational Staff
B. IT Support
C. Middle Management
D. Top-level Executives

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

A. The color of the server
B. I/O bottlenecks when writing massive amounts of high-speed data
C. The number of columns allowed
D. The speed of light

38 Querying a NoSQL database is often required for:

A. Unstructured or Semi-structured Big Data
B. Fixed asset registers
C. Small address books
D. Highly relational financial ledgers

39 Which is an example of 'Present' BI?

A. Real-time stock market monitoring
B. Audit of last month's logs
C. Year-end financial report
D. Sales forecast for next year

40 What distinguishes Information from Data?

A. Data is always larger than Information
B. Information is processed data with context and meaning
C. There is no difference
D. Information is digital; Data is analog

41 Decision Support Systems (DSS) primarily rely on:

A. Models and data to solve semi-structured problems
B. Strict transaction processing
C. Manual paper filing
D. Guesswork

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

A. Rotates the axis
B. Aggregates data (e.g., Daily to Monthly)
C. Increases detail
D. Deletes the cube

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. Databases automatically fix all errors
D. Computers never make mistakes

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

A. Structured (but usually stored as a flat file)
B. Executable software
C. Unstructured
D. Proprietary code

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

A. Identified market trends
B. Guaranteed 100% profit increase
C. Faster decision making
D. Improved operational efficiency

46 Data Mining is most closely associated with:

A. Backing up data to tape
B. Entering data manually
C. Designing web pages
D. Discovering hidden patterns and relationships in large datasets

47 Which type of user typically uses OLTP systems?

A. CEO / Executives
B. Strategic Planners
C. Data Analysts
D. Clerks / Database Administrators

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

A. It created the internet
B. It utilized cloud computing
C. It provided the first centralized computing for generating static reports
D. It introduced mobile dashboards

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

A. Digital Dashboards
B. OLTP transactions
C. Unstructured text
D. Network cables

50 Why is 'Context' important in BI?

A. It encrypts the data
B. It increases the file size
C. It turns raw numbers into meaningful information
D. It is not important
Next MCQ
Unit 2