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

Consider the table 'STUDENT':

Name	Class	DOB	Gender	City	Marks
Rohan	XI	2008	M	Delhi	85
Priya	XII	2006	F	Mumbai	92
Ankit	XI	2007	M	Delhi	88
Nidhi	XII	2006	F	Mumbai	90
Aarav	IX	2009	M	Kolkata	78
Simran	XI	2007	F	Chandigarh	94
Rahul	XII	2006	M	Pune	80

From the above table 'STUDENT', which query will return all the students from class 'XI'?

Match List-I with List-II:

List-I	List-II
(A) Retrieve all rows with duplicates removed	(I) GROUP BY
(B) Filter rows based on condition	(II) ORDER BY
(C) Aggregate data into groups	(III) DISTINCT
(D) Sort rows in ascending or descending order	(IV) WHERE

Choose the correct answer from the options given below:

Match List-I with List-II:

List-I (Network Devices)	List-II (Description)
(A) Switch	(I) Sends signals only to the selected devices instead of sending to all.
(B) Repeater	(II) An analog device that works with signals on the cables to which it is connected.
(C) Hub	(III) A network device used to connect different devices through wires.
(D) Ethernet Card	(IV) A network adapter acts as an interface between the computer and the network.

Choose the correct answer from the options given below:

Match List-I with List-II:

List-I (Key Concepts in Database)	List-II (Description)
(A) Database Schema	(I) Snapshot of the database
(B) Database Instance	(II) Restriction on the type of data
(C) Data Dictionary	(III) Skeleton of the database
(D) Data Constraint	(IV) Database catalog

Choose the correct answer from the options given below:

Calculate the degree and cardinality of the given relation below:

ID	Name	Email	Address	Phone No.
001	Ajay	ajay@abc.com	A1-Shakti Nagar, Bangalore	55218936
002	Amit	amit@abc.com	C32-Indira Nagar, Lucknow	45321789
003	Ashu	ashu@abc.com	117/82 Patel Nagar, Delhi	98567894
004	Ashok	ashok@abc.com	249-250, Motinagar, Gujrat	97698541

Sales

ID	customer_id	order_date	total_amount
1	C101	2022-01-15	1000
2	C102	2022-02-20	500
3	C103	2022-03-10	800
4	C101	2022-04-05	600

What is the result of the following query with respect to the given relation 'Sales'?

SELECT COUNT(DISTINCT customer_id) FROM Sales;

Match List-I with List-II:

List-I (Topology)	List-II (Characteristics)
(A) Star	(I) Single backbone cable
(B) Bus	(II) Central hub or switch
(C) Ring	(III) Unidirectional link
(D) Hybrid	(IV) Multiple branches

Choose the correct answer from the options given below:

Consider the following numList:

Sequence the following output obtained after each pass of comparison using bubble sort.

(A) \(7\quad 8\quad 1\quad -9\quad 4\quad 13\)
(B) \(7\quad 1\quad -9\quad 4\quad 8\quad 13\)
(C) \(-9\quad 1\quad 4\quad 7\quad 8\quad 13\)
(D) \(1\quad -9\quad 4\quad 7\quad 8\quad 13\)

Choose the correct answer from the options given below:

Match List-I with List-II:

List-I (Malware)	List-II (Threat)
(A) Keylogger	(I) It generates revenue using “pay per click” mechanism to charge its clients against the number of clicks on their displayed ads.
(B) Adware	(II) Makes the logs of daily keyboard usage and may send it to an external entity as well.
(C) Spyware	(III) Standalone programs that are capable of replicating on their own and can spread to other computers through the network.
(D) Worm	(IV) Usually tracks internet usage data and sells it to advertisers.

Choose the correct answer from the options given below:

What is the measurment unit of bandwidth?

What is the range of frequency for radio waves?

Which statement is true about a Trojan?

Which malware type disguises itself as legitimate software?

________ is a search technique that makes use of the ordering of elements in the list to quickly search for a key.

What describes the work of a repeater?

Which protocol is used to format and transmit the information from the World Wide Web?

Sometimes, on calling a customer service center, the Interactive Voice Response System (IVRS) tells us to wait till a support person is available. Which data structure this application is of?

Calculate the standard deviation of the given temperature below recorded for the 7 days of a week:
24, 24, 21, 20, 26, 27, 30

Which measure of central tendency is better suited for dealing with an outlier?

Suppose you want to select distinct salaries working in department 101 from the 'Employee' relation. What will be the correct order of writing the query?
(A) FROM Employee
(B) SELECT
(C) WHERE
(D) DISTINCT Salary
(E) Dept_ID= 101
Choose the correct answer from the options given below: