CBSE-CLASS-XII SERIES
Computer-science

Miscellaneous

12 previous year questions.

Volume: 12 Ques
Yield: Medium

High-Yield Trend

12
2024

Chapter Questions
12 MCQs

01
PYQ 2024
medium
computer-science ID: cbse-cla
What will be the output of the following statement:
print(16 * 5 / 4 * 2 / 5 - 8)
1

-3.33

2
6.0
3

0.0

4
-13.33
02
PYQ 2024
medium
computer-science ID: cbse-cla

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.

03
PYQ 2024
medium
computer-science ID: cbse-cla

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.
04
PYQ 2024
medium
computer-science ID: cbse-cla
Consider the table Projects given below: 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:
05
PYQ 2024
medium
computer-science ID: cbse-cla

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

06
PYQ 2024
medium
computer-science ID: cbse-cla
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 = "#") 
07
PYQ 2024
medium
computer-science ID: cbse-cla

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.

08
PYQ 2024
medium
computer-science ID: cbse-cla

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:

1
Both (A) and (R) are true and (R) is the correct explanation for (A).
2
Both (A) and (R) are true and (R) is not the correct explanation for (A).
3
(A) is true but (R) is false.
4
(A) is false but (R) is true.
09
PYQ 2024
medium
computer-science ID: cbse-cla

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.

10
PYQ 2024
medium
computer-science ID: cbse-cla
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:
1

10

2

20

3

30

4

Error

11
PYQ 2024
medium
computer-science ID: cbse-cla
Identify the statement from the following which will raise an error:
1

print("A"*3)

2

print(5*3)

3

print("15" + 3)

4

print("15" + "13")

12
PYQ 2024
medium
computer-science ID: cbse-cla
Which protocol out of the following is used to send and receive emails over a computer network?
1

PPP

2

HTTP

3

FTP

4

SMTP