Question bank
Pick an answer to see if you're right — with an explanation.
All topicsPythonSQL / MySQLData ScienceNumPyPandasMatplotlibMachine LearningDeep LearningArtificial IntelligenceLarge Language ModelsDjangoAPIsGit & GitHubPower BIExcelStatistics
PythonEasy
What is the output of `print(type([]))`?
a<class 'tuple'>
b<class 'dict'>
c<class 'list'>
d<class 'array'>
Explanation: Square brackets create a list.
SQL / MySQLEasy
Which clause filters groups after aggregation?
aHAVING
bWHERE
cGROUP BY
dORDER BY
Explanation: HAVING filters aggregated groups.
PandasEasy
Which method shows the first 5 rows?
adf.first()
bdf.top()
cdf.show()
ddf.head()
Explanation: `head()` defaults to 5 rows.
Machine LearningEasy
Predicting house prices is a…
aClassification task
bClustering task
cRegression task
dReinforcement task
Explanation: Predicting a continuous number is regression.
DjangoEasy
Which command creates migration files?
amigrate
bcreatemigrations
csyncdb
dmakemigrations
Explanation: makemigrations generates files; migrate applies them.
Large Language ModelsEasy
LLMs generate text by predicting…
aThe next token
bThe next sentence
cThe whole answer at once
dKeywords
Explanation: They predict one token at a time.
Artificial IntelligenceEasy
On an unweighted graph, which search always returns a path with the fewest steps?
aDepth-first search
bGreedy best-first search
cBreadth-first search
dRandom restart
Explanation: BFS explores level by level, so the first time it reaches the goal it has used the fewest edges.
APIsEasy
Which status code best fits a successful POST that created a new resource?
a200 OK
b201 Created
c204 No Content
d302 Found
Explanation: 201 Created signals a new resource, ideally with a Location header pointing to it.
Data ScienceEasy
What is the main difference between a metric and a KPI?
aA KPI is always a percentage
bA KPI is a metric the business has agreed to steer by
cMetrics come from SQL, KPIs from Excel
dThere is no difference
Explanation: Any computable number is a metric; a KPI is a selected metric tied to goals and ownership.
Deep LearningEasy
What does calling `loss.backward()` do in PyTorch?
aUpdates the model weights
bComputes gradients of the loss with respect to parameters that require grad
cResets all gradients to zero
dRuns the forward pass again
Explanation: `backward()` only fills each parameter's `.grad`; the optimizer's `step()` performs the actual update.
DjangoEasy
Which form method must return `True` before you use `cleaned_data`?
aform.save()
bform.clean()
cform.is_valid()
dform.has_changed()
Explanation: `is_valid()` runs all validation and populates `cleaned_data`.
ExcelEasy
Which function removes leading and trailing spaces but keeps single spaces between words?
aCLEAN
bTRIM
cSUBSTITUTE
dPROPER
Explanation: TRIM strips leading, trailing and repeated inner spaces; CLEAN removes non-printing characters.
Git & GitHubEasy
Which command unstages a file but keeps your edits?
agit restore --staged file.py
bgit reset --hard
cgit revert file.py
dgit rm file.py
Explanation: restore --staged removes the file from the index while leaving the working-tree changes untouched.
Large Language ModelsEasy
What does an LLM's context window limit?
aThe number of API calls per minute
bThe total tokens of input plus output handled in one request
cThe size of the training dataset
dThe number of users
Explanation: The context window caps everything the model sees and generates in a single request.
Machine LearningEasy
Logistic regression converts a weighted sum into a probability using which function?
aReLU
bSoftmax over features
cSigmoid
dStep function
Explanation: The sigmoid maps any real number into the range 0 to 1, which is read as a probability.