List of top Computer Science Questions

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 :

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

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

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

Serial search or sequential search are also known as _____.

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 ?

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 :

Which is not the operation of Queue ?

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 device maintains a database of domain names and their corresponding IP addresses ?

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.

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

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 :

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

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 :

Which of the following statement is not true ?

Consider the following table -

SID	SName	Contact No	Age	Course	Year
2301	Rajat	8167782923	0	CS	2022
2302	Kamal	8168842399	21	HIS	2023
2303	Amit	8167832455	20	ECO	2022
2304	Sujata	7987235422	20	MATH	2022
2305	Amita	6276542311	21	ENG	2023

Identify the correct pair of values :