Commerce (English Medium) Class 12 - CBSE Question Bank Solutions

Write the use and syntax for the following method:

seek()

The correct syntax of seek() is ______

Predict the output of the Python code given below:

def Diff(N1,N2):
 if N1>N2:
 return N1-N2
 else:
 return N2-N1

NUM= [10,23,14,54,32]
for CNT in range (4,0,-1):
 A=NUM[CNT]
 B=NUM[CNT-1]
 print(Diff(A,B),'#', end=' ')

MakeInIndia Corporation, a Uttarakhand-based IT training company, is planning to set up training centres in various cities in the next 2 years. Their first campus is coming up in the Kashipur district. At the Kashipur campus, they are planning to have 3 different blocks for App development, Web designing, and Movie editing. Each block has a number of computers, which are required to be connected to a network for communication, data, and resource sharing. As a network consultant of this company, you have to suggest the best network-related solutions for the issues/problems raised in questions keeping in mind the distances between various blocks/locations and other given parameters.

Distance between various blocks/locations:

Number of computers

1. Suggest the most appropriate block/location to house the SERVER in the Kashipur campus (out of the 3 blocks) to get the best and most effective connectivity. Justify your answer.
2. Suggest a device/software be installed in the Kashipur Campus to take care of data security.
3. Suggest the best-wired medium and draw the cable layout (Block to Block) to economically connect various blocks within the Kashipur Campus.
4. Suggest the placement of the following devices with appropriate reasons:
   a. Switch/Hub
   b. Repeater
5. Suggest a protocol that shall be needed to provide a Video Conferencing solution between Kashipur Campus and Mussoorie Campus.

The syntax of seek() is:
file_object.seek(offset[,reference_point])

What is the default value of reference_point?

Name any two DML commands.

“In a Python program, if a break statement is given in a nested loop, it terminates the execution of all loops in one go.”

Which of the following functions changes the position of file pointer and returns its new position?

What is the use of finally clause? Use finally clause in the problem given below.

print (" Learning Exceptions…")
try:
    num1 = int(input ("Enter the first number"))
    num2 = int(input("Enter the second number"))
    quotient=(num1/num2)
    print ("Both the numbers entered were correct")
except ________:           # to enter only integers
    print (" Please enter only numbers")
except __________:       # Denominator should not be zero
    print(" Number 2 should not be zero")
else:
    print(" Great .. you are a good programmer")
___________________ :       # to be executed at the end
print(" JOB OVER… GO GET SOME REST")

Why is it advised to close a file after we are done with the read and write operations? What will happen if we do not close it? Will some error message be flashed?

What is the difference between the following set of statements (a) and (b):

1. P = open(“practice.txt”,”r”)
   P.read(10)
2. with open(“practice.txt”, “r”) as
   P: x = P.read()

Site any two differences between Single Row Functions and Aggregate Functions.

Write the name of the functions to perform the following operation:

To display the day like “Monday”, and “Tuesday”, from the date when India got independence.

Write the name of the functions to perform the following operation:

To display the specified number of characters from a particular position of the given string.

Write the name of the functions to perform the following operation:

To display the name of the month in which you were born.

Write the name of the functions to perform the following operation:

To display your name in capital letters.

Write the output produced by the following SQL statement:

SELECT ROUND(342.9234, -1);

Write the output produced by the following SQL statement:

SELECT LENGTH("Informatics Practices");

Write the output produced by the following SQL statement:

SELECT    YEAR(“1979/11/26”),
MONTH(“1979/11/26”),    DAY(“1979/11/26”), MONTHNAME(“1979/11/26”);

Write the output produced by the following SQL statement:

SELECT    LEFT("INDIA", 3),    RIGHT("Computer Science", 4),    MID("Informatics", 3, 4), SUBSTR("Practices", 3);