Question 1

Question 1What will be the output of the function given below?>>import math
>>abs(math.sqrt(25))Error5-55.0

Accepted Answer

5.0Reason — The given code calculates the square root of 25 using the math.sqrt() function from the math module, resulting in 5.0 since sqrt() returns a floating-point number. Applying abs() to a positive number like 5.0 doesn't alter the value, thus the final output remains 5.0.

Question 2

Question 2A ............... function allows us to write a single record into each row of a CSV file.

Accepted Answer

A writerow function allows us to write a single record into each row of a CSV file.

Question 3

Question 3Does the Primary key of a table accept null or duplicate value? Justify.

Accepted Answer

A primary key in a table does not accept null or duplicate values. A primary key is a set of one or more attributes/fields that uniquely identifies a tuple/row in a table. It must contain unique values, i.e., non-redundant, and cannot be re-declared or left null.

Question 4

Question 4Identify the Domain name and URL from the following: http://www.income.in/home.aboutus.html

Accepted Answer

The domain name is www.income.in indicating the network domain hosting the website, while the URL is http://www.income.in/home.aboutus.html, specifying the specific page or resource within that domain.

Question 5

Question 5Which protocol is used to create a connection with a remote machine?

Accepted Answer

Telnet protocol is used to create a connection with a remote machine.

Question 6

Question 6Which of the following cannot be returned by random.randrange(4) ?032.3None of these

Accepted Answer

2.3Reason — The random.randrange(4) function returns a randomly selected integer from the range [0, 1, 2, 3], which includes integers only. It cannot return a floating-point number like 2.3.

Question 7

Question 7Find errors (if any) in the following code and rewrite the code underlining each correction:x = int("Enter value of x:")
for in range[0, 10]:
    if x = y
        print("They are equal") 
    else:
        Print("They are unequal")

Accepted Answer

x = int("Enter value of x:") #Error 1
for in range[0, 10]: #Error 2
    if x = y #Error 3
        print("They are equal") 
    else:
        Print("They are unequal") #Error 4Error 1 — The input() function is missing from the code to prompt the user for input.Error 2 — The syntax of the range() function uses parentheses () rather than square brackets [] and the variable y is missing in the for loop declaration (for y in range(0, 10):).Error 3 — The comparison operator in the if statement has = (assignment) instead of == (equality comparison) and colon (:) is missing at the end.Error 4 — The print function should be written with a lowercase 'p' for proper syntax.The corrected code is:x = int(input("Enter value of x:"))
for y in range(0, 10):
    if x == y:
        print("They are equal") 
    else:
        print("They are unequal")

Question 8

Question 8Mr. William wants to remove all the rows from table INVENTORY to release the storage space but he does not want to remove the structure of the table. What MySQL statement should he use?

Accepted Answer

DELETE FROM INVENTORY;This statement will delete all rows from the INVENTORY table, freeing up storage space, but it will not remove the structure or schema of the table.

Question 9

Question 9A computer or a device that requests resources or data from the server is called ............... .

Accepted Answer

A computer or device that requests resources or data from a server is called client.

Question 10

Question 10The readlines() method returns ............... (a list of lines/a list of single characters).

Accepted Answer

The readlines() method returns a list of lines from a file.

Question 11

Question 11Write two advantages of using an Optical Fibre cable over an Ethernet cable to connect two service stations which are 200 m away from each other.

Accepted Answer

The two advantages of using an Optical Fibre cable over an Ethernet cable are as follows:Optical Fibre cables provide higher bandwidth compared to Ethernet cables.Optical Fibre cables can transmit data over longer distances without experiencing signal degradation or loss compared to Ethernet cables.

Question 12

Question 12What is the use of "w" in file handling?

Accepted Answer

In file handling, the "w" mode is used to open a file for writing. If the file exists, it will be overwritten. If the file does not exist, a new file will be created with the specified name.

Question 13

Question 13Rewrite the following SQL statement after correcting the error(s). Underline the corrections made.INSERT IN STUDENT (RNO, MARKS)   
VALUE (5, 78.5);

Accepted Answer

INSERT IN STUDENT (RNO, MARKS) -- Error 1  
VALUE (5, 78.5); -- Error 2Error 1 — The correct syntax in SQL for inserting data into a table is "INSERT INTO", not "INSERT IN".Error 2 — The correct keyword used in SQL to specify the values being inserted into the table is "VALUES", not "VALUE".The corrected code is:INSERT INTO STUDENT(RNO, MARKS) 
VALUES (5, 78.5);

Question 14

Question 14Write a function Push() which takes number as argument and add in a stack "MyValue".SolutionMyValue = []

def Push(number):
    MyValue.append(number)
    print(number, "pushed to the stack.")

Push(5)
Push(10)
Push(15)Output5 pushed to the stack.
10 pushed to the stack.
15 pushed to the stack.

Accepted Answer

Please refer to the full solution above.

Question 15

Question 15Write the output of the following code:for i in range(5):
    print(i)

Accepted Answer

Output0
1
2
3
4

Question 16

Question 16Expand the following:(a) LIFO(b) FIFO

Accepted Answer

(a) LIFO — Last-In First-Out(b) FIFO — First-In First-Out

Question 17

Question 17Assertion (A): Program should check for Overflow condition before executing Push operation on stack and similarly check for Underflow condition before executing Pop operation.Reasoning (R): In stack, Underflow condition signifies that there is no element available in the stack while Overflow condition means no further element can be pushed in the stack.Both A and R are true and R is the correct explanation of A.Both A and R are true but 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 A and R are true and R is the correct explanation of A.ExplanationIt is essential to check for overflow conditions before executing a Push operation on a stack to ensure that the stack has enough space to accommodate the new element. Similarly, checking for underflow conditions before executing a Pop operation is necessary to prevent deleting elements from an empty stack. An underflow condition indicates an empty stack, while an overflow condition indicates a stack that has reached its maximum capacity and cannot accept more elements.

Question 18

Question 18Assertion (A): ('x' and 'y' or not 7) is a valid expression in Python.Reason (R): In Python, strings and numbers can be treated as Boolean values.Both A and R are true and R is the correct explanation of A.Both A and R are true but 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 A and R are true and R is the correct explanation of A.ExplanationIn the expression ('x' and 'y' or not 7), both 'x' and 'y' are non-empty string literals, hence they are evaluated as True, and 7 is a non-zero number, also evaluated as True. Therefore, this expression results in 'y'. In Python, when evaluating expressions in a Boolean context, such as conditions in if statements, non-empty strings, non-zero numbers, and non-None values are considered True, while empty strings, numeric zero (0), and None are considered False.

Question 19

Question 19(a)Define Primary Key.

Accepted Answer

A primary key is a set of one or more attributes or fields that uniquely identify a tuple or row in a table.

Question 20

Question 19(b)Define Foreign Key.

Accepted Answer

A foreign key is a non-key attribute whose value is derived from the primary key of another table in a database.

Practice Paper

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