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

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

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 table 'StudAtt' with structure as (Rno, Attdate, Attendance). Identify the suitable command to add a primary key to the table after creation.
Note: We want to make both Rno and Attdate columns as primary key.

Arrange the following Python code segments in order with respect to exception handling: (A) except ZeroDivisionError:
\hspace{0.5cm} print("Zero denominator not allowed")
(B) finally:
\hspace{0.5cm} print("Over and Out")
(C) try:
\hspace{0.5cm} n = 50
\hspace{0.5cm} d = int(input("enter denominator"))
\hspace{0.5cm} q = n/d
\hspace{0.5cm} print("division performed")
(D) else:
\hspace{0.5cm} print("Result=", q)

Which of the following is a networking device?
(A) Gateway
(B) Repeater
(C) MAN
(D) Modem

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:

__________ is the process of transforming data or an object in memory (RAM) to a stream of bytes called byte streams.

Given two relations:

Employee with structure as (ID, Name, Address, Phone, Deptno)
Department with structure as (Deptno, Dname)
__________ is used to represent the relationship between two relations Employee and Department.

____________ is the largest WAN that connects billions of computers, smartphones, and millions of LANs from different countries.

How can you save a matplotlib plot as a file?

Cable based broadband internet services are example of ..............

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

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

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 intellectual property right that is granted for inventions is ____________.

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

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

Identify the correct IP address from the options given:

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

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