stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Business Information Systems - Database systems, Data warehouse and Information Systems Flashcards | StudBud
Explore
/
Business Information Systems - Database systems, Data warehouse and Information Systems
Business Information Systems - Database systems, Data warehouse and Information Systems
30 terms
·
StudBud Administration
·
16 plays
Imported from external platform
Flashcards
30 cards
F
Practice quiz
P
Host live
L
Questions
30
Answers
1
Cloud computing
offers several advantages. Which of the following is NOT one of them?
Remote accessibility
Requires expensive hardware for users
Scalability
Cost savings
2
Which database model is most commonly used in modern Business Information Systems?
Network
Object-oriented
Hierarchical
Relational
3
Why would someone use SQL in a database system?
To spend hours debugging syntax errors
For simple queries—if you enjoy migraines
To look cool while typing semi-colons
Because it’s the only way databases understand you
4
What is the primary function of a Business Information System?
Employee training
Internet browsing
Data entry
Decision support
5
A Supply Chain Management (SCM) system is mainly used for employee performance reviews.
True
False
6
What is the purpose of a foreign key?
To create more rules for your data
To ensure your tables have international relations
A plot device to ruin your queries
To connect records in related tables
7
Artificial Intelligence (AI) is not used in Business Information Systems.
True
False
8
Name two advantages of using cloud computing in business.
cost reduction
reliance on internet connectivity
Security concerns
Scalability
9
Which of the following is an example of an
Enterprise Resource Planning (ERP)
system?
SAP
Microsoft Excel
Salesforce
Gmail
10
Which of the following describes the term "data warehouse"?
A centralized repository of integrated data for analysis
A collection of disparate files
A real-time transactional database
A temporary repository for data processing
11
In Business Information Systems, what is
data mining
?
Physically digging up old data records
Extracting valuable patterns and trends from large datasets
Copying data from one system to another
Encrypting business data
12
What is the main goal of
Business Intelligence (BI)
systems?
Store large volumes of data
Secure company networks
Replace employees with automation
Analyse data to provide insights for decision-making
13
Cloud-based BIS solutions often reduce the need for physical IT infrastructure.
False
True
14
What does
Big Data
refer to?
A large database storage system
A data visualization tool
A programming language for analytics
High-volume, high-velocity, and high-variety data
15
Which term best describes the conversion of raw data into a form that is useful for decision making?
Data processing
Data elimination
Data mining
Data accumulation
16
Which of these is true about a data mart?
A new product from DataMart™, your trusted source of confusion
A retail store for data sales
A standalone table for really lazy analysts
It’s a boutique version of a data warehouse
17
The BIOS is best described as:
A programming language
An operating system
Basic Input Output System
A type of memory
18
Phishing is a type of cyberattack aimed at stealing user credentials.
False
True
19
What does "ETL" stand for in a data warehouse?
Endless Troubles with Logic
Everlasting Table Lookup
Extra-Territorial Llamas
Extract, Transform, Load
20
What is the primary function of a database system?
Enable concurrent access and efficient data storage
Store data in files
Visualize data in dashboards
Execute web-based applications
21
Why would you use a foreign key constraint in a database?
Because primary keys aren't challenging enough
To show off your advanced SQL skills
To enforce referential integrity between related tables
To create drama between tables
22
What does the term “booting” refer to?
Installing new hardware
Starting up the computer
Shutting down the computer
Upgrading software
23
In a
Decision Support System (DSS)
, what is the main purpose?
Assist managers in decision-making
Secure business networks
Store customer data
Automate business processes
24
Enterprise systems integrate multiple business functions into one system.
False
True
25
What type of system is used to
prevent unauthorized access
to a company’s network?
Firewall
BI
CRM
ERP
26
Which of the following is an example of system software?
Spreadsheet program
Operating system
Video game
Word processor
27
What’s the
real
reason businesses invest in database systems?
Because Excel was too simple
To confuse their employees with SQL queries
They enjoy spending money on complex technology
Efficient data management and retrieval
28
Which characteristic makes a distributed database system special?
It's scattered like a treasure hunt
It has zero downtime and no errors (dream on!)
It's just a gimmick for tech conferences
Data is stored across multiple locations for accessibility
29
What is a key characteristic of OLAP (Online Analytical Processing)?
Complex data analysis and multidimensional queries
Record-level transactional updates
Simple data retrieval and input
Real-time data entry
30
A
Customer Relationship Management (CRM)
system primarily helps businesses:
Process payroll transactions
Manage employee salaries
Improve customer interactions and sales
Handle supply chain logistics
