Question 1

Question 7If my_dict is a dictionary as defined below, then which of the following statements will raise an exception ?my_dict = {'apple' : 10, 'banana' : 20, 'orange' : 30}my_dict.get('orange')print(my_dict['apple', 'banana'])my_dict['apple'] = 20print(str(my_dict))

Accepted Answer

print(my_dict['apple', 'banana'])Reason — In Python dictionaries, keys must be accessed individually or as a single key. The expression my_dict['apple', 'banana'] attempts to use a tuple as a key (i.e., ('apple', 'banana')), which does not exist in my_dict. As a result, this will raise an Error. The other statements will not raise exceptions; my_dict.get('orange') will return 30, my_dict['apple'] = 20 will update the value for the key 'apple', and print(str(my_dict)) will print the dictionary as a string.

Question 2

Question 8What does the list.remove(x) method do in Python ?Removes the element at index x from the listRemoves the first occurrence of value x from the listRemoves all occurrences of value x from the listRemoves the last occurrence of value x from the list

Accepted Answer

Removes the first occurrence of value x from the list.Reason — The list.remove(x) method in Python searches for the first occurrence of the value x in the list and removes it. If the specified value is not found, it raises an Error.

Question 3

Question 9If a table which has one Primary key and two alternate keys. How many Candidate keys will this table have ?1234

Accepted Answer

3Reason — In a table, the primary key uniquely identifies each record, and alternate keys also uniquely identify records but are not the primary key. In this case, with one primary key and two alternate keys, the table will have three candidate keys in total: one primary key and two alternate keys. Candidate keys are potential keys that can uniquely identify records in a table.

Question 4

Question 10Write the missing statement to complete the following code:file = open("example.txt", "r")
data = file.read(100)
............... #Move the file pointer to the beginning of the file
next_data = file.read(50)
file.close()

Accepted Answer

file.seek(0)Reason — To move the file pointer to the beginning of the file, we can use the seek() method. When we pass 0 as the offset to this function, it moves the file pointer to the beginning of the file.So the complete code is:file = open("example.txt", "r")
data = file.read(100)
file.seek(0)  # Move the file pointer to the beginning of the file
next_data = file.read(50)
file.close()

Question 5

Question 11State whether the following statement is True or False:The finally block in Python is executed only if no exception occurs in the try block.

Accepted Answer

FalseReason — The finally block in Python is always executed after the try block, regardless of whether an exception occurred or not.

Source: This question is from Solved 2025 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083): Question, Whether, Statement, True, False, Finally. 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083)Q1: Question 36 Surya is a manager working in a recruitment agency. He needs to manage the records of...
Q10: Question 10 Write the missing statement to complete the following code: file = open ( "example.txt"...
Q12: Question 12 What will be the output of the following code ? c = 10 def add (): global c c = c + 2...
Q13: Question 13 Which SQL command can change the degree of an existing relation ?
Q14: Question 14 What will be the output of the query ? SELECT * FROM products WHERE product_name LIKE &#x27;...
Practice more questions from Solved 2025 Sample Question Paper CBSE Class 12 Computer Science (083) &mdash; Computer Science, Class 12 CBSE

Question 6

Question 12What will be the output of the following code ?c = 10
def add():
    global c
    c = c + 2
    print(c, end = '#')
add()
c = 15
print(c, end = '%')12%15#15#12%12#15%12%15#

Accepted Answer

12#15%Reason —The variable c is initially set to 10.The function add() is defined. Inside this function, the global keyword is used to indicate that the variable c refers to the global variable defined outside the function.Inside add(): When add() is called:The value of c (which is 10) is accessed.It is then incremented by 2, making c equal to 12.The new value of c (12) is printed, followed by a # symbol.After calling the function, the global c is now 12. However, it is then explicitly set to 15.Finally, the new value of c (15) is printed, followed by a % symbol.

Question 7

Question 13Which SQL command can change the degree of an existing relation ?

Accepted Answer

The SQL command that can change the degree of an existing relation (table) is ALTER TABLE.

Source: This question is from Solved 2025 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083): Question, Sql, Command, Change, Degree, Existing. 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083)Q1: Question 36 Surya is a manager working in a recruitment agency. He needs to manage the records of...
Q10: Question 10 Write the missing statement to complete the following code: file = open ( "example.txt"...
Q12: Question 12 What will be the output of the following code ? c = 10 def add (): global c c = c + 2...
Q14: Question 14 What will be the output of the query ? SELECT * FROM products WHERE product_name LIKE &#x27;...
Q15: Question 15 In which datatype the value stored is padded with spaces to fit the specified length....
Practice more questions from Solved 2025 Sample Question Paper CBSE Class 12 Computer Science (083) &mdash; Computer Science, Class 12 CBSE

Question 8

Question 14What will be the output of the query ?SELECT * FROM products WHERE product_name LIKE 'App%';Details of all products whose names start with 'App'Details of all products whose names end with 'App'Names of all products whose names start with 'App'Names of all products whose names end with 'App'

Accepted Answer

Details of all products whose names start with 'App'Reason — The SELECT * statement indicates that every column of data should be returned for each matching record. It uses the LIKE operator with the pattern 'App%', where the % wildcard represents any sequence of characters. Therefore, this query will return details of all products from the products table where the product_name starts with 'App', including any characters that may follow.

Question 9

Question 15In which datatype the value stored is padded with spaces to fit the specified length.DATEVARCHARFLOATCHAR

Accepted Answer

CHARReason — The CHAR data type in SQL is used to store fixed-length strings. When a value is stored in a CHAR field, it is padded with spaces to fit the specified length.

Question 10

Question 16Which aggregate function can be used to find the cardinality of a table ?sum()count()avg()max()

Accepted Answer

count()Reason — The count() aggregate function is used to find the cardinality of a table, which refers to the number of rows in that table.

Source: This question is from Solved 2025 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083): Question, Aggregate, Cardinality, Table, Sum, Count. 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083)Q1: Question 36 Surya is a manager working in a recruitment agency. He needs to manage the records of...
Q10: Question 10 Write the missing statement to complete the following code: file = open ( "example.txt"...
Q12: Question 12 What will be the output of the following code ? c = 10 def add (): global c c = c + 2...
Q13: Question 13 Which SQL command can change the degree of an existing relation ?
Q14: Question 14 What will be the output of the query ? SELECT * FROM products WHERE product_name LIKE &#x27;...
Practice more questions from Solved 2025 Sample Question Paper CBSE Class 12 Computer Science (083) &mdash; Computer Science, Class 12 CBSE

Question 11

Question 17Which protocol is used to transfer files over the Internet ?HTTPFTPPPPHTTPS

Accepted Answer

FTPReason — The File Transfer Protocol (FTP) is used for transferring files over the Internet. It allows users to upload, download, and manage files on remote servers.

Source: This question is from Solved 2025 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083): Question, Protocol, Transfer, Files, Internet, Http. 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083)Q1: Question 36 Surya is a manager working in a recruitment agency. He needs to manage the records of...
Q10: Question 10 Write the missing statement to complete the following code: file = open ( "example.txt"...
Q12: Question 12 What will be the output of the following code ? c = 10 def add (): global c c = c + 2...
Q13: Question 13 Which SQL command can change the degree of an existing relation ?
Q14: Question 14 What will be the output of the query ? SELECT * FROM products WHERE product_name LIKE &#x27;...
Practice more questions from Solved 2025 Sample Question Paper CBSE Class 12 Computer Science (083) &mdash; Computer Science, Class 12 CBSE

Question 12

Question 18Which network device is used to connect two networks that use different protocols ?ModemGatewaySwitchRepeater

Accepted Answer

GatewayReason — A gateway is a network device that connects two networks that use different protocols, enabling communication between them.

Source: This question is from Solved 2025 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083): Question, Network, Device, Connect, Networks, Use. 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 2025 Sample Question Paper CBSE Class 12 Computer Science (083)Q1: Question 36 Surya is a manager working in a recruitment agency. He needs to manage the records of...
Q10: Question 10 Write the missing statement to complete the following code: file = open ( "example.txt"...
Q12: Question 12 What will be the output of the following code ? c = 10 def add (): global c c = c + 2...
Q13: Question 13 Which SQL command can change the degree of an existing relation ?
Q14: Question 14 What will be the output of the query ? SELECT * FROM products WHERE product_name LIKE &#x27;...
Practice more questions from Solved 2025 Sample Question Paper CBSE Class 12 Computer Science (083) &mdash; Computer Science, Class 12 CBSE

Question 13

Question 19Which switching technique breaks data into smaller packets for transmission, allowing multiple packets to share the same network resources.

Accepted Answer

Packet switching is a method of data transmission where data is broken into smaller packets before being sent over the network. Each packet can take different routes to reach the destination, allowing multiple packets from various sources to share the same network resources simultaneously.

Question 14

Question 20Assertion (A): Positional arguments in Python functions must be passed in the exact order in which they are defined in the function signature.Reasoning (R): This is because Python functions automatically assign default values to positional arguments.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

A is true but R is false.ExplanationPositional arguments must be passed in the order they are defined in the function signature in Python. Python does not automatically assign default values to positional arguments. Default values must be explicitly defined in the function signature, if not provided, the function will raise an error.

Question 15

Question 21Assertion (A): A SELECT command in SQL can have both WHERE and HAVING clauses.Reasoning (R): WHERE and HAVING clauses are used to check conditions, therefore, these can be used interchangeably.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

A is true but R is false.ExplanationA SQL SELECT command can have both WHERE and HAVING clauses. The WHERE clause filters records before any grouping occurs, while the HAVING clause filters records after grouping. Therefore, they cannot be used interchangeably as they operate at different stages of query execution.

Question 16

Question 26The code provided below is intended to swap the first and last elements of a given tuple. However, there are syntax and logical errors in the code. Rewrite it after removing all errors. Underline all the corrections made.def swap_first_last(tup)
    if len(tup) < 2:
    return tup
    new_tup = (tup[-1],) + tup[1:-1] + (tup[0])
    return new_tup

result = swap_first_last((1, 2, 3, 4))
print("Swapped tuple: " result)

Accepted Answer

def swap_first_last(tup) # Error 1
    if len(tup) < 2:
    return tup  # Error 2
    new_tup = (tup[-1],) + tup[1:-1] + (tup[0])  # Error 3
    return new_tup

result = swap_first_last((1, 2, 3, 4))
print("Swapped tuple: " result) # Error 4Error 1 — The function header is missing a colon (:) at the end, which is required to define a function in Python.Error 2 — The return statement needs to be indented because it is the part of the if block.Error 3 — Comma should be added after tup[0] to ensure it is treated as a tuple. Without the comma, (tup[0]) is treated as an integer.Error 4 — Comma should be added in the print statement to properly separate the string from the variable.The corrected code is:def swap_first_last(tup):  
    if len(tup) < 2:        
        return tup 
    new_tup = (tup[-1],) + tup[1:-1] + (tup[0],)
    return new_tup

result = swap_first_last((1, 2, 3, 4))
print("Swapped tuple: ", result)

Question 17

Question 31(b)Predict the output of the following code:line = [4, 9, 12, 6, 20] 
for I in line: 
   for j in range(1, I%5): 
       print(j, '#', end="") 
   print()

Accepted Answer

Output1 #2 #3 #
1 #2 #3 #
1 #

ExplanationThe list line contains the values [4, 9, 12, 6, 20].The outer loop iterates over each element (I) in the line list.First Iteration (I = 4):I % 5 = 4 % 5 = 4Inner Loop Range: range(1, 4) → This generates the numbers 1, 2, 3.Output: 1 #2 #3 #Second Iteration (I = 9):I % 5 = 9 % 5 = 4Inner Loop Range: range(1, 4) → This generates the numbers 1, 2, 3.Output: 1 #2 #3 #Third Iteration (I = 12):I % 5 = 12 % 5 = 2Inner Loop Range: range(1, 2) → This generates the number 1.Output: 1 #Fourth Iteration (I = 6):I % 5 = 6 % 5 = 1Inner Loop Range: range(1, 1) → This generates no numbers (empty range).Print: No output for this iteration (just a new line is printed).Fifth Iteration (I = 20):I % 5 = 20 % 5 = 0Inner Loop Range: range(1, 0) → This generates no numbers (empty range).Print: No output for this iteration (just a new line is printed).The final output of the code will be:1 #2 #3 #
1 #2 #3 #
1 #

Question 18

Question 33A csv file "Happiness.csv" contains the data of a survey. Each record of the file contains the following data:Name of a countryPopulation of the countrySample Size (Number of persons who participated in the survey in that country)Happy (Number of persons who accepted that they were Happy)For example, a sample record of the file may be:[‘Signiland’, 5673000, 5000, 3426]Write the following Python functions to perform the specified operations on this file:(I) Read all the data from the file in the form of a list and display all those records for which the population is more than 5000000.(II) Count the number of records in the file.

Accepted Answer

Let the "Happiness.csv" file contain the following data:Signiland, 5673000, 5000, 3426
Happiland, 4500000, 4000, 3200
Joyland, 8000000, 6000, 5000
Cheerland, 3000000, 3500, 2500
(I)def show(): 
    file = open("Happiness.csv",'r') 
    records=csv.reader(file) 
    for i in records: 
        if int(i[1])>5000000: 
            print(i) 
    file.close() Output['Signiland', '5673000', '5000', '3426']
['Joyland', '8000000', '6000', '5000']
(II)def Count_records(): 
    f = open("Happiness.csv",'r') 
    records=csv.reader(f) 
    count=0 
    for i in records: 
            count+=1 
    print(count) 
    f.close() Output4

Question 19

Question 34Saman has been entrusted with the management of Law University Database. He needs to access some information from FACULTY and COURSES tables for a survey analysis. Help him extract the following information by writing the desired SQL queries as mentioned below.Table: FACULTYF_IDFNameLNameHire_DateSalary102AmitMishra12-10-199812000103NitinVyas24-12-19948000104RakshitSoni18-5-200114000105RashmiMalhotra11-9-200411000106SulekhaSrivastava5-6-200610000Table: COURSESC_IDF_IDCNameFeesC21102Grid Computing40000C22106System Design16000C23104Computer Security8000C24106Human Biology15000C25102Computer Network20000C26105Visual Basic6000(I) To display complete details (from both the tables) of those Faculties whose salary is less than 12000.(II) To display the details of courses whose fees is in the range of 20000 to 50000 (both values included).(III) To increase the fees of all courses by 500 which have "Computer" in their Course names.(IV)(A) To display names (FName and LName) of faculty taking System Design.OR(B) To display the Cartesian Product of these two tables.

Accepted Answer

(I)SELECT * FROM FACULTY, COURSES 
WHERE Salary < 12000 AND FACULTY.F_ID = COURSES.F_ID;(II)SELECT * 
FROM COURSES 
WHERE Fees BETWEEN 20000 AND 50000;(III)UPDATE COURSES
SET Fees = Fees + 500
WHERE CName LIKE '%Computer%';(IV)(A)SELECT FName, LName 
FROM FACULTY, COURSES 
WHERE CName = 'System Design' AND
FACULTY.F_ID = COURSES.F_ID;OR(B)SELECT * 
FROM FACULTY, COURSES;

Question 20

Question 35A table, named STATIONERY, in ITEMDB database, has the following structure:FieldTypeitemNoint(11)itemNamevarchar(15)pricefloatqtyint(11)Write the following Python function to perform the specified operation:AddAndDisplay(): To input details of an item and store it in the table STATIONERY. The function should then retrieve and display all records from the STATIONERY table where the Price is greater than 120.Assume the following for Python-Database connectivity:Host: localhost, User: root, Password: Pencil

Accepted Answer

import mysql.connector

def AddAndDisplay():
    db = mysql.connector.connect(
            host="localhost",
            user="root",
            password="Pencil",
            database="ITEMDB"
        )
    cursor = db.cursor()
    item_no = int(input("Enter Item Number: "))
    item_name = input("Enter Item Name: ")
    price = float(input("Enter Price: "))
    qty = int(input("Enter Quantity: "))
    insert_query = "INSERT INTO STATIONERY VALUES ({}, {}, {}, {})"
    insert_query = insert_query.format(item_no, item_name, price, qty)
    cursor.execute(insert_query)
    db.commit()
    select_query = "SELECT * FROM STATIONERY WHERE price > 120"
    cursor.execute(select_query)
    results = cursor.fetchall()
    for record in results:
        print(record)
            
AddAndDisplay()

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

Section A 1 Mark Each

Section B 2 Marks Each

Section C 3 Marks Each

Section D 4 Marks Each

Section E 5 Marks Each