List of practice Questions

How can you save a matplotlib plot as a file?

Arrange the following in order in the context of exception handling:
(A) Program Termination
(B) Exception is raised
(C) Error occurs in a program
(D) Catching an exception Choose the correct answer from the options given below:

The plot function of pandas matplotlib uses 'kind' argument which can accept a string indicating the type of graph to be plotted. Which of the following are valid plots?

Given the following code for histogram:

df.plot(kind='hist', edgecolor="Green", linewidth=2, linestyle='-', fill=False, hatch='o')

What is the role of fill=False?

Matplotlib library can be installed using pip command. Identify the correct syntax from the following options.

While transferring the data from a DataFrame to a CSV file, if we do not want the column names to be saved to the file on disk, the parameter to be used in \texttt{to__csv()} is __________.

HTTP is .............

Put the following statistical measures in order starting from the simplest measure of data to the most complex one that describes data spread: (A) Mode,
(B) Mean,
(C) Median,
(D) Range,
(E) Standard Deviation

Dataframe.quantile() is used to get the quartiles. The second quantile is known as ..............

Consider the given DataFrame df4:

NAME	PERIODIC	ENG	MATHS	SCIENCE
MEENA	1	40	60	80
REENA	2	60	30	10
TEENA	3	80	60	40
SHEENA	2	90	20	70

We want the following output:

NAME	MEENAREENATEENASHEENA
PERIODIC	8
ENG	270
MATHS	170
SCIENCE	200

The process of changing the structure of a DataFrame using function pivot() is known as .............

After establishing the connection to fetch the data from the table of a database in SQL into a DataFrame, which of the following function will be used?
(A) pandas.read__sql__query()
(B) pandas.read__sql__table()
(C) pandas.read__sql__query__table()
(D) pandas.read__sql()

Given the following table:

ENO	SALARY
A101	4000
B109	NULL
C508	6000
A305	2000

State the output of the following query:

SELECT COUNT(SALARY) FROM EMPLOYEE;

Match List-I with List-II.

List-I	List-II
(A) SUBSTR()	(II) To extract a substring from a string.
(B) TRIM()	(IV) To remove spaces from both sides of the string.
(C) INSTR()	(I) To find the position of a substring in a string.
(D) LEFT()	(III) To extract characters from the left side of the string.

Arrange the following statements to create a series from a dictionary.
(A) Print the series
(B) Import the pandas library
(C) Create the series
(D) Create a dictionary

Given the following DataFrame df:

PNO	NAME
111	ROHAN
222	MEETA
333	SEEMA
444	SHALU
555	POONAM

Select the correct commands from the following to display the last five rows:

Given the following series ser1:

Index	Value
0	69
1	80
2	20
3	50
4	100
5	70

State the output of the following command:

print(ser1 >= 70)

Which of the following is the correct command to display the top 2 records of Series \texttt{tail}?

The HTTPS based websites require:

State the output of the following query: \[ \text{SELECT LENGTH(MID('INFORMATICS PRACTICES',5,-5));} \]

Match List-I with List-II:

List-I	List-II
(A) group by	(III) having
(B) mid()	(IV) text function
(C) count()	(II) aggregate function
(D) mod()	(I) math function

What will be the format of the output of the NOW() function?

State the output of the following query: \[ \text{SELECT ROUND(9873.567,-2);} \]

Match List-I with List-II. \

List-I	List-II
(A) Modem	(II) Modulator-Demodulator
(B) RJ45	(I) An eight pin connector used with Ethernet cables for networking.
(C) Network interface unit	(IV) Ethernet card
(D) ISP	(III) An organization that provides services for accessing the internet.

Bandwidth of a channel is: