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

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

Consider the given DataFrame df4:

NAMEPERIODICENGMATHSSCIENCE
MEENA1406080
REENA2603010
TEENA3806040
SHEENA2902070

We want the following output:

NAMEMEENAREENATEENASHEENA
PERIODIC8
ENG270
MATHS170
SCIENCE200
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.
The process of changing the structure of a DataFrame using function pivot() is known as .............
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 the following series ser1:

IndexValue
069
180
220
350
4100
570

State the output of the following command:

print(ser1 >= 70)

The SELECT command when combined with DISTINCT clause is used to:
Identify the relational algebra operation denoted by: \[ \text{Course X Student;} \] where 'Course' and 'Student' are two relations and X is an operation.
____________________________________ is used to search for a specific pattern in a column.
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
__________ is the process of transforming data or an object in memory (RAM) to a stream of bytes called byte streams.
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?
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.

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

How can you save a matplotlib plot as a file?

Given the following relations:

Table A

NameHobbies
AnuDance
AnujMusic

TableB

NameHobbies
PrannavReading
AnujMusic

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

Matplotlib library can be installed using pip command. Identify the correct syntax from the following options.
Cable based broadband internet services are example of ..............
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
__________ operation is used to get the common tuples from two relations.
____________ in matplotlib also known as correlation plot, because they show how two variables are related.
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:
HTTP is .............
__________ is a branch of science that deals with designing and arranging of workplaces.