Computer Science · 2023

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

Which of the following is a valid keyword in Python ?

Given the following Tuple Tup= (10, 20, 30, 50) Which of the following statements will result in an error ?

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 ?

Select the correct output of the code :

S = "Amrit Mahotsav @ 75"
A = S.partition(" ")
print(A)

Which of the following mode keeps the file offset position at the end of the file ?

Fill in the blank. _______ function is used to arrange the elements of a list in ascending order.

Which of the following operators will return either True or False ?

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

Fill in the blank. _______ is a number of tuples in a relation.

The syntax of seek( ) is : file_object.seek(offset[,reference_point]) What is the default value of reference_point ?

Fill in the blank : _______ clause is used with SELECT statement to display data in a sorted form with respect to a specified column.

Fill in the blank : _______ is used for point-to-point communication or unicast communication such as radar and satellite.

What will the following expression be evaluated to in Python ? print(4+3*5/3-5%2)

Which function returns the sum of all elements of a list ?

fetchall() method fetches all rows in a result set and returns a :

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.

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.

Atharva is a Python programmer working on a program to find and return the maximum value from the list. The code written below has syntactical errors. Rewrite 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

Differentiate between wired and wireless transmission.

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

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

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

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

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

What is the need of Protocols ?

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)

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

Differentiate between CHAR and VARCHAR data types in SQL with appropriate example.

Name any two DDL and any two DML commands.

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 ?

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;

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 :

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 :

He lived in a little house in a beautiful, green wood.
He saw a little girl skipping through the woods, whistling happily.

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 :

On seat2 VIP1 will sit and
On seat1 VVIP2 will be sitting

The output should be :

Number of words ending with a digit are 4

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;

Write the command to view all databases.

Write a function EOReplace() in Python, which accepts a list L of numbers. Thereafter, it increments all even numbers by 1 and decrements all odd numbers by 1.

Example : If the input list is :

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

The output will be :

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

A list contains the following record of a 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 :

["Siddharth", "Delux"]
["Rahul", "Standard"]
["Jerry", "Delux"]

The stack should contain : Jerry, Siddharth

And the output of Pop_Cust() should be :

Jerry
Siddharth
Underflow

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 every car manufactured by 'TATA' (in any case — Tata, TaTa, etc.) onto the stack.

For example, if the dictionary contains :

Vehicle = {"Santro": "Hyundai", "Nexon": "TATA", "Safari": "Tata"}

The stack should contain : Safari, Nexon

Quickdev, an IT-based firm located in Delhi, is planning to set up a network for its four branches within the city with its Marketing department in Kanpur. As a network professional, give solutions to the questions (i) to (v), after going through the branches locations and other details which are given below:

Distance between various branches is as follows :

Number of computers in each of the branches :

(i) Suggest the most suitable place to install the server for the Delhi branch with a suitable reason.

(ii) Suggest an ideal layout for connecting all these branches within Delhi.

(iii) Which device will you suggest, that should be placed in each of these branches to efficiently connect all the computers within these branches ?

(iv) Delhi firm is planning to connect to its Marketing department in Kanpur which is approximately 300 km away. Which type of network out of LAN, WAN or MAN will be formed ? Justify your answer.

(v) Suggest a protocol that shall be needed to provide help for transferring of files between Delhi and Kanpur branch.

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

Predict the output of the code given below :

def makenew(mystr):
    newstr = ""
    count = 0
    for i in mystr:
        if count % 2 != 0:
            newstr = newstr + str(count)
        else:
            if i.lower():
                newstr = newstr + i.upper()
            else:
                newstr = newstr + i
        count += 1
    print(newstr)

makenew("No@1")

The code given below deletes the record from the table employee which has the structure :

E_code  - String
E_name  - String
Sal     - Integer
City    - String

Note: Username is root, Password is root, the table exists in MySQL database named emp.

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

The code given below reads the records from the table employee and displays only those whose city is 'Delhi'. The table has the structure :

E_code  - String
E_name  - String
Sal     - Integer
City    - String

Note: Username is root, Password is root, MySQL database is named emp.

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 employees from city 'Delhi'. - Statement 3 — to read the complete data of the query into the object named details.

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)

Write one difference between CSV and text files. 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 cid, s_name, Source, destination to store Courier ID, Sender name, Source and Destination address respectively.

(ii) COURIER_SEARCH() — Takes the destination as input and displays all the courier records going to that destination.

Why is it important to close a file before exiting ? 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 book_ID, B_name, pub to store book ID, book name and publisher respectively.

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

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

Table : LAB

(i) Identify the columns which can be considered as Candidate keys.

(ii) Write the degree and cardinality of the table LAB.

(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.

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

Shreyas is a programmer who has been given the task of writing a function write_bin() to create a binary file Cust_file.dat containing customer records — customer number (c_no), name (c_name), quantity (qty), price (price) and amount (amt).

The function accepts c_no, c_name, qty and price. If qty is less than 10, it prints 'Quantity less than 10 ..... Cannot SAVE'. Otherwise it computes amt = price * qty and writes the record (as a list) to the binary file.

import pickle

def write_bin():
    bin_file = __________              # Statement 1
    while True:
        c_no = int(input("enter customer number"))
        c_name = input("enter customer name")
        qty = int(input("enter qty"))
        price = int(input("enter price"))
        if __________ :                # Statement 2
            print("Quantity less than 10..Cannot SAVE")
        else:
            amt = price * qty
            c_detail = [c_no, c_name, qty, price, amt]
            __________                 # Statement 3
            ans = input("Do you wish to enter more records y/n")
            if ans.lower() == 'n':
                __________             # Statement 4
    ______________                     # Statement 5

______________                         # Statement 6

Answer the following : (i) Write the correct Statement 1 to open 'Cust_file.dat' for writing. (ii) Write Statement 2 to check whether qty is less than 10. (iii) Write Statement 3 to write data to the binary file and Statement 4 to stop further processing if the user does not wish to enter more records.

(iii) (Option only for part (iii))

What should Shreyas fill in : - Statement 5 to close the binary file named Cust_file.dat ? - Statement 6 to call the function write_bin() that writes data to the binary file ?

(Refer to the code template given in part (i) of question 35.)