List of top Computer Science Questions on Miscellaneous

Consider a binary file, items.dat, containing records stored in the given format: 
Write a function, Copy\_new(), that copies all records whose amount is greater than 1000 from items.dat to new\_items.dat.

Sangeeta is a Python programmer working in a computer hardware company. She has to maintain the records of the peripheral devices. She created a csv file named Peripheral.csv to store the details. Structure of Peripheral.csv:

\begin{tabular}{|c|c|c|} \hline \textbf{P\_id} & \textbf{P\_name} & \textbf{Price} \\ \hline \end{tabular}

  • P\_id is the Peripheral device ID (integer).
  • P\_name is the Peripheral device name (string).
  • Price is the Peripheral device price (integer).

Sangeeta wants to write the following user-defined functions:

  1. Add\_Device(): To accept a record from the user and add it to the CSV file, Peripheral.csv.
  2. Count\_Device(): To count and display the number of peripheral devices whose price is less than 1000.
Consider the table Projects given below: \[ \begin{array}{|c|l|c|c|c|} \hline \textbf{P\_id} & \textbf{Pname} & \textbf{Language} & \textbf{Startdate} & \textbf{Enddate} \\ \hline P001 & School Management System & Python & 2023-01-12 & 2023-04-03 \\ P002 & Hotel Management System & C++ & 2022-12-01 & 2023-02-02 \\ P003 & Blood Bank & Python & 2023-02-11 & 2023-03-02 \\ P004 & Payroll Management System & Python & 2023-03-12 & 2023-06-02 \\ \hline \end{array} \] Based on the given table, write SQL queries for the following:
  1. Add the constraint, primary key to column P_id in the existing table Projects:
  2. Change the language to Python of the project whose ID is P002:
  3. Delete the table Projects from the MySQL database along with its data:

Write the SQL commands to perform the following tasks: 
(i) View the list of tables in the database Exam
(ii) View the structure of the table Term1

Write the output displayed on execution of the following Python code: 
LS = ["HIMALAYA", "NILGIRI", "ALASKA", "ALPS"]
D = {}
for S in LS:
    if len(S) % 4 == 0:
        D[S] = len(S)
for K in D:
    print(K, D[K], sep = "#")

The code given below accepts five numbers and displays whether they are even or odd: 
Observe the following code carefully and rewrite it after removing all syntax and logical errors. 
Underline all the corrections made.

Assertion (A): The expression "HELLO".sort() in Python will give an error. 
Reason (R): sort() does not exist as a method/function for strings in Python. 
Mark the correct choice: 
 

Fill in the blank: 
\(\_\_\_\_\_\_\_\_\) is a set of rules that needs to be followed by the communicating parties in order to have a successful and reliable data communication over a network. 
 

Observe the given Python code carefully: 
a = 20
def convert(a):
    b = 20
    a = a + b
convert(10)
print(a)
Select the correct output from the given options:
Identify the statement from the following which will raise an error:
Which protocol out of the following is used to send and receive emails over a computer network?
What will be the output of the following statement:
print(16 * 5 / 4 * 2 / 5 - 8)
Arrange the following commands in the correct order of execution
(A) SELECT 
(B) ORDER BY 
(C) GROUP BY 
(D) WHERE 
(E) FROM
 Choose the correct answer from the options given below:
Consider that:
a = [20, 30, 40] 
b=a 
b[0] = 72 
print (a)
The output will be : 
Unstructured data are sometimes described with the help of some other data is called
Today E-waste become a major concern to the environment. To save the environment we should avoid this practise: