stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
quize 4 Flashcards | StudBud
Explore
/
quize 4
quize 4
20 terms
·
StudBud Administration
·
4 plays
Imported from external platform
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
True or False: You can apply rolling means (moving averages) in SQL as in time series analysis.
False
True
2
What SQL clause is used to combine rows from two tables based on a related column?
GROUP BY
JOIN
WHERE
HAVING
3
Which of these is a valid Boolean expression?
5 := 5
5 = 5
5 -> 5
5 == 5
4
Which data type is used for text?
int
list
float
str
5
🔹 Intro to Programming (Kaggle Intro to Programming) Which operator is used for multiplication?
&
x
*
×
6
🔹 Time Series (Kaggle Learn Time Series)What feature involves using past values to predict future ones?
Lags
Seasonality
Moving averages
Trend lines
7
True or False: Seasonal patterns always repeat over equal intervals.
False
True
8
What command retrieves specific columns from a table in SQL?
SELECT
DELETE
INSERT
UPDATE
9
True or False: A tuple can be modified after it's created.
False
True
10
In time series forecasting, what are “time steps”?
Specific dates
The window sizes used in rolling statistics
The number of features
Amount of missing data
11
Which Python data type would you use for a list of temperature readings?
dict
int
str
list
12
What Python function returns the length of a list?
count()
size()
len()
length()
13
Which method captures long-term changes over time?
One-hot encoding
Fourier transformation
Moving average
Lag features
14
Which of these is not a basic Python data type covered in Intro to Programming?
float
dict
int
bool
15
Which clause filters rows based on a condition?
WHERE
GROUP BY
ORDER BY
HAVING
16
What is the correct way to define a function in Python?
func my_function():
define my_function():
function: my_function()
def my_function():
17
If x = 5, what does x += 2 do?
B) Sets x to 2
Sets x to 3
Raises an error
B) Sets x to 7
18
What symbol is used for comments in Python?
//
#
<!-- -->
$$
19
True or False: BigQuery is used to run SQL queries on very large datasets.
True
False
20
True or False: Python uses indentation to define code blocks instead of braces {}.
False
True