List of top Computer Science Questions asked in CUET (UG)

____________ in matplotlib also known as correlation plot, because they show how two variables are related.

Violation of intellectual property right may happen due to:
(A) Copyright Infringement
(B) Patent
(C) Trademark Infringement
(D) Plagiarism

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

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?

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 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}

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.

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.

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

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

Arrange the following in order related to bubble sort for a list of elements: Initial list: \[4, -9, 12, 30, 2, 6\] (A) \[4, -9, 12, 30, 2, 6\]
(B) \[-9, 4, 12, 30, 2, 6\]
(C) \[-9, 4, 12, 2, 30, 6\]
(D) \[-9, 4, 12, 2, 6, 30\]

Identify the correct place where we have to use repeaters.

In MAC address, Organisational Unique Identifier (OUI) consists of __________.

Match List-I with List-II.

List-I	List-II
(A) ROUTER	(II) Network Device
(B) ETHERNET CARD	(IV) Network Interface Card
(C) RING	(I) Network Topology
(D) PAN	(III) Network Type

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:

Match List-I with List-II.

List-I	List-II
(A) Primary key	(III) Attribute used to uniquely identify a tuple.
(B) Degree	(I) Total number of attributes in a table.
(C) Foreign key	(II) Attribute used to relate two tables.
(D) Constraint	(IV) A restriction on the type of data that can be inserted in a column.

In SQL table, the set of values which a column can take in each row is called __________.

Which of the following is synonym for Meta-data?

Single row functions are also known as ________ functions.

Identify the wired transmission media for the following: “They are less expensive and commonly used in telephone lines and LANs. These cables are of two types: Unshielded and shielded.”

Data Transfer Rate 1 Gbps is equal to: (A) 1024 Mbps
(B) 1024 Kbps
(C) $2^{30}$ bps
(D) $2^{20}$ bps