List of top Computer Science Questions

Which of the following statements is true in the context of a Deque?

What will be the postfix equivalent of the expression $(A + B) * (C - D)$?

Which of the following is a linear data structure?
(A) Deque
(B) Queue
(C) Stack
(D) Tree
Choose the correct answer from the options given below:

Which of the following elements will be present in a queue after the end of the following operation sequence? Assume the queue is empty initially.
enqueue(10)
enqueue(20)
enqueue(30)
dequeue()
enqueue(40)
dequeue()
enqueue(50)
enqueue(60)
(A) 60
(B) 30
(C) 20
(D) 50
Choose the correct answer from the options given below:

Consider an empty stack. What will the stack look like (starting from the top) after executing the following operations in sequence?
1. push(7)
2. push(5)
3. push(9)
4. push(11)
5. pop()
6. push(22)
(A) 22
(B) 9
(C) 5
(D) 7
Choose the correct answer from the options given below:

The 'raise' keyword in Python is used ________.

Stack follows the ________ principle.

Which of the following statement is correct with respect to exception handling in python?

Which of the following methods is used to position a file object to a specific position in a file?

Arrange the following statements in the correct sequence in order to write multiple strings to a file:
(A) myobj.close()
(B) lines= ["Hello everyone $\backslash$n", "writing multiple strings into file"]
(C) myobj.writelines(lines)
(D) myobj = open ("myfile.txt", 'w')
Choose the correct answer from the options given below:

Match List-I with List-II:
\begin{tabular{|l|l|} 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:

Arrange the evolution of networking as per the development timeline:
(A) The Berners-Lee at CERN developed HTML and URL, thus giving birth to World Wide Web (www).
(B) TCP/IP introduced as standard protocol on ARPANET.
(C) Roy Tomlinson develops network messaging or -mail symbol@ comes to mean "at".
(D) ARPANET became functional by connecting UCLA and SRI.
Choose the correct answer from the options given below:

The RJ in RJ-45 connector stands for :

An analog device which regenerates the weakened signal appearing on the cable and puts them back is known as

Which of the following statement is CORRECT about GROUP BY clause in SQL?

A ________ is an access point between an organization's network and the outside world of the internet.

Which of the following are multiple row functions?
(A) Sum
(B) Count
(C) Left
(D) Max
Choose the correct answer from the options given below:

Match List-I with List-II:
\begin{tabular{|l|l|} 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:

Which Sql Statements correctly retrieves records from a 'Commodity' table where the Price is either above 1000 or the product Category is 'Sales'?

Consider the table 'STUDENT':
\begin{tabular{|l|l|l|l|l|l|} 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'?}

Which query correctly finds a category in the 'Commodity' table that has more than 5 products with a Price greater than 600?

________ is known as design of database.

Rama stores the data in a specific format or structure in a file. If the structure or format itself is changed, all the existing application programs accessing that file also need to be changed. Otherwise, the programs may not work correctly. What is this concept called?

Which of the following can uniquely identify the tuples of a relation in a database?
(A) Foreign Key
(B) Primary Key
(C) Candidate Key
(D) Composite Primary Key
Choose the correct answer from the options given below:

________ helps to enforce integrity and identify relationships among tables in a database.