DATA 2100 FINAL REVIEW EXAM
QUESTIONS AND ANSWERS
In a dataset, a "row" of data can be referred to as a... - ANSWER Record
In a database, each table... - ANSWER 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... - ANSWER A GROUP BY and a
HAVING
To join two tables in a WHERE clause... - ANSWER Set the PK in one table
equal to the corresponding FK in the other
A "loop" in a flowchart corresponds with what in Python? - ANSWER While
After Python runs are SELECT query, how do you output each record? -
ANSWER For loop
When does the except block happen?
- Whenever you need to validate input.
- When there is no else block.
- When the if-statement is false.
- When the try block would cause an error. - ANSWER When the try block
would cause an error.
Which of the following is NOT an IT "environment"?
Dev
QA
Production
Test - ANSWER Test
Given observations of 2, 3, 4, 7, what's the median? - ANSWER 3.5
QUESTIONS AND ANSWERS
In a dataset, a "row" of data can be referred to as a... - ANSWER Record
In a database, each table... - ANSWER 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... - ANSWER A GROUP BY and a
HAVING
To join two tables in a WHERE clause... - ANSWER Set the PK in one table
equal to the corresponding FK in the other
A "loop" in a flowchart corresponds with what in Python? - ANSWER While
After Python runs are SELECT query, how do you output each record? -
ANSWER For loop
When does the except block happen?
- Whenever you need to validate input.
- When there is no else block.
- When the if-statement is false.
- When the try block would cause an error. - ANSWER When the try block
would cause an error.
Which of the following is NOT an IT "environment"?
Dev
QA
Production
Test - ANSWER Test
Given observations of 2, 3, 4, 7, what's the median? - ANSWER 3.5
