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

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:
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.
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.
Identify the correct IP address from the options given:
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
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)
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()
A __________ value is specified for the column, if no value is provided.
__________ is the process of transforming data or an object in memory (RAM) to a stream of bytes called byte streams.
Identify the correct code to read data from the file \texttt{notes.dat} in a binary file:

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

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.
Cable based broadband internet services are example of ..............
How can you save a matplotlib plot as a file?
The SELECT command when combined with DISTINCT clause is used to:
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:
HTTP is .............
Matplotlib library can be installed using pip command. Identify the correct syntax from the following options.
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
__________ is a branch of science that deals with designing and arranging of workplaces.
____________ in matplotlib also known as correlation plot, because they show how two variables are related.
____________________________________ is used to search for a specific pattern in a column.
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.

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