List of top Computer Science Questions asked in CBSE Class Twelve Board Exam

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

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 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?

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

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:

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.

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 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.

State True or False:
While defining a function in Python, the positional parameters in the function header must always be written after the default parameters.