PRACTICE QUESTION PAPER

SECTION A

1. State whether the following statement is True or False:
   print() method without any argument shall display a blank line.

2. Identify the output of the following code snippet:
   string=”LearnPythonProgramming”
   result=string.strip().upper().replace(“”,”_”)
   print(result)

(a) LEARNPYTHONPROGRAMMING
(b) Learn_Python_Programming
(c) Learn_python_programming
(d) LEARN_PYTHON_PROGRAMMING

3. Which of the following expressions evaluates to True?
   (a) 5 * 2 == 10 and not (7 <= 5 or 3 == 4)
   (b) 8 > 10 or (4 == 4 and 6 > 8)
   (c) 12 != 12 or (3 * 2 < 5 and 4 == 4)
   (d) 15 < 10 and (2 < 3 or 8 == 8)

4. What will be the output of the following code?
   text=”HelloWorld”
   print(text.lower().replace(“o”,”0″))

(a) hello w0rld
(b) Hello W0rld
(c) hell0 w0rld
(d) Hello World

5. What will be the output of the following code snippet?
   text=”AdvancedProgramming”
   result=text[-12:-5][::-1]
   print(result)

6. What will be the output of the following code?
   data={‘A’:(5,8),’B’:(3,6),’C’:(7,2)}
   result=data[‘A’][1]+data[‘B’][0]-data[‘C’][1]
   print(result)

7. If student_info is a dictionary as given below, which statement will raise an error?
   student_info={‘id’:101,’name’:’John’,’grade’:’A’}

8. What does list.sort() method do in Python?

9. EMPLOYEES table has 4 rows and 3 columns and PROJECTS table has 3 rows and 2 columns.
   Find the degree and cardinality after Cartesian Product.

10. Write the missing statement:
    file=open(“data.txt”,”r”)
    data=file.read(200)

new_data=file.read(100)
file.close()

11. State whether the following statement is True or False:
    The process of fixing errors in a program is called debugging.

12. What will be the output of the following code?
    x=15
    def modify():
    global x
    x=x+5
    print(“Inside function:”,x)
    modify()
    print(“Outside function:”,x)

13. Which SQL command is used to delete the entire table?

14. What will be the output of the following query?
    SELECT COUNT(DISTINCT album_no)
    FROM Music
    WHERE artist_name IS NOT NULL;

15. Which of the following is NOT a valid SQL data type?
    (a) VARCHAR
    (b) TEXT
    (c) BOOLEAN
    (d) STRING

16. To find average salary of employees, which SQL function is used?

17. Which protocol is used to send e-mails?

18. Which device connects multiple networks and translates protocols?

19. Explain bandwidth in computer networks.

20. Assertion (A): Default arguments must be placed after non-default arguments.
    Reason (R): This ensures correct parameter order.

21. Assertion (A): GROUP BY is used to aggregate data.
    Reason (R): HAVING filters records after aggregation.

SECTION B

22. Differentiate between List and Tuple with examples.

23. Explain any two dictionary methods with syntax.

24. Write Python statements:
    (i) Insert ‘orange’ at second position in list fruits
    OR
    Extend numbers list by [4,5]

(ii) Remove ‘banana’
OR
Find sum of numbers list

25. Identify output and find minimum and maximum possible values of variable start.

26. Correct the errors in the following code:
    def calculate_average(nums):
    total=0
    for i in nums
    total+=i
    average=total/len(nums)
    return “average”

(i) Name the constraint that allows NULL but no duplicate values
OR
Name the constraint used to relate two tables

(ii) Write SQL command to add NOT NULL constraint
OR
Write SQL command to add DEFAULT value

28. Write any two advantages of optical fibre cable
    OR
    What is VoIP?

SECTION C

29. Write a Python function to find the longest word in a file
    OR
    Write a function to reverse lines of a file

30. Write stack operations for customer records
    OR
    Write stack operations for numbers divisible by 5

31. Predict the output of the given Python code
    OR
    Predict the output of list operations

SECTION D

32. Consider the table GIFTS and write SQL queries
    OR
    Write output of the given SQL queries

33. A CSV file “Success.csv” contains survey data.
    Write functions to:
    (i) Display records with population > 30000000
    (ii) Count number of records

34. Using EMPLOYEES and PROJECTS tables, write required SQL queries.

35. Write Python functions to insert and retrieve records from FLORIST table using database connectivity.

SECTION E

36. Write Python functions to manage book records in a binary file.

37. A company plans a campus network.
    Answer questions related to server location, cabling, repeater, hardware and network type.