Arts (English Medium) Class 12 - CBSE Question Bank Solutions for Computer Science (Python)

Consider the table CLUB given below and write the output of the SQL queries that follow.

1. SELECT COUNT(DISTINCT SPORTS) FROM CLUB;
2. SELECT CNAME, SPORTS FROM CLUB
   WHERE DOAPP<"2006-04-30" AND CNAME LIKE "%NA";
3. SELECT CNAME, AGE, PAY FROM CLUB WHERE GENDER = "MALE" AND PAY BETWEEN 1000 AND 1200;

Write a function in Python to read a text file, Alpha.txt and displays those lines which begin with the word ‘You’.

Write a function, vowelCount() in Python that counts and displays the number of vowels in the text file named Poem.txt.

Consider the tables PRODUCT and BRAND given below:

Write SQL queries for the following:

1. Display product name and brand name from the tables PRODUCT and BRAND.
2. Display the structure of the table PRODUCT.
3. Display the average rating of Medimix and Dove brands.
4. Display the name, price, and rating of products in descending order of rating.

How is http different from https?

Give one difference between alternate key and candidate key.

Define the following:

Exception Handling

Define the following:

Throwing an exception

Define the following:

Catching an exception

Explain catching exceptions using try and except block.

You have learnt how to use math module in Class XI. Write a code where you use the wrong number of arguments for a method (say sqrt() or pow()). Use the exception handling process to catch the ValueError exception.

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")