DATA 2100 FINAL TEST 2025
In a dataset, a "row" of data can be referred to as a....
- record
- variable
- data point
- value
record
In a database, each table...
- must have a primary key
- must have both a primary and foreign key
- must have a foreign key
- doesn't necessarily need a primary or foreign key
must have a primary key
I want to know how many customers are in each state, and only show states
with more than 50 customers. I need...
- A GROUP BY and a HAVING
- an analytical function and a WHERE
- A COUNT and an ORDER BY
A GROUP BY and a HAVING
To join two tables in the WHERE clause...
- tables cannot be joined in the WHERE clause
- Set the PK in one table equal to the corresponding FK in the other
- set the FK in the one table equal to the FK in the other
- set the PK in one table equal to the PK in the other
Set the PK in one table equal to the corresponding FK in the other
A "loop" in a flowchart corresponds with what in python?
- if/elif/else
- try/except
In a dataset, a "row" of data can be referred to as a....
- record
- variable
- data point
- value
record
In a database, each table...
- must have a primary key
- must have both a primary and foreign key
- must have a foreign key
- doesn't necessarily need a primary or foreign key
must have a primary key
I want to know how many customers are in each state, and only show states
with more than 50 customers. I need...
- A GROUP BY and a HAVING
- an analytical function and a WHERE
- A COUNT and an ORDER BY
A GROUP BY and a HAVING
To join two tables in the WHERE clause...
- tables cannot be joined in the WHERE clause
- Set the PK in one table equal to the corresponding FK in the other
- set the FK in the one table equal to the FK in the other
- set the PK in one table equal to the PK in the other
Set the PK in one table equal to the corresponding FK in the other
A "loop" in a flowchart corresponds with what in python?
- if/elif/else
- try/except
