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

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

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

Given the following relations:

Table A

NameHobbies
AnuDance
AnujMusic

TableB

NameHobbies
PrannavReading
AnujMusic

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

________________ 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.
__________ is a branch of science that deals with designing and arranging of workplaces.
Match List-I with List-II:
List-IList-II
(A) Cyber Appellate Tribunal(III) Resolves disputes arising from cyber crime.
(B) Environmental Protection Act 1986(I) Punishes people causing pollution.
(C) Indian Information Technology Act 2000(IV) Provides guidelines on storage, processing and transmission of sensitive data.
(D) Central Pollution Control Board(II) Provides guidelines for proper handling and disposal of e-waste.
Cable based broadband internet services are example of ..............
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.
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.
Violation of intellectual property right may happen due to:
(A) Copyright Infringement
(B) Patent
(C) Trademark Infringement
(D) Plagiarism
Which of the following is a networking device?
(A) Gateway
(B) Repeater
(C) MAN
(D) Modem
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) 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:
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:
Dynamic web pages can be created using various languages, like __________.
(A) JavaScript
(B) PHP
(C) Python
(D) Ruby
____________ 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 ____________.

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?
____________ in matplotlib also known as correlation plot, because they show how two variables are related.
Matplotlib library can be installed using pip command. Identify the correct syntax from the following options.

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?

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 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:
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()