Question 1

What does the COUNT() function in SQL do?

Options :

A : Calculates the average of a column

B : Counts the number of rows in a table

C : Returns the total sum of a column

D : Counts the number of distinct values in a column

Answer: B

Question 2

What does the mean() data aggregate function do?

Options :

A : Finds the maximum value in a dataset

B : Calculates the average value of a dataset

C : Sorts the dataset in ascending order

D : Returns the length of the dataset

Answer: B

Question 3

What is the purpose of the "pass" statement in Python?

Options :

A : To indicate the end of a block of code

B : To do nothing and act as a placeholder

C : To terminate the execution of a loop or function

D : To skip the current iteration of a loop

Answer: B

Question 4

Which built-in method is used to define the string representation of an object?

Options :

A : __init__()

B : __repr__()

C : __class__()

D : __str__()

Answer: D

Question 5

Which loop in Python is used for definite iteration?

Options :

A : for loop

B : while loop

C : loop doesn't exist in python

D : do-while loop

Answer: A

Free Python-PCAT Mock Exam – Practice Online Confidently