Question 1

What does the count() data aggregate function do?

Options :

A : Sorts the dataset in ascending order

B : Returns the length of the dataset

C : Calculates the sum of all elements in a dataset

D : Finds the frequency of a specific value in a dataset

Answer: B

Question 2

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 3

Which keyword is used to define a subclass in Python?

Options :

A : sub

B : derive

C : base

D : class

Answer: D

Question 4

What is the difference between a global and a local variable in Python?

Options :

A : Global variables can be accessed anywhere in the program, while local variables are only accessible within the function where they are defined.

B : Global variables are immutable, while local variables are mutable.

C : Global variables are defined inside functions, while local variables are defined outside functions.

D : Global variables can only store strings, while local variables can store any data type.

Answer: A

Question 5

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

Free Python-PCAT Mock Exam – Practice Online Confidently