List of top Questions asked in CUET (UG)

________________ is the trail of data we leave behind when we visit any website (or use any online application or portal) to fill-in data or perform any transaction.
Dynamic web pages can be created using various languages, like __________.
(A) JavaScript
(B) PHP
(C) Python
(D) Ruby
Match List-I with List-II:
List-IList-II
(A) STAR TOPOLOGY(I) Each communicating device is connected to a central node.
(B) LAN(IV) Type of network.
(C) HUB(II) Networking device.
(D) VoIP(III) Protocol.
Choose the correct answer from the options given below:
Arrange the following in sequence of execution:
(A) HTTP Request
(B) Calls an application in response to the HTTP request
(C) Program executes and produces HTML output
(D) HTTP Response
Match List-I with List-II:
List-IList-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:
Which of the following is a networking device?
(A) Gateway
(B) Repeater
(C) MAN
(D) Modem
____________ is the largest WAN that connects billions of computers, smartphones, and millions of LANs from different countries.
The intellectual property right that is granted for inventions is ____________.
____________ in matplotlib also known as correlation plot, because they show how two variables are related.

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

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:

NAMEPERIODICENGMATHSSCIENCE
MEENA1406080
REENA2603010
TEENA3806040
SHEENA2902070

We want the following output:

NAMEMEENAREENATEENASHEENA
PERIODIC8
ENG270
MATHS170
SCIENCE200
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:

ENOSALARY
A1014000
B109NULL
C5086000
A3052000

State the output of the following query:

SELECT COUNT(SALARY) FROM EMPLOYEE;  

Match List-I with List-II.
List-IList-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