List of top Computer Science Questions asked in CBSE CLASS XII

N = '5'
try:
    print('WORD' + N, end='#')
except:
    print('ERROR', end='#')
finally:
    print('OVER')

Consider the statements given below and then choose the correct output from the given options:

def Change(N):
    N = N + 10
    print(N, end='$$')

N = 15
Change(N)
print(N)

While creating a table, which constraint does not allow insertion of duplicate values in the table?

Consider the statements given below and then choose the correct output from the given options:

D = {'S01': 95, 'S02': 96}
for I in D:
    print(I, end='#')

Which of the following operator evaluates to True if the variable on either side of the operator points towards the same memory location and False otherwise?

Consider the statements given below and then choose the correct output from the given options:
L = ['TIC', 'TAC']
print(L[::-1])

Identify the invalid Python statement out of the following options:

Which of the following is the correct identifier?

Identify the correct output of the following code snippet:
game = "Olympic2024"
print(game.index("C"))

What will be the output of the following statement?
print(14%3**2*4)

State True or False: “A Python List must always contain all its elements of same data type.”

‘Swabhaav’ is a big NGO working in the field of Psychological Treatment and Counselling, having its Head Office in Nagpur. It is planning to set up a center in Vijayawada. The Vijayawada Center will have four blocks – ADMIN, PSYCHIATRY, PSYCHOLOGY, and ICU. You, as a Network Expert, need to suggest the best network-related solutions for them to resolve the issues/problems mentioned in questions (i) to (v), keeping the following parameters in mind:

Suman has created a table named WORKER with a set of records to maintain the data of the construction sites, which consists of WID, WNAME, WAGE, HOURS, TYPE, and SITEID. After creating the table, she entered data in it, which is as follows :

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.

Differentiate between 'w' and 'a' file modes in Python.

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:

Add\_Device(): To accept a record from the user and add it to the CSV file, Peripheral.csv.
Count\_Device(): To count and display the number of peripheral devices whose price is less than 1000.

Consider the tables Admin and Transport given below:

Table: Admin

\[ \begin{array}{|c|c|c|c|} \hline \textbf{S\_id} & \textbf{S\_name} & \textbf{Address} & \textbf{S\_type} \\ \hline S001 & Sandhya & Rohini & Day Boarder \\ S002 & Vedanshi & Rohtak & Day Scholar \\ S003 & Vibhu & Raj Nagar & NULL \\ S004 & Atharva & Rampur & Day Boarder \\ \hline \end{array} \]

Table: Transport

\[ \begin{array}{|c|c|c|} \hline \textbf{S\_id} & \textbf{Bus\_no} & \textbf{Stop\_name} \\ \hline S002 & TSS10 & Sarai Kale Khan \\ S004 & TSS12 & Sainik Vihar \\ S005 & TSS10 & Kamla Nagar \\ \hline \end{array} \]

Write SQL queries for the following:

Display the student name and their stop name from the tables Admin and Transport.
Display the number of students whose S_type is not known.
Display all details of the students whose name starts with 'V'.
Display student ID and address in alphabetical order of student name, from the table Admin.

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:

Add the constraint, primary key to column P_id in the existing table Projects:
Change the language to Python of the project whose ID is P002:
Delete the table Projects from the MySQL database along with its data:

Write a function, c_words(), in Python that separately counts and displays the number of uppercase and lowercase alphabets in a text file, Words.txt

Write a user-defined function in Python named showInLines() which reads contents of a text file named STORY.TXT and displays every sentence in a separate line. Assume that a sentence ends with a full stop (.), a question mark (?), or an exclamation mark (!). Example:
If the content of the file STORY.TXT is:


    Our parents told us that we must eat vegetables to be healthy. And it turns out, our parents were right! So, what else did our parents tell?

Then the function should display:


    Our parents told us that we must eat vegetables to be healthy.

    And it turns out, our parents were right!

    So, what else did our parents tell?

Predict the output of the following code:

def callon(b=20, a=10):
    b = b + a
    a = b - a
    print(b, "#", a)
    return b

x = 100
y = 200
x = callon(x, y)
print(x, "@", y)
y = callon(y)
print(x, "@", y)

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