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. Visual charts and graphs
B. Processed information ready for decision making
C. Raw, unorganized facts and figures
D. Software applications used for analysis

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

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

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

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

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

A. Unstructured Data
B. Structured 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. They cannot perform mathematical calculations
B. Difficulty in scaling horizontally and handling unstructured data
C. They cannot handle structured data
D. They lack security features

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. Generating executive dashboards
B. Complex data analysis
C. Fast query processing and data integrity for transactions
D. Historical data archiving

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

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

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

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

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

A. A method for securing network connections
B. The process of backing up database files
C. Strategies and technologies used for data analysis and management
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. EIS (Executive Information Systems)
B. MIS (Management Information Systems)
C. IoT (Internet of Things)
D. AI (Artificial Intelligence)

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

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

13 What is a Digital Dashboard?

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

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

A. To analyze ten years of historical data
B. To optimize daily workflows and immediate decision making
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. How can we make it happen?
C. What will happen?
D. What happened?

16 Predictive Analytics is associated with which time frame?

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

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

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

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

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

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

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

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

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

21 Diagnostic Analytics focuses on:

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

22 Prescriptive Analytics attempts to:

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

23 What is a 'Data Silo'?

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

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

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

25 Tactical BI is primarily used by:

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

26 Metadata is best described as:

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

27 The evolution of BI moved from Mainframe reporting to:

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

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

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

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

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

30 OLTP systems are generally characterized by:

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

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 size of the hard drive
D. The cost of the software

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

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

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

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

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

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

35 Semi-structured data often contains:

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

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

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

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

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

38 Querying a NoSQL database is often required for:

A. Unstructured or Semi-structured Big Data
B. Small address books
C. Highly relational financial ledgers
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. Year-end financial report
D. Real-time stock market monitoring

40 What distinguishes Information from Data?

A. Data is always larger than Information
B. There is no difference
C. Information is processed data with context and meaning
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. Manual paper filing
C. Guesswork
D. Strict transaction processing

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

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

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

A. Quality is not important
B. Databases automatically fix all errors
C. Inconsistent, duplicate, or missing data reduces trust in the database
D. Computers never make mistakes

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

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

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

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

46 Data Mining is most closely associated with:

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

47 Which type of user typically uses OLTP systems?

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

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

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

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

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

50 Why is 'Context' important in BI?

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