Question
1.
Microsoft Access is best described as what type of software?
content management system
data storage system
database management system
spreadsheet populator system
2.
What database-focused software is used to build websites and blogs?
customer management software
content management systems
data design tools
internet service providers
3.
What would the following query of customers return?
SELECT * WHERE age = “18” AND gender = “male”
an error
all customers who are over 18 and are male
all records customers who are either 18 or who are male-identified
all records for 18-year-old, male-identified customers
4.
What is an example of an integer?
3:30
5/22
3.10
-5
5.
The most common way to retrieve information from a large database using SQL is to:
look directly at the database.
activate a filter.
perform a query.
use an online search tool.
6.
What is the first step when designing a new database?
asking what it will be used for
deciding who the customer will be
calculating data storage costs
choosing a web host
7.
David is using data mining to find out what side dishes are most popular with each of his meals. What technique is best for this analysis?
regression
association rule discovery
classification
clustering
8.
What is the last step required before a query takes effect?
command
run
return
overwrite
9.
What database query is used to bring up particular records?
OPEN
PRINT
SHOW
SELECT
10.
What is an example of data that would generally be stored in character format?
birth date
product name
income
age
11.
Maria is trying to determine which customer base would be most interested in her latest invention: a self-cleaning baby crib. What data mining technique might she use to narrow down potential customers to a targetable marketing campaign?
regression
association rule discovery
classification
clustering
12.
What is an example of an institution very likely to use a data warehouse?
small, local nonprofit
large university
residential pre-school
national sports team
13.
Filip performed a data mining technique and found that his customers who bought three or more board games in a year shared a lot in common with customers who bought three or more video games a month. He believes he should try cross marketing, since the groups may be similar. What data mining technique does this scenario most illustrate?
regression
association rule discovery
classification
clustering
14.
What is SQL primarily used for?
converting spreadsheets to database files
creating charts from data
making database queries
creating an index of data
15.
The most common database language is:
SQL.
Python.
Ruby.
C++.
Microsoft Access is best described as what type of software?
content management system
data storage system
database management system
spreadsheet populator system
2.
What database-focused software is used to build websites and blogs?
customer management software
content management systems
data design tools
internet service providers
3.
What would the following query of customers return?
SELECT * WHERE age = “18” AND gender = “male”
an error
all customers who are over 18 and are male
all records customers who are either 18 or who are male-identified
all records for 18-year-old, male-identified customers
4.
What is an example of an integer?
3:30
5/22
3.10
-5
5.
The most common way to retrieve information from a large database using SQL is to:
look directly at the database.
activate a filter.
perform a query.
use an online search tool.
6.
What is the first step when designing a new database?
asking what it will be used for
deciding who the customer will be
calculating data storage costs
choosing a web host
7.
David is using data mining to find out what side dishes are most popular with each of his meals. What technique is best for this analysis?
regression
association rule discovery
classification
clustering
8.
What is the last step required before a query takes effect?
command
run
return
overwrite
9.
What database query is used to bring up particular records?
OPEN
SHOW
SELECT
10.
What is an example of data that would generally be stored in character format?
birth date
product name
income
age
11.
Maria is trying to determine which customer base would be most interested in her latest invention: a self-cleaning baby crib. What data mining technique might she use to narrow down potential customers to a targetable marketing campaign?
regression
association rule discovery
classification
clustering
12.
What is an example of an institution very likely to use a data warehouse?
small, local nonprofit
large university
residential pre-school
national sports team
13.
Filip performed a data mining technique and found that his customers who bought three or more board games in a year shared a lot in common with customers who bought three or more video games a month. He believes he should try cross marketing, since the groups may be similar. What data mining technique does this scenario most illustrate?
regression
association rule discovery
classification
clustering
14.
What is SQL primarily used for?
converting spreadsheets to database files
creating charts from data
making database queries
creating an index of data
15.
The most common database language is:
SQL.
Python.
Ruby.
C++.
Answers
GPT-4o mini
Here are the answers to your questions:
1. **Microsoft Access is best described as what type of software?**
- **database management system**
2. **What database-focused software is used to build websites and blogs?**
- **content management systems**
3. **What would the following query of customers return?**
- **all records for 18-year-old, male-identified customers**
4. **What is an example of an integer?**
- **-5**
5. **The most common way to retrieve information from a large database using SQL is to:**
- **perform a query.**
6. **What is the first step when designing a new database?**
- **asking what it will be used for**
7. **David is using data mining to find out what side dishes are most popular with each of his meals. What technique is best for this analysis?**
- **association rule discovery**
8. **What is the last step required before a query takes effect?**
- **run**
9. **What database query is used to bring up particular records?**
- **SELECT**
10. **What is an example of data that would generally be stored in character format?**
- **product name**
11. **Maria is trying to determine which customer base would be most interested in her latest invention: a self-cleaning baby crib. What data mining technique might she use to narrow down potential customers to a targetable marketing campaign?**
- **classification**
12. **What is an example of an institution very likely to use a data warehouse?**
- **large university**
13. **Filip performed a data mining technique and found that his customers who bought three or more board games in a year shared a lot in common with customers who bought three or more video games a month. He believes he should try cross marketing, since the groups may be similar. What data mining technique does this scenario most illustrate?**
- **association rule discovery**
14. **What is SQL primarily used for?**
- **making database queries**
15. **The most common database language is:**
- **SQL.**
1. **Microsoft Access is best described as what type of software?**
- **database management system**
2. **What database-focused software is used to build websites and blogs?**
- **content management systems**
3. **What would the following query of customers return?**
- **all records for 18-year-old, male-identified customers**
4. **What is an example of an integer?**
- **-5**
5. **The most common way to retrieve information from a large database using SQL is to:**
- **perform a query.**
6. **What is the first step when designing a new database?**
- **asking what it will be used for**
7. **David is using data mining to find out what side dishes are most popular with each of his meals. What technique is best for this analysis?**
- **association rule discovery**
8. **What is the last step required before a query takes effect?**
- **run**
9. **What database query is used to bring up particular records?**
- **SELECT**
10. **What is an example of data that would generally be stored in character format?**
- **product name**
11. **Maria is trying to determine which customer base would be most interested in her latest invention: a self-cleaning baby crib. What data mining technique might she use to narrow down potential customers to a targetable marketing campaign?**
- **classification**
12. **What is an example of an institution very likely to use a data warehouse?**
- **large university**
13. **Filip performed a data mining technique and found that his customers who bought three or more board games in a year shared a lot in common with customers who bought three or more video games a month. He believes he should try cross marketing, since the groups may be similar. What data mining technique does this scenario most illustrate?**
- **association rule discovery**
14. **What is SQL primarily used for?**
- **making database queries**
15. **The most common database language is:**
- **SQL.**