Question 1

Question 1State True or False:"In a Python program, if a break statement is given in a nested loop, it terminates the execution of all loops in one go."

Accepted Answer

FalseReason — In a Python program, if a break statement is given in a nested loop, it only terminates the execution of the innermost loop where the break statement is encountered. It does not affect the outer loops or any remaining loops in the nested structure.

Question 2

Question 2In a table in MYSQL database, an attribute A of datatype varchar(20) has the value "Keshav". The attribute B of datatype char(20) has value “Meenakshi”. How many characters are occupied by attribute A and attribute B ?20, 66, 209, 66, 9

Accepted Answer

6, 20Reason — The datatype VARCHAR(20) is a variable-length character string that can store up to 20 characters. When "Keshav" (6 characters) is assigned to attribute A with VARCHAR(20), it occupies only 6 characters of storage space because VARCHAR adjusts the space based on the actual data length. The datatype CHAR(20) is a fixed-length character string that always occupies the specified amount of space, in this case, 20 characters. When "Meenakshi" (9 characters) is assigned to attribute B with CHAR(20), it still occupies all 20 characters of storage space because CHAR pads the data with spaces to fill up the allocated space, even if the actual data is shorter.

Question 3

Question 3What will be the output of the following statement:print(3 - 2 ** 2 ** 3 + 99/11)244244.0-244.0Error

Accepted Answer

-244.0Reason — In Python, both ** (exponentiation) and / (division) operators have the same level of precedence, which means they are evaluated from left to right if they appear together without parentheses. However, the exponentiation operator ** is right-associative, which means it is evaluated from right to left. In the given expression print(3 - 2 ** 2 ** 3 + 99 / 11), the innermost exponentiation (2 ** 3) is evaluated first, followed by the outer exponentiation (2 ** 8). Then subtracting the result of the exponentiation from 3, 3 − 256 = −253, then adding the result of the division ((99/11) = 9) to the previously calculated value −253 + 9 = −244.0. The expression is evaluated as follows:3 - 2 ** 2 ** 3 + 99 / 11= 3 - 2 ** 8 + 99 / 11= 3 - 256 + 99 / 11= 3 - 256 + 9.0= -253 + 9.0= -244.0

Question 4

Question 4Select the correct output of the code:s = "Python is fun"
l = s.split()
s_new = "-".join([l[0].upper(), l[1], l[2].capitalize()])
print(s_new)PYTHON-IS-FunPYTHON-is-FunPython-is-funPYTHON-Is -Fun

Accepted Answer

PYTHON-is-FunReason — The code initializes a string variable s with the value 'Python is fun'. It splits the string into words using split() method, then converts the first word to uppercase ('PYTHON') using indexing and the upper() method, and capitalizes the third word ('Fun') with the capitalize() method. It then joins the modified words with a hyphen ('-') as the separator using the join() method and prints the result.

Question 5

Question 5In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and another table, Beta has degree 3 and cardinality 5, what will be the degree and cardinality of the Cartesian product of Alpha and Beta?5, 38, 153, 515, 8

Accepted Answer

8, 15Reason — When performing a Cartesian product (cross join) of two tables, the resulting table retains all columns from both tables. Therefore, the degree of the Cartesian product is the sum of the degrees of the two tables i.e., Degree of Alpha + Degree of Beta = 5 + 3 = 8. Similarly, the cardinality of the Cartesian product is the total number of rows resulting from the cross join, which is the product of the cardinalities of the two tables, i.e., Cardinality of Alpha * Cardinality of Beta = 3 * 5 = 15.

Question 6

Question 6Riya wants to transfer pictures from her mobile phone to her laptop. She uses Bluetooth Technology to connect two devices. Which type of network will be formed in this case?PANLANMANWAN

Accepted Answer

PANReason — A personal area network (PAN) is the interconnection of information technology devices within the range of an individual person, typically within 10 meters. Bluetooth technology is used to create PANs for short-range wireless communication between devices. In Riya's case, she is using Bluetooth to connect her mobile phone to her laptop within a range of about 10 meters, forming a PAN (Personal Area Network).

Question 7

Question 7Which of the following will delete key-value pair for key = “Red” from a dictionary D1 ?delete D1("Red")del D1["Red"]del.D1["Red"]D1.del["Red"]

Accepted Answer

del D1["Red"]Reason — The syntax to delete a key-value pair from a dictionary in Python is : del dictionary_name[key]. Therefore, according to this syntax, del D1["Red"] is correct statement."

Question 8

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 9

Question 9Which of the following statement(s) would give an error during execution of the following code ?tup = (20, 30, 40, 50, 80, 79)
print(tup) #Statement 1
print(tup[3] + 50) #Statement 2
print(max(tup)) #Statement 3
tup[4] = 80 #Statement 4Statement 1Statement 2Statement 3Statement 4

Accepted Answer

Statement 4Reason — The statement that would give an error during execution of the given code is Statement 4 (tup[4] = 80). This is because tuples in Python are immutable, meaning we cannot modify the elements of a tuple after it has been created. Here, it is attempting to assign 80 to the element at the index 4 of a tuple, which results in an error because tuples do not support item assignment.

Question 10

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 11

Question 11Fill in the blank:The modem at the sender’s computer end acts as a ............... .ModelModulatorDemodulatorConvertor

Accepted Answer

ModulatorReason — The modem at the sender's computer end acts as a modulator, which is responsible for converting digital data into analog signals for transmission over the communication channel.

Question 12

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 13

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 14

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 15

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

Question 16

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 17

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 18

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 19

Question 19(a)(i) Expand the following terms: POP3, URL(ii) Give one difference between XML and HTML.

Accepted Answer

(i) POP3 – Post Office Protocol 3URL – Uniform Resource Locator(ii) One difference between XML and HTML:HTML( Hyper text mark Up language)XML (Extensible Markup Language)It is a static web development language – only focuses on how data looks. It is used for only displaying data, cannot transport data.It is a dynamic web development language – as it is used for transporting and storing data.

Question 20

Question 19(b)(i) Define the term bandwidth with respect to networks.(ii) How is http different from https ?

Accepted Answer

(i) Bandwidth is the maximum rate of data transfer over a given transmission medium or the amount of information that can be transmitted over a network.(ii) HTTPS (Hyper Text Transfer Protocol Secure) is the protocol that uses SSL (Secure Socket Layer) to encrypt data being transmitted over the Internet. Therefore, HTTPS helps in secure browsing while HTTP does not.

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