List of top Computer Science Questions on Miscellaneous asked in CBSE CLASS XII

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)