| Annual Examination (2024-25) Class-11 Subject: -INFORMATICS PRACTICES (065) Time: 3hrs MM: 70 | ||
| Q.No. | SECTION-A (21 X 1 = 21 Marks) | Marks |
| Q1 | Which of the following is/are invalid identifiers? a) Else b) while c) _Good d) 11class | 1 |
| Q2 | Which of the following is/are relational operator? a) // b) >= c) and d) ** | 1 |
| Q3 | if a= 3 and b = 5 then (a > b and b>a) evaluate to: a) True b) False c) True and True d) None of these | 1 |
| Q4 | Which of the following is not the advantage of Python language? a) expressive b) cross platform c) free & open source d) Strong on type binding | 1 |
| Q5 | Evaluate the given expression- 2+3**2**2-15%7*4 a) 79 b)83 c) 10 d) 14 | 1 |
| Q6 | Which SQL clause is used to filter rows of the table? a) Select b) Where c) Order by d) Update | 1 |
| Q7 | State True or False- Dictionary keys can be of mutable data type. | 1 |
| Q8 | Which of the following is invalid declaration of a dictionary? a) D=dict() b) D={} c) D={11:11, 22:22} d) D=dict{} | 1 |
| Q9 | Which of the following will return the key, value pair of the dictionary? a)keys() b) values() c)items() d) All of these | 1 |
| Q10 | What will be the output of the following? L=[10,20,30] print( L*2) print( L+[2]) | 1 |
| Q11 | Which of the following will add an element in the end of the list? a) append() b) extend() c) add() d)update() | 1 |
| Q12 | Which of the following is the literal in python? a)pass b) null c) ; d) None | 1 |
| Q13 | The in operator in python is- a) identity b) arithmetic c) logical d) membership | 1 |
| Q14 | Give output of the following code: A=10 if A !=10 : print(A+20) else : print (A+10) A=A+5 print(A) | 1 |
| Q15 | Which one of the following has the same precedence level? a) Addition and Subtraction b) Multiplication, Division and Addition c) Multiplication, Division, Addition and Subtraction d) Addition and Multiplication | 1 |
| Q16 | State True or False- pop( ) method/function can be used to remove multiple elements at multiple index of a list. | 1 |
| Q17 | A relation can have only one______key and one or more than one ______keys. (A)PRIMARY, CANDIDATE b) CANDIDATE, ALTERNATE c) CANDIDATE, PRIMARY d) ALTERNATE, CANDIDATE | 1 |
| Q18 | If my_dict is a dictionary as defined below, then which of the following statements will not give an error? my_dict = {‘apple’: 10, ‘banana’: 20, ‘orange’: 30} (a)my_dict[“Orange”] b) print(my_dict+{ “grapes” :50}) c) my_dict[‘apple’]=20 d) print(my_dict[20]) | 1 |
| Q19 | Suppose list1 is [3, 4, 5, 20, 5], what is list1.index(5)? a) 0 b) 1 c) 4 d) 2 | 1 |
| 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 | ||
| Q20 | Assertion (A):- Dictionary is an ordered collection data type. Reason (R):- Dictionary store the data as key value pair. | 1 |
| Q21 | Assertion (A):- In SQL “create table” is a DDL command. Reason (R):- It is used to define a structure of a new table in SQL. | 1 |
| Q.No. | SECTION-B (7 X 2 = 14 Marks) | Marks |
| Q22 | Define the following terms of Database with example. a) Degree b) Cardinality OR Differentiate between drop and delete commands used in SQL with example. | 2 |
| Q23 | a) Define the term keyword in python. b) What is the difference between elif and else statements in python? | 2 |
| Q24 | What will be the output of following – a) select round( 3478.456,0) b) select mid( “INFORMATICS”, 3,6) | 2 |
| Q25 | Given the following list L= [34,20,40,50,60,70], Write python statements to produce the following outputs: a) [50, 40] b) [20,50,70] OR If L1=[1,2,3,2,1,2,4,2,4,2] (Answer using built-in functions only) A) Write a statement to count the occurrences of element 4 in L1. B) Write a statement to insert an element 20, at index 3 in L1. | 2 |
| Q26 | a) What is alternate key in SQL? Explain with example. b) Identify the DML commands of SQL from following? i) ALTER ii) UPDATE iii) DROP iv) DELETE | 2 |
| Q27 | Rewrite the following code after removing syntactical error and underline the corrections made – T=100 For “a” in range(2,10,2) print( T) | 2 |
| Q28 | Write the output of the following code? a) dict = {“JR” :1, “RJ ” :2} dict.update({“PH”:3 }) print(dict) b) D={ “sun”: 20, “mon”: 30, “tue”: 40} print( 20 in D) print( “tue” not in D.items()) OR Write the output of the following code? D={ 1 : 10, 2: 20 , 3:30 , 4:40 } D[2]=50 D[5]=60 D[3]=len( D) del D[2] print(D) | 2 |
| Q.No. | SECTION-C (4 X 3 = 12 Marks) | Marks |
| Q29 | a) Write SQL query to create a new table FURNITURE with following description- Field Name Data Type Size SNO integer – ITEM char 20 TYPE varchar 30 PRICE float (10,2) STOCKDATE date – b) Write SQL query to add a new row in table with given values- (3 ,”Bookshelf”, “Study”, 38000.50, “2019-01-10”) | 3 (2+1) |
| Q30 | Write the python statements to perform the following on Dictionary DR. DR={ “east”:20, “west”:40} a) Add a new key “north” with value 60 b) Display only keys of the dictionary c) Display only values of the dictionary OR Write the python statements to perform the following on Dictionary DR. DR={ “east”:20, “west”:40} a) Remove the key “east” along its value b) Increase the value of key “west” by 30 c) Display total number of key value pairs in a dictionary | 3 |
| Q31 | Write the output of the following SQL statements: a)SELECT INSTR(‘DATABASE’, ‘A’); b)SELECT TRIM(‘ HELLO WORLD ‘); c)SELECT SUBSTRING(‘Information’, 3, 5); | 3 |
| Q32 | a) Differentiate between reverse() and sort() functions of the LIST. Explain with example. b) What will be the output of the following? L=[4,5,6]+ [1,2,3] L=L [ : : -2] print(L) OR a) Differentiate between remove() and pop() functions of the LIST. Explain with example. b) What will be the output of following code- days=[“sun”, “mon”, “tue”, “wed”, “thur”] print ( days[ -1: -4 : -1]) print (days[ : 2]) | 3 (2+1) |
| Q.No. | SECTION-D (2 X 4 = 8 Marks) | Marks |
| Q33 | Write the output of the queries (i) to (iv) based on the table, TECH_COURSE given below: Table: TECH_COURSE CID CNAME FEES STARTDATE TID C201 Animation and VFX 12000 2022-07-02 101 C202 CADD 15000 2021-11-15 NULL C203 DCA 10000 2020-10-01 102 C204 DDTP 9000 2021-09-15 104 C205 App Development 18000 2022-11-01 101 C206 Digital marketing 16000 2022-07-25 NULL [A]SELECT CID,DAY(STARTDATE) FROM TECH_COURSE; [B]SELECT TID,LEFT(CNAME,3) FROM TECH_COURSE WHERE TID IS NOT NULL; [C]SELECT CNAME, MONTH(STARTDATE) FROM TECH_COURSE WHERE CID NOT IN(‘C203’, ‘C206’, ‘C205’); [D]SELECT CNAME, FEES FROM TECH_COURSE WHERE FEES BETWEEN 15000 AND 17000; | 4 |
| Q34 | [A]Write a python program to create a list of 10 integers, find the sum of even numbers of a list. [B]Write a python program to create a dictionary containing names of 10 classes as key and number of students as value. Display the names of classes, that have more than 50 students. OR a) Write a python program to input n numbers in a list. Count and display how many numbers are ending with digit 4. b) Write a program to create a dictionary of 5 items, where keys are item_code and values are item_name. Display keys and their values separated by ‘## ‘. | 4 (2+2) |
| Q.No. | SECTION-E (3 X 5 = 15 Marks) | Marks |
| Q35 | Write SQL queries based on the given table TRAINER [A]To display the Trainer Name, City & Salary of Trainer whose city is “Mumbai” [B]To display the TNAME and CITY of Trainer who joined the Institute in the year of 2001. [C]To display TNAME, HIREDATE of Trainer whose name is of 5 characters long. [D]To display details of Trainers whose salary is more than 50000 or HireDate is less than “2000-01-01”. [E]To display the last 3 characters of all cities. | 5 |
| Q36 | [A]Write SQL queries to perform following- [i]To list the names of all databases. [ii]Remove the database named “ABC”. [B]Write a python program to create a dictionary of 6 books as key and their price as value. Display the names of books whose price is more than 500. | 5 (2+3) |
| Q37 | [a]WAP to input n integers in a list. Replace each multiple of 7 with its square and remaining elements by its double. [b]WAP to create a dictionary where keys are empid and values are their salary. Enter any empid and check it is a part of dictionary or not. OR [a] WAP to input n two-digit numbers in a list and display sum of both digits of each number of the list. [b]WAP to create a dictionary where keys are roll no and values are percentage. Display minimum and maximum percentage from dictionary. | 5 (2+3) |