State True or False.
"Identifiers are names used to identify a variable, function in a program"

Solution

Which of the following is a valid keyword in Python ?
(a) false
(b) return
(c) non_local
(d) none

Solution

Given the following Tuple:
Tup= (10, 20, 30, 50)
Which of the following statements will result in an error ?
(a) print(Tup[0])
(b) Tup.insert(2,3)
(c) print(Tup[1:2])
(d) print(len(Tup))

Solution

Consider the given expression :
5 < 10 and 12 > 7 or not 7 > 4
Which of the following will be the correct output, if the given expression is evaluated?
(a) True
(c) NONE
(b) False
(d) NULL

Solution

Select the correct output of the code:
S= "Amrit Mahotsav@ 75"
A=S.partition (" ")
print (a)
(a) ( 'Amrit Mahotsav', '@' , '75')
(b) [ 'Amrit','Mahotsav' , '@' , '75']
(c) ('Amrit', 'Mahotsav @ 75')
(d) ('Amrit', ' ', 'Mahotsav @ 75')

Solution

Which of the following mode keeps the file offset position at the end of the file?
(a) r+
(c) w
(b) r
(d) a

Solution

Fill in the blank:
________ function is used to arrange the elements of a list in ascending order.
(a) sort()
(b) arrange ()
(c) ascending()
(d) asort ()

Solution

Which of the following operators will return either True or False ?
(a) +=
(b) !=
(c) =
(d) *=

Solution

·Which of the following statement(s) would give an error after executing the following code ?

Stud= { "Murugan": 100, "Mithu": 95} # Statement 1
print (Stud[95]) # Statement 2
Stud["Murugan]= 99 # Statement 3
print(Stud.pop()) # Statement 4
print(Stud) # Statement 5

(a) Statement 2
(b) Statement 3
(c) Statement 4
(d) Statements 2 and 4

Solution

Fill in the blank.
__________ is a number of tuples in a relation.
(a) Attribute
(b) Degree
(c) Domain
(d) Cardinality

Solution

The syntax of seek() is :
file_object.seek
(offset[,reference_point])
What is the default value of reference _point ?
(a) 0
(b) 1
(c) 2
(d) 3

Solution

Fill in the blank :
________ clause is used with SELECT statement to display data in a sorted form with respect to a specified column
(a) WHERE
(b) ORDER BY
(c) HAVING
(d) DISTINCT

Solution

Fill in the blank:
______is used for point to point communication or unicast communication such as radar and satellite.
(a) INFRARED WAVES
(b) BLUETOOTH
(c) MICROWAVES
(d) RADIOWAVES

Solution

What will the following expression be evaluated to in Python?

print(4 + 3 * 5 / 3 - 5 % 2)
(a) 8. 5
(c) 10.2
(b) 8.0
(d) 10.0

Solution

Which function returns the sum of all elements of a liSt ?
(a) count()
(b) sum()
(c) total()
(d) add()

Solution

fetchall() method fetches all rows in a result set and returns a:
(a) Tuple of lists
(b) List of tuples
(c) List of strings
(d) Tuple of strings

Solution

Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as
(a) Both A and R are true and R is the correct explanation for A
(b) Both A and R are true and R is not the correct explanation for A
(c) A is True but R is False
(d) A is false but R is True

Assertion (A) : To use a function from a particular module, we need to import the module.
Reason (R): import statement can be written anywhere in the program, before using a function from that module

Solution

Assertion (A): A stack is a LIFO structure.
Reason (R) : Any new element pushed into the stack always gets positioned at the index after the last existing element in the stack.

Solution

Atharva is a Python programmer working on a program to find and ret~rn the maxunum value from the list. The code written below has syntactical errors. Rwrite the correct code and underline the corrections made.

def max_num (L) :
    max=L(0)
    for a in L:
      if a > max
      max=a
    return max
                

Solution

def max_num (L) :
max=L[0]
for a in L:
    if a > max :
        max=a
return max   
             

(a) Differentiate between wired and wireless transmission

Solution

(b) Differentiate between URL and domain name with the help of an appropriate example.

Solution

(a) Given is a Python list declaration:
Listofnames=
["Aman","Ankit","Ashish","Rajan",
"Rajat"]
Write the output of:
print(Listofnames [-1:-4:-1])

Solution

(b) Consider the following tuple declaration :
tupl=(10, 20, 30, (10,20,30), 40)
Write the output of
print(tupl.index(20))

Solution

Explain the concept of "Alternate Key" in a Relational Database Management System with an appropriate example.

Solution

(a) Write the full forms of the following :
(i) HTML
(ii) TCP

Solution

(b) What is the need of Protocols?

Solution

(a) Write the output of the code given below :

def short_sub (lst,n) :
    for i in range (0,n) :
        if len (lst)>4:
           lst [i]= lst [i]+lst[i]
        else:
           lst[i]=lst[i]
subject=['CS', 'HINDI', 'PHYSICS', 'CHEMISTRY', 'MATHS']
short_sub(subject, 5) 
print(subject)
                

Solution

OR

(b) Write the output of the code given below :

a =30
def call (x) :
    global a
        if a%2==0:
           x+=a
        else:
           x-=a
        return x
x = 20
print(call(35),end="#")
print(call(40),end= "@") 
                    
                    
                

Solution

(a) Differentiate between CHAR and VARCHAR datatypes in SQL with appropriate example.

Solution

Consider the following tables - LOAN and BORROWER :

Table:LOAN



Table:BORROWER



How many rows and columns will be there in the natural join of these two tables ?

Solution

Write the output of the queries (i) to (iv) based on the table, WORKER given below :

TABLE:WORKER



(i) SELECT F~NAME, CITY FROM WORKER ORDER BY STATE DESC;
(ii) SELECT DISTINCT (CITY) FROM WORKER;
(iii) SELECT F_NAME, STATE FROM WORKER WHERE L_NAME LIKE '_HA%';
(iv) SELECT CITY, COUNT ( *) FROM WORKER GROUP BY CITY;

Solution

Write the ·definition of a Python function named LongLines ( which reads the contents· of a text file named 'LINES. TXT' and displays those lines from the file which have at least 10 words in it. For example, if the content of 'LINES. TXT' is as follows :

Once upon a time, there was a woodcutter
He lived in a little house in a beautiful, green wood.
One day, he was merrily chopping some wood.
He saw a little girl skipping through the woods, whistling happily.
The girl was followed by a big gray wolf.

Then the function should display output as :
He lived in a little house in a beautiful, green wood.
He saw a little girl skipping. through the woods, whistling happily.

Solution

 
 def LongLines():
     f=open('LINES.TXT','r')
     data=f.readlines()
     for i in data:
             x=i.split()
             if len(x) >=10:
                     print(i)
     f.close()
              

Write a function count Dwords () in Python to count the words ending with a digit in a text file "Details. txt".

Example:
If the file content is as follows:
On seat2 VIP1 wiil sit and
On seat1 VVIP2 will be sitting
Output will be:
Number of words ending with a digit are 4

Solution

 
 def count_Dwords():
     f=open('Details.txt','r')
     data=f.read()
     x=data.split()
     count=0
     for i in x:
         if i[-1].isdigit()
                 count+=1
     print(count)
     f.close()
              

(a) Write the outputs of the SQL queries (i) to (iv) based on the relations COMPUTER and SALES given below :

Table:COMPUTER



Table:SALES



(i) SELECT MIN (PRICE), MAX (PRICE) FROM COMPUTER;
(ii) SELECT COMPANY, COUNT(*) FROM COMPUTER GROUP BY COMPANY HAVING COUNT (COMPANY)> 1;
(iii) SELECT PROD_NAME, QTY_SOLD FROM COMPUTER C, SALES S WHERE C.PROD_ID=S.PROD_ID AND TYPE= 'INPUT';
(iv) SELECT PROD NAME, COMPANY, QUARTER FROM COMPUTER C SALES S WHERE C.PROD_ID=S.PROD_ID;

(b) Write the command to view all databases.

Solution

Write a function EOReplace0 in Python which accepts a list L of numbers. Thereafter, it increments all even ~umbers by 1 and decrements all odd numbers by 1.

Example:

If Sample Input data of the list is :

L=[10,20,30,40,35,55]

Output will be :

L=[11,21,31,41,34,54]

Solution

 
 def EOReplace():
     for i in range(L):
             if L[i] %2 ==0:
                 L[i]+=1
             else:
                 L[i]-=1
     print(L)    
              

A list contains following record of customer:
[Customer_name, Room Type]
Write the following user defined functions to perform, given operations on the stack named 'Hotel' :

(i) Push_ Cust () - To Push customers' names of those customers who are staying in 'Delux' Room Type.

(ii) Pop_ Cust () - To Pop the names of customers from the stack and display them. Also, display "Underflow" when there are no customers in the stack.

For example:

If the lists with customer details are as follows :
["Siddarth", "Delux"]
["Rahul", "Standard"]
["Jerry", "Delux"]

The stack should contain
Jerry
Siddharth

The output should be:

Jerry
Siddharth
Underflow

Solution

 
 l=[["Siddarth","Delux"],["Rahul","Standard"],["Jerry","Delux"]]
 stck=[]
 def Push_Cust(L):
         for i in range(len(L)):
             if L[i][1]=="Delux":
                     stck.append(L[i][0])
 
 Push_Cust(l)
 print(stck)
                          
              

 def Pop_Cust():
     if len(stck) == 0:
         print("Underflow")
     else:
         print("Customer Name:", stck.pop())
 
 Pop_Cust()
 Pop_Cust()
 Pop_Cust()
                 

Write a function in Python, Push (Vehicle) where, Vehicle is a dictionary containing details of vehicles - { Car _Name: Maker}. The function should push the name of car manufactur19- by 'TATA' (including all the possible cases like Tata, TaTa, etc.) to the stack.

For example:

If the dictionary contains the following data:
Vehicle={"Santro":"Hyundai","Nexon":"TATA","Safari":"Tata"}

The stack should contain
Safari
Nexon

Solution

 
 Vehicle={"Santro":"hyundai","Nexon":"TATA","Safari":"Tata"}
 stck=[]
 def Push(Vehicle):
         for i in Vehicle:
             if (Vehicle[i].lower())=="tata":
                     stck.append(i)
 
 Push(Vehicle)
 print(stck)
                              
              

 def Pop_Cust():
     if len(stck) == 0:
         print("Underflow")
     else:
         print("Customer Name:", stck.pop())
 
 Pop_Cust()
 Pop_Cust()
 Pop_Cust()
                 

(a) What possible output(s) are expected to be displayed on screen at the
time of execution of the following program

import random
M=[5,10,15,20,25,30]
for i in range(1,3):
      first=random.randint(2,5)- 1
      sec=random.randint(3,6)- 2
      third=random.randint(1,4)
      print(M[first],M[sec],M[third],sep="#")

(i)   10#25#15       (ii) 5#25#20
      20#25#25            25#20#15

(iii) 30#20#20     (iv) 10#15#25# ·
      20#25#25          15#20#10# 

                

Solution

(b) The code given below deletes the record from. the table employee which contains the following record structure :
E_code - String
E_name - String
Sal - Integer
City - String
Note the following to establish connectivity between Python and MySQL :
• Username is root
• Password is root
• The table exists in MySQL database named emp
• The details (E_code,E_name,Sal,City) are the attributes of the table.

Write the following statements to complete the code :

Statement 1 - to import the desired library.
Statement 2 - to execute the command that deletes the record with
E_code as 'E101'.
Statement 3 - to delete the record permanently from the database.

import _____ as mysql             # Statement 1
def delete( ) :
     mydb=mysql.connect(host="localhost",user="root",
     passwd="root",database="emp")
     mycursor=mydb.cursor( )
    ______________           # Statement 2
    ______________           # Statement 3
print ("Record deleted") 

Solution

OR

(a) Predict the output of the code given below :

def makenew(mystr):
     newstr=""
     count=O
     for i in mys tr:·
         if count%2!=0:
             newstr=newstr+str(count)
         else
             if i.lower() :
                 newstr=newstr+i.upper()
             else:
                 newstr=newstr+i
         count+=l
    print(newstr)
makenew ("No@1") 
            

Solution

(b) The code given below reads the following records from the table employee and displays only those records who have employees coming from city 'Delhi'
E_code - String
E_name - String
Sal - Integer
City - String

Note the following to establish connectivity between Python and MySQL :-
• Username is root
• Password is root
• The table exiSts in a MySQL database named emp.
• The details (E_code,E_name,Sal,City) are the attributes of the table.

Write the following statements to complete the code :
Statement 1- to import the desired library.
Statement 2 - to execute the query that fetches records of the employees coming from city 'Delhi'.
Statement 3 - to read the complete data of the query (rows whose city is Delhi) into the object named details, from the table employee in the database

import___________as mysql          # Statement 1 
def display():
        mydb=mysql.connect(host="localhost",user='root", 
        passwd="root",database="emp") 
        mycursor=mydb.cursor() 
        ______________                # Statement 2
        details = ______________      # Statement 3
        for i in details: 
            print (i) 

    

Solution

Write a program in Python that defines and calls the following user defined functions :

(i) COURIER ADD () : It takes the values from the user and adds the details to a csv file 'courier. csv'. Each record consists of a list with field elements as cid, s_name, Source, destination to store Courier ID, Sender name, Source and destination address respectively.

(ii) COURIER SEARCH () : Takes the destination as the input and displays ail the courier records going to that destination.

Solution

import csv

def COURIER_ADD():
    with open('courier.csv', mode='a', newline='') as file:
        writer = csv.writer(file)
        cid = input("Enter Courier ID: ")
        sname = input("Enter Sender Name: ")
        source = input("Enter Source Address: ")
        dest = input("Enter Destination Address: ")
        writer.writerow([cid, sname, source, dest])
    print("Courier details added successfully!")
        

COURIER_ADD()

                          
             

    def COURIER_SEARCH():
    dest = input("Enter Destination Address: ")
    with open('courier.csv', mode='r') as file:
        reader = csv.reader(file)
        for row in reader:
            if row[3].lower() == dest.lower():
                print(row)

COURIER_SEARCH()
                

(b) Write a program in Python that defines and calls the following user defined functions : (i) Add_Book() : Takes the details of the books and adds them to a csv file 'Book.csv'. Each record consists of a list with field elements as book_ID, B_name and pub_to store book ID, book name and publisher respectively.

(ii) Search_Book() : Takes publisher name as input and counts and displays number of books published by them.

Solution

import csv

def Add_Book():
    # Get book details from user
    book_id = input("Enter book ID: ")
    book_name = input("Enter book name: ")
    publisher = input("Enter publisher name: ")
    
    # Write book details to csv file
    with open('Book.csv', mode='a', newline='') as file:
        writer = csv.writer(file)
        writer.writerow([book_id, book_name, publisher])
    print("Book added successfully.")


Add_Book()
        
             

def Search_Book():
    publisher = input("Enter publisher name: ")

    count = 0
    with open('Book.csv', mode='r') as file:
        reader = csv.reader(file)
        for row in reader:
            if row[2].lower() == publisher.lower():
                count += 1


    print("Number of books published by", publisher, "is", count)


Search_Book()
                

The school has asked their state manager Mr. Rahul to maintain the data of all the labs in a table LAB. Rahul has created a table and entered data of 5 labs.



Based on the data given above answer the following questions :

(i) Identify the columns which can be considered as Candidate keys.
(ii) Write the degree and cardinality of the table.
(iii) Write the statements to :

(a) Insert a new row with appropriate data.
(b) Increase the capacity of all the labs by 10 students which are on 'I' Floor

OR

(iii) Write the statements to :

(a) Add a constraint PRIMARY KEY to the column LABNO in the table.
(b) Delete the table LAB

Solution