List of top Questions asked in CUET (UG)

Sequence the given process for checking whether a string is a palindrome or not, using a deque:
(A) Load the string into the deque.
(B) Continuously remove characters from both ends.
(C) Compare the characters.
(D) Determine if the string is a palindrome based on the comparisons.

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 code for histogram:

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

What is the role of fill=False?

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)

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?

How can you save a matplotlib plot as a file?

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 relations:

Table A

Name	Hobbies
Anu	Dance
Anuj	Music

TableB

Name	Hobbies
Prannav	Reading
Anuj	Music

Find \( \text{TableA} \cup \text{TableB} \).

Dynamic web pages can be created using various languages, like __________.
(A) JavaScript
(B) PHP
(C) Python
(D) Ruby

Identify the correct code to read data from the file \texttt{notes.dat} in a binary file:

Match List-I with List-II:

List-I	List-II
(A) Static web page	(II) A web page whose content is fixed.
(B) Home page	(IV) First page of website.
(C) Dynamic web page	(I) A web page whose content keeps changing.
(D) Web server	(III) Delivers the contents to web browser.

Choose the correct answer from the options given below:

Sequence the steps to append data to an existing file and then read the entire file:
(A) Open the file in a+ mode.
(B) Use the read() method to output the contents.
(C) Use the write() or writelines() method to append data.
(D) Seek to the beginning of the file.

The intellectual property right that is granted for inventions is ____________.

Given the following statement:
import matplotlib.pyplot as plt
'plt' in the above statement is .............. name.

Match List-I with List-II:

List-I (Aggregate function)	List-II (Description)
(A) `count(marks)`	(III) Count all non null values of marks column
(B) `count()`	(I) Count all rows
(C) `avg(marks)`	(II) Finding average of non null values of marks
(D) `sum(marks)`	(IV) Finding sum of all marks

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.

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

Which of the following are the correct commands to delete a column from the DataFrame df1?

Given Relation: \texttt{STUDENT} \begin{center} \begin{tabular}{|c|c|c|} \hline SNO & SNAME & MARKS
\hline 1 & Amit & 20
2 & Karuna & 40
3 & Kavita & NULL
4 & Anuj & 30
\hline \end{tabular} \end{center} Find the value of: \begin{verbatim} SELECT AVG(MARKS) FROM STUDENT; \end{verbatim}

Give the output of the query: SELECT MONTH("2010-03-05");

Identify the correct IP address from the options given:

____________________________________ is used to search for a specific pattern in a column.

The SELECT command when combined with DISTINCT clause is used to:

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

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;