Question 1

Question 8Consider the statements given below and then choose the correct output from the given options:pride = "#G20 Presidency"
print(pride[-2:2:-2])ndsrceieP0ceiePyndsr

Accepted Answer

ceieP0Reason — The code assigns the string "#G20 Presidency" to the variable pride. The slicing operation pride[-2:2:-2] starts from the second last character ("y"), which is at index -2, moves backward by 2 characters at a time due to the step value of -2, and stops before reaching the third character ("G"), which is at index 2. Hence, the output will be 'ceieP0'.

Question 2

Question 10What possible outputs(s) will be obtained when the following code is executed?import random
myNumber = random.randint(0, 3)
COLOR = ["YELLOW", "WHITE", "BLACK", "RED"]
for I in range(1, myNumber):
    print(COLOR[I], end = "*")
    print()RED*WHITE*BLACK*WHITE*BLACK*WHITE* WHITE*BLACK* BLACK*YELLOW*WHITE*WHITE*BLACK* BLACK* BLACK*

Accepted Answer

WHITE*BLACK*Reason — random.randint(0, 3) will generate a random integer between 0 and 3. Possible outcomes are 0, 1, 2, or 3. Since 0 and 1 would make the loop invalid, we consider 2 and 3.When myNumber is 2:The loop for i in range(1, myNumber) will iterate over range(1, 2), which includes only the number 1. The code will print COLOR[1], which is "WHITE", followed by an asterisk (*). So, one of the possible outputs is:WHITE*When myNumber is 3:The loop for i in range(1, myNumber) will iterate over range(1, 3), which includes the numbers 1 and 2. The code will print COLOR[1], which is "WHITE", followed by an asterisk (*), and then move to the next line. Then, it will print COLOR[2], which is "BLACK", followed by an asterisk (*). So, the other possible output is:WHITE*BLACK*Since the output when myNumber is 3 is among the possible outputs, it's the correct answer.

Question 3

Question 12Consider the code given below:b = 100
def test(a):
............... #missing statement
    b = b + a
    print(a, b)
test(10)
print(b)Which of the following statements should be given in the blank for #Missing Statement, if the output produced is 110?global aglobal b = 100global bglobal a = 100

Accepted Answer

global bReason — When we want to modify a global variable within a function in Python, we need to use the global keyword followed by the name of the global variable. In this case, since the variable b is declared as a global variable outside the function, we need to declare it as a global variable again inside the function using global b before attempting to modify its value.

Question 4

Question 13State whether the following statement is True or False:An exception may be raised even if the program is syntactically correct.

Accepted Answer

TrueReason — An exception can be raised even if the program is syntactically correct. This can happen due to various runtime errors such as division by zero, accessing an index out of range, trying to perform an operation on incompatible data types, etc. These types of errors are detected during the execution of the program and can lead to exceptions being raised, even if the program's syntax is correct.

Question 5

Question 14Which of the following statements is FALSE about keys in a relational database?Any candidate key is eligible to become a primary key.A primary key uniquely identifies the tuples in a relation.A candidate key that is not a primary key is a foreign key.A foreign key is an attribute whose value is derived from the primary key of another relation.

Accepted Answer

A candidate key that is not a primary key is a foreign key.Reason — A candidate key that is not chosen as the primary key remains a candidate key and is not automatically a foreign key.

Question 6

Question 15Fill in the blank:In case of ............... switching, before a communication starts, a dedicated path is identified between the sender and the receiver.

Accepted Answer

circuit

Source: This question is from Solved 2024 Sample Question Paper CBSE Class 12 Computer Science (083), Computer Science &mdash; Class 12, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Solved 2024 Sample Question Paper CBSE Class 12 Computer Science (083): Question, Fill, Blank, Case, Switching, Communication. These are fundamental topics in Computer Science that students are expected to master as part of the CBSE Class 12 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Computer Science papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberWrite programs with proper indentation and comments.
Trace through your code with sample inputs to verify correctness.
Explain the logic behind each step of your solution.
Familiarise yourself with common library functions and methods.
Related Questions from Solved 2024 Sample Question Paper CBSE Class 12 Computer Science (083)Q1: Question 31 Consider the tables PRODUCT and BRAND given below: Table: PRODUCT PCode PName UPrice...
Q10: Question 10 What possible outputs(s) will be obtained when the following code is executed? import...
Q11: Question 25 Predict the output of the following code: def Changer ( P , Q = 10 ): P = P / Q Q = P %...
Q12: Question 12 Consider the code given below: b = 100 def test ( a ): ............... #missing...
Q13: Question 13 State whether the following statement is True or False: An exception may be raised even...
Practice more questions from Solved 2024 Sample Question Paper CBSE Class 12 Computer Science (083) &mdash; Computer Science, Class 12 CBSE

Question 7

Question 16Which of the following functions changes the position of file pointer and returns its new position?flush()tell()seek()offset()

Accepted Answer

seek()Reason — The seek() function in Python is utilised to relocate the file pointer within a file to a specific position. It also accepts an optional second argument, which denotes the starting point for determining this new position.

Question 8

Question 17Assertion(A): List is an immutable data type.Reasoning(R): When an attempt is made to update the value of an immutable variable, the old variable is destroyed and a new variable is created by the same name in memory.Both A and R are true, and R is the correct explanation of A.Both A and R are true, and R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Assertion is false but Reason is true.Reason — List is a mutable data type. When an attempt is made to update the value of an immutable variable, the old variable is destroyed and a new variable with the updated value is created, and the variable name is reassigned to point to this new object in memory.

Question 9

Question 18Assertion(A): Python Standard Library consists of various modules.Reasoning(R): A function in a module is used to simplify the code and avoids repetition.Both A and R are true, and R is the correct explanation of A.Both A and R are true, and R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both Assertion and Reason are true but Reason is not the correct explanation for Assertion.Reason — The Python Standard Library is a collection of modules and packages that provide a wide range of functionalities. A function in a module helps to organize code, simplify it, and avoid repetition which makes programming more efficient.

Question 10

Question 20The code given below accepts a number as an argument and returns the reverse number. Observe the following code carefully and rewrite it after removing all syntax and logical errors. Underline all the corrections made.define revNumber(num):
    rev = 0
    rem = 0
    While num > 0:
        rem == num % 10
        rev = rev * 10 + rem
        num = num//10
        return rev
print(revNumber(1234))

Accepted Answer

def revNumber(num):  #correction 1
    rev = 0
    rem = 0
    while num > 0: #correction 2
        rem = num % 10  #correction 3
        rev = rev * 10 + rem
        num = num // 10
    return rev  #correction 4
print(revNumber(1234))Explanationcorrection 1 — The correct keyword to define a function is "def" not "define".correction 2 — Instead of "While" (capital W) in the while loop, it should be "while" (lowercase w).correction 3 — The comparison operator "==" in the line rem == num % 10 should be replaced with the assignment operator "=".correction 4 — Moved the "return" statement outside the while loop to return the reversed number after the loop completes.

Question 11

Question 23(a)Write the Python statement for each of the following tasks using BUILT-IN functions/methods only:(i) To insert an element 200 at the third position, in the list L1.(ii) To check whether a string named, message ends with a full stop / period or not.

Accepted Answer

(i)L1.insert(2, 200)(ii)message.endswith('.')

Question 12

Question 24(a)Ms. Shalini has just created a table named “Employee” containing columns Ename, Department and Salary. After creating the table, she realized that she has forgotten to add a primary key column in the table. Help her in writing an SQL command to add a primary key column EmpId of integer type to the table Employee. Thereafter, write the command to insert the following record in the table:EmpId - 999Ename - ShwetaDepartment: ProductionSalary: 26900

Accepted Answer

SQL command to add primary key in the table:ALTER TABLE Employee ADD EmpId INTEGER
PRIMARY KEY ;SQL command for inserting data will be:INSERT INTO Employee (EmpId, Ename, Department, Salary)
VALUES (999, "Shweta", "Production", 26900) ;

Question 13

Question 25Predict the output of the following code:def Changer(P, Q = 10):
    P = P / Q
    Q = P % Q
    return P

A = 200
B = 20
A = Changer(A, B)
print(A, B, sep = '$')
B = Changer(B)
print(A, B, sep = '$', end = '###')

Accepted Answer

Output10.0$20
10.0$2.0###
ExplanationThe code snippet provided defines a function Changer that takes two parameters P and Q, where Q is assigned a default value of 10. Inside the function, P is divided by Q and P is assigned the quotient, and then Q is assigned the remainder of P divided by Q. The modified P value is returned from the function. In the main code, variables A and B are initialized with values 200 and 20, respectively. The Changer function is called first with A and B as arguments, modifying the value of A. The updated values of A and B are then printed with a separator of '$'. Next, the Changer function is called again with only B as an argument, updating B. Finally, the updated values of A and B are printed again with a separator of '$' and an end marker of '###'.

Question 14

Question 30A list, NList contains following record as list elements:[City, Country, distance from Delhi]Each of these records are nested together to form a nested list. Write the following user defined functions in Python to perform the specified operations on the stack named travel.(i) Push_element(NList): It takes the nested list as an argument and pushes a list object containing name of the city and country, which are not in India and distance is less than 3500 km from Delhi.(ii) Pop_element(): It pops the objects from the stack and displays them. Also, the function should display “Stack Empty” when there are no elements in the stack.For example: If the nested list contains the following data:NList=[["New York", "U.S.A.", 11734], ["Naypyidaw", "Myanmar", 3219], ["Dubai", "UAE", 2194], ["London", "England", 6693], ["Gangtok", "India", 1580], ["Columbo", "Sri Lanka", 3405]]The stack should contain:['Naypyidaw', 'Myanmar'], ['Dubai', 'UAE'], ['Columbo', 'Sri Lanka']The output should be:['Columbo', 'Sri Lanka']
['Dubai', 'UAE']
['Naypyidaw', 'Myanmar']
Stack Empty

Accepted Answer

(i)NList=[["New York", "U.S.A.", 11734], ["Naypyidaw", "Myanmar", 3219], ["Dubai", "UAE", 2194], ["London", "England", 6693], ["Gangtok", "India", 1580], ["Columbo", "Sri Lanka", 3405]]  
travel = []
def Push_element(NList):
    for L in NList:
        if L[1] != "India" and L[2] < 3500:
            travel.append([L[0], L[1]])
    return travel
print(Push_element(NList))(ii)travel = ['Naypyidaw', 'Myanmar'], ['Dubai', 'UAE'], ['Columbo', 'Sri Lanka']
def Pop_element():
    while len(travel):
        print(travel.pop())
    else:
        print("Stack Empty")
Pop_element()

Question 15

Question 31Consider the tables PRODUCT and BRAND given below:Table: PRODUCTPCodePNameUPriceRatingBIDP01Shampoo1206M03P02Toothpaste548M02P03Soap257M03P04Toothpaste654M04P05Soap385M05P06Shampoo2456M05Table: BRANDBIDBNameM02Dant KantiM03MedimixM04PepsodentM05DoveWrite SQL queries for the following:(i) Display product name and brand name from the tables PRODUCT and BRAND.(ii) Display the structure of the table PRODUCT.(iii) Display the average rating of Medimix and Dove brands.(iv) Display the name, price, and rating of products in descending order of rating.

Accepted Answer

(i)SELECT PName, BName FROM PRODUCT P, 
BRAND B WHERE P.BID = B.BID;(ii)DESC PRODUCT;(iii)SELECT BName, AVG(Rating) FROM PRODUCT 
P, BRAND B
WHERE P.BID = B.BID
GROUP BY BName
HAVING BName = 'Medimix' OR 
BName = 'Dove';(iv)SELECT PName, UPrice, Rating
FROM PRODUCT
ORDER BY Rating DESC;

Question 16

Question 32Vedansh is a Python programmer working in a school. For the Annual Sports Event, he has created a csv file named Result.csv, to store the results of students in different sports events. The structure of Result.csv is :[St_Id, St_Name, Game_Name, Result]WhereSt_Id is Student ID (integer)ST_name is Student Name (string)Game_Name is name of game in which student is participating(string)Result is result of the game whose value can be either 'Won', 'Lost' or 'Tie'.For efficiently maintaining data of the event, Vedansh wants to write the following user defined functions:Accept() – to accept a record from the user and add it to the file Result.csv. The column headings should also be added on top of the csv file.wonCount() – to count the number of students who have won any event.As a Python expert, help him complete the task.

Accepted Answer

Python code to accept records from users :def Accept():
    sid = int(input("Enter Student ID"))
    sname = input("Enter Student Name")
    game = input("Enter name of game")
    res = input("Enter Result")
    headings = ["Student ID", "Student Name", "Game Name", "Result"]
    data = [sid, sname, game, res]
    f = open('Result.csv', 'a', newline = '')
    csvwriter = csv.writer(f)
    csvwriter.writerow(headings)
    csvwriter.writerow(data)
    f.close()Python code to count the number of students who have won any event :def wonCount():
    f = open('Result.csv', 'r')
    csvreader = csv.reader(f, delimiter = ',')
    head = list(csvreader)
    print(head[0])
    for x in head:
        if x[3] == "WON":
            print(x)
    f.close()

Question 17

Question 35(a)(i) Define the term Domain with respect to RDBMS. Give one example to support your answer.(ii) Kabir wants to write a program in Python to insert the following record in the table named Student in MYSQL database, SCHOOL:rno(Roll number )- integername(Name) - stringDOB (Date of birth) – DateFee – floatNote the following to establish connectivity between Python and MySQL:Username - rootPassword - tigerHost - localhostThe values of fields rno, name, DOB and fee has to be accepted from the user. Help Kabir to write the program in Python.

Accepted Answer

(i) Domain is a set of values from which an attribute can take value in each row.For example, roll no field can have only integer values and so its domain is a set of integer values.(ii)import mysql.connector as mysql
con1 = mysql.connect(host = "localhost",
                     user = "root",
                     password = "tiger",
                     database = "SCHOOL")
mycursor = con1.cursor()
rno = int(input("Enter Roll Number:: "))
name = input("Enter the name:: ")
DOB = input("Enter date of birth:: ")
fee = float(input("Enter Fee:: "))
query = "INSERT into student values({}, '{}', '{}', {})".format(rno, name, DOB, fee)
mycursor.execute(query)
con1.commit()
print("Data added successfully")
con1.close()

Question 18

Question 35(b)(i) Give one difference between alternate key and candidate key.(ii) Sartaj has created a table named Student in MYSQL database, SCHOOL:rno(Roll number )- integername(Name) - stringDOB (Date of birth) – DateFee – floatNote the following to establish connectivity between Python and MySQL:Username - rootPassword - tigerHost - localhostSartaj, now wants to display the records of students whose fee is more than 5000. Help Sartaj to write the program in Python.

Accepted Answer

(i) One difference between alternate key and candidate key:Alternate KeyCandidate KeyA candidate key is a set of attributes (columns) in a table that uniquely identifies each record or row.An alternate key is a set of attributes (columns) in a table that uniquely identifies each record but is not designated as the primary key.(ii)import mysql.connector as mysql
con1 = mysql.connect(host = "localhost",
                     user = "root",
                     password = "tiger",
                     database = "SCHOOL")
mycursor = con1.cursor()
query = "SELECT * FROM student WHERE fee > {}".format(5000)
mycursor.execute(query)
data = mycursor.fetchall()
for rec in data:
    print(rec)
con1.close()

Solved 2024 Sample Question Paper CBSE Class 12 Computer Science (083)

Section A Objective Type Questions 1 Mark Each

Section B Very Short Answer Questions 2 Marks Each

Section C Short Answer Questions 3 Marks Each

Section D Long Answer Questions 4 Marks Each

Section E Sourcecase Based Questions 5 Marks Each