List of top Questions asked in CUET (UG)

Match List I with List II

List I		List II
A.	select mod(13, 3);	I.	12
B.	select power(5, 3);	II.	3
C.	select length('Data Science');	III.	1
D.	select month('2000-03-12)	IV.	125

Choose the correct answer from the options given below :

Consider the height of 9 students of a class in centimeter :

S.No	1	2	3	4	5	6	7	8	9
Height(x) in cm	110	110	100	90	85	115	110	102	90

What will be the value of mean \((\bar{x})\) and \(\sum(x-\bar{x})^2\) respectively ?

In which of the following sorting, the smallest element is selected from the unsorted array and swapped with the leftmost element and that element becomes a part of sorted array ?

Which of the following statement is NOT correct ?
A. By default, ORDER by clause sorts the result set in decreasing order
B. SUM() function is used to count the total no. of records in a table
C. By default, ORDER BY clause sorts the results set in increasing order
D. AVG() is an aggregrate function
E. The WHERE clause is used to specify filtering conditions for groups
Consider the correct answer from the options given below :

String function in SQL is/are -
A. LTRIM()
B. RIGHT()
C. MID()
D. DAY()
E. MAX()
Choose the correct answer from the options given below :

Which of the following statements are true ?
A. Mean is not a statistical technique used for data summarisation.
B. Range is the difference between the maximum and minimum value.
C. Mode is the data value that appears least number of times.
D. Statistical analysis helps in revealing data characteristics.
Choose the correct answer from the options given below :

Sorting a large number of items can take a substantial amount of time is called ______.

Serial search or sequential search are also known as _____.

A loop within a loop (nested loop) have time complexity ______.

Consider a list [8, 7, 13, 1, -5, 4]
After 3rd pass of Bubble Sort, we get

In a queue, insertions can take place only at the _____ end.

Each element in the list is compared one by one with key is called _____.

Locating a particular element in a collection of elements is called ______.

What kind of build in exception will show by the following code ?
str = ‘Today is holiday’
print(str[20])

You try to pop an element from a stack which is empty. This can result into a special kind of condition, which is known as ________.

Which out of the following can be picked as the application of stack ?

Convert A+(B*C-(D/E^F)*G)*H into its equivalent postfix expression.

Which of the following is/are correct about double ended queue ?
A. Insertion and deletion operation perform only at rear side
B. Insertion and deletion operation perform only at front end
C. Insertion and deletion operation performs at both front and rear end
D. Vehicles in a high-way toll tax booth are served following the principles of deque
E. To implementation of deque used list data type in python
Choose the correct answer from the options given below :

Which is not the operation of Queue ?

In which file mode/modes the file offset position will be at the end of the file.
A. <a+>
B. <w>
C. <r>
D. <a>
E. <r+>
Choose the correct answer from the options given below :

Match List I with List II

List I		List II
A.	MAC address	I.	32 bits
B.	RJ-45	II.	NIC card
C.	IP address	III.	48 bits
D.	Ethernet card	IV.	Ethernet cables

Choose the correct answer from the options given below :

Which of the following address is associated with a network adapter (NIC) ?

Which of the following statements is/are true ?
A. Group by function is used to group rows of a table that contain same values in a specified column.
B. The BETWEEN operator used for pattern matching
C. The IN operator selects the value that match any value in the given list of values
D. COUNT, MAX, MIN, AVG and SUM are multiple row functions works on a set of records and return a single value
E. Update table is used to change the data in a table
Choose the correct answer from the options given below :

Let us consider two relations Student and Major as shown in Table 1 and Table 2 respectively.
Table 1 : Student

Sr No.	Name	Course
1.	Aman	CS
2.	Ravi	ECO
3.	Mohit	HIS
4.	Sanjay	MATH

Table 2 : Major

Sr.No	Name	Course
1.	Sanjay	MATH
2.	Abhay	ENG
3.	Sita	HINDI
4.	Aman	CS
5.	Ravi	ECO

How many Tuples will be in the result table after Student U Major operation.

What is the output of the following SQL query ?
SELECT * FROM STUDENTS WHERE SName like ‘%S’ and age > 18;