Students must start practicing the questions from CBSE Sample Papers for Class 11 Informatics Practices with Solutions Set 5 are designed as per the revised syllabus.
CBSE Sample Papers for Class 11 Informatics Practices Set 5 with Solutions
Time Allowed: 3 hours
Maximum Marks: 70
General Instructions:
- This question paper contains five sections, Section A to E.
- All questions are compulsory.
- Section A has 18 questions carrying 01 mark each.
- Section B has 07 Very Short Answer type questions carrying 02 marks each.
- Section C has 05 Short Answer type questions carrying 03 marks each.
- Section D has 02 questions carrying 04 marks each.
- Section E has 03 questions carrying 05 marks each.
- All programming questions are to be answered using Python Language only.
Section-A
Section A Consists of 18 questions of 1 mark each
Question 1.
Which of the following is used to transfer data between the processor (CPU) and memory?
(A) Buffer
(B) Cache
(C) TLB
(D) Registers
Answer:
(D) Registers
Explanation: A processor (CPU) contains several registers to temporarily store data during the program’s execution.
Question 2.
It is a mediated environment which creates the sensation in a user of being present in a (physical) surrounding.
(A) WWW
(B) VR
(C) HMD
(D) GUI
Answer:
(B) VR
Explanation: VR (Virtual Reality) is a mediated environment which creates the sensation in a user of being present in a (physical) surrounding.
Question 3.
Which of the following consumes the most amount of electricity ?
(A) TFT
(B) LCD
(C) CRT
(D) All consume same power
Answer:
(C) CRT
Explanation: The Cathode ray tube monitors are heavy, big in size and consume the most amount of electricity.
Question 4.
The …………….. character displays all the columns of a table in a select query
(A) #
(B) @
(C) *
(D) /
Answer:
(C) *
Explanation: The * character displays all the columns in a query.
Question 5.
In which type of memory, once the program or data is written, it cannot be changed?
(A) EEPROM
(B) PROM
(C) EPROM
(D) None of these
Answer:
(B) PROM
Explanation:
In Programmable Read-Only Memory (PROM), if there is an error in writing instructions or data, the error cannot be erased. PROM chip becomes unusable.
Question 6.
Which is not one of the features of the IoT devices?
(A) Remotely controllable
(B) Programmable
(C) Can turn themselves off if necessary
(D) All of the above.
Answer:
(C) Can turn themselves off if necessary
Question 7.
Which of the following is an identity operator?
(A) = =
(B) NOT IN
(C) IS
(D) None of the mentioned
Answer:
(C) IS
Explanation: The IS operator matches values in its both sides. It is the identity operator.
Question 8.
The …………….. command removes a table completely.
(A) Delete
(B) Remove
(C) DROP
(D) Update
Answer:
(C) DROP
Explanation: The DROP table command removes a table completely along with its data.
Question 9.
The “Set” clause is used along with ………………. command.
(A) Delete
(B) Describe
(C) Create
(D) Update
Answer:
(D) Update
Explanation: The update command updates the data of a table. It uses the “Set” clause to specify the field to be updated.
Question 10.
Which among the following is not indexed ?
(A) List
(B) Tuple
(C) String
(D) Dictionary
Answer:
(D) Dictionary
Explanation: A dictionary stores values in key:value pair.
Question 11.
What is true about the following SQL statement?
Select * from student;
(A) Displays contents of table ‘student’ ‘
(B) Displays column names and contents of table ‘student’
(C) Results in error as improper case has been used
(D) Displays only the column names of table ‘student’
Answer:
(B) Displays column names and contents of table ‘student’
Explanation: The command displays the entire contents of the table along with column names.
Question 12.
What will be the output of the following code : Ep.i
“abc”==”pqr” and 17%2 == math.pow(12,0)
(A) True
(B) False
(C) 15
(D) None of these
Answer:
(B) False
Explanation :
“abc”==”pqr” and 17%2 == math.pow(12,0)
= False and 1==1
= False and True
= False
Question 13.
The ……………. providers can offer different kinds of computing infrastructure, such as servers, virtual machines (VM), storage and backup facility, network components, operating systems or any other hardware or software.
(A) SaaS
(B) PaaS
(C) IaaS
(D) None of the above
Answer:
(C) IaaS
Explanation:
Infrastructure as a service (IaaS) is a system of cloud computing that delivers virtualized computing resources over the internet. IaaS is one of the three main categories of cloud computing services, together with software as a service (SaaS) and platform as a service (PaaS).
Question 14.
The default date format in which date has to be stored in MYSQL is :
(A) DD-MM-YYYY
(B) DD-YY-MM
(C) MM-YY-DD
(D) YYYY-MM-DD
Answer:
(D) YYYY-MM-DD
Explanation: By default, MYSQL stores date in YYYY-MM-DD format.
Question 15.
Which of the following commands will create a list ?
(A) list1 = list()
(B) list1 = [ ]
(C) list1 = list([1, 2,3])
(D) All of these
Answer:
(D) All of these
Explanation: The list is a sequence data type which is used to store the collection of data.
Question 16.
Which of the following does not use optical technology ?
(A) CD ROM
(B) DVD
(C) Blue ray disc
(D) Floppy disc
Answer:
(D) Floppy disc
Explanation: A floppy disc is a magnetic memory device.
Directions (Q17 and Q18): In the following questions, a statement of Assertion a) is followed by a statement of Reason (R).
Mark the correct choice.
Question 17.
Assertion (A): A computer must boot before it can be used.
Reason (R): Booting is of two types (a) Warm booting and (b) Cold booting.
(A) Both A and R are true and R is the correct explanation of A
(B) Both A and R are true but R is NOT the correct explanation of A
(C) A is true but R is False
(D) A is false and R is true
Answer:
(B) Both A and R are true but R is NOT the correct explanation of A
Question 18.
Assertion (A): A dictionary is not used index.
Reason (R): The keys of the dictionary are its indices 1
(A) Both A and R are true and R is the correct explanation of A
(B) Both A and R are true but R is NOT the correct explanation of A
(C) A is true but R is False
(D) A is false and R is true
Answer:
(C) A is true but R is False
Explanation: A dictionary is not used index.
Section B
Section B Consists of 7 questions of 2 marks each
Question 19.
Predict the output
x = 15 y = 10 z = 15 print (x = = y) print (x > z) print (z < y)
Answer:
Output
False
False
False
OR
Define the floor division (//) operator with an example.
Answer:
Floor division operator is used to divide the first operand by the second operand but it shows only the whole part of the result and fractional part is truncated.
e.g.,
print (45.5//5) print(46//4) print (23//2) Output 9.0 11 11
Question 20.
Predict the output
10 < 20 and 10
10 > 20 or 20
10 < (10 or 20)
10 > 20 not 20
Answer:
Output
10
20
False
Invalid syntax
Question 21.
Write SQL query to get information of students where student is not assigned any subject.
Answer:
SELECT * FROM Student WHERE Subject IS NULL;
Question 22.
Write the corresponding Python assignment statements:
(i) Assign the average of values of variables length and breadth to a variable sum.
(ii) Assign a list containing strings ‘Paper’, ‘Gel Pen’, and ‘Eraser’ to a variable stationery.
Answer:
(i) sum = (length + breadth)/2
(ii) stationary = [‘Paper’, ‘Gel Pen’, ‘Eraser’]
Question 23.
Define the following terms:
(i) IaaS
(ii) PaaS.
Answer:
(i) IaaS: IaaS stands for Infrastructure as a Service that contains the basic building blocks for cloud IT. It provides access to networking features, computers and data storage space.
(ii) PaaS: PaaS stands for Platform as a Service that removes the need for you to manage underlying infrastructure and allows you to focus on the deployment and management of your application.
Question 24.
Write a Python program to input cost amount and selling amount and display profit or less.
Answer:
cost_price = float(input(“Enter the cost Price of an object:”)) Selling_price = float(input(“Enter the Selling Price of an object.”)) if(cost_price>selling_price): amount = cost_price-selling_price print(“Total Loss Amount = “, amount) else: amount = selling_price-cost_price print(“Total Profit Amount = “,amount)
Question 25.
Observe the below code and underline the error (s) if any
list= () sum=1 number = hit (input(’How many numbers:’)) for i in range (number): num = mt (input(”Enter number”)) list.append () for ï in range (O, number): sum - list[iI print (“Sum of elements m a given list is:”, sum)
Answer:
list=[ ] sum=0 number = int (input(‘How many numbers:’)) for i in range (number): num = int (input(“Enter number”)) list.append (num) for i in range (0, number): sum += list[i] print (“Sum of elements in a given list is:”, sum)
Section C
Section C Consists of 5 questions of 3 marks each
Question 26.
Write SQL queries with respect to the Movie table given below (NCERT)
(i) Retrieve movie information without mentioning their column names.
(ii) List business done by the movies showing only MovielD, Moviename and Business cost.
(iii) List the different categories of movies
Answer:
(i) Select * from Movie;
(ii)Select MovieID,Moviename,Businesscost from movie;
(iii) Select DISTINCT category from movie;
OR
Table: Cellphone
ModalId | Brand | Type | Cost |
M01 | Samsung | 4G | 12500 |
C11 | Realme | 2G | 15000 |
T12 | TCL | 3G | 7000 |
D402 | Nokia | 4G | 6500 |
M02 | Samsung | 5G | 25000 |
(i) To display details of 3G cell phones whose cost is greater thanTZ000
(ii) To increase cost of 2G phones by 10%
(iii) To display details of phones whose Modelld ends with “2” cv
Answer:
(i) Select * from Cellphone where Type=”3G” and cost>12000;
(ii) Update Cellphone set Cost=Cost + Cost*0.1 where type=”2G”;
(iii) Select * from Cellphone where ModelId like “%2”;
Question 27.
Explain the following methods
(i) insert ( )
(ii) extend ( )
(iii) remove ( )
Answer:
(i) insert (): This method inserts an element to the list at a given index.
Syntax listName.insert (index, element)
(ii) extend (): This method extends the list by adding all items to the list (passed as an argument) at the end.
Syntax list1.extend (list2)
(iii) remove (): This method searches for the given element in the list and removes the first matching element.
Syntax listName.remove (element)
Question 28.
Explain the use of the following clauses :
(i) Between
(ii) Order By
(iii) DISTINCT
Answer:
(i) Between clause: The between clause is used to
specify ranges in a query . It is the replacement
of “greater than equal to >= and less than equal
to <=”
Select * from employee where sal between 10000 and 20000;
The command displays the details of employees whose salary is between 10000 and 20000
(ii) Order by: The order by clause is used to arrange the records in ascending or descending order. The clauses ASC and DESC are used to specify ascending or descending.
Select * from employee order by name DESC; The above command arranges the records of employee table in descending order of names and displays them.
(iii) DISTINCT: The distinct clause lists only the Unique values in a field
Select DISTINCT DEPT from employee;
The above command displays only the different departments in the employee table.
Question 29.
Answer the following questions with respect to database concepts:
(i) How can you show the list of databases in the MYSQL system.
(ii) How can you show the tables that are present in a database.
(iii) Is it compulsory to provide values for all columns of a table while adding records?
Answer:
(i) The list of databases can be displayed using the :
SHOW DATABASES ; command
(ii) The list of tables in a database can be shown using the :
SHOW TABLES ; command
(iii) No it is not compulsory to provide values for all columns of a table while adding records. We can use NULL values wherever values are missing.
OR
Give the terms for each of the following:
(i) Collection of logically related records.
(ii) The skeleton structure that represents the logical view of the entire database.
(iii) Attribute that can uniquely identify the tuples in a relation.
Answer:
(i) Database
(ii) Database schema
(iii) Primary key
Question 30.
Write a program to read a list of n integers (positive as well as negative). Create two new lists, one having all positive number and the other having all negative numbers from the given list. Print all three lists. [3]
Answer:
List1 = [ ] l1 = [ ] l2 = [ ] n = int(input(“Enter number of elements:)) for i in range (1, n + 1): b = int(input(“Enter element”)) list1.append(b) print(“Orignal list”, list1) for j in list1: if(j>0): l1.append(j) else: l2.append(j) print(“Positive list:”, l1) print(“Negative list:”, l2)
Section D
Section D Consists of 2 questions of 4 marks each
Question 31.
Consider the following table product, where product_ID is primary key; product_Name and product_Price cannot be Null.
Write SQL queries for the following :
(i) Display those product Names whose price is greater than or equal to 500.
(ii) Display those product whose names start with ‘B’.
(iii) Display only the name and rating of all products.
(iv) Increase amount of products by 200 whose name starts with “B”.
Answer:
(i) SELECT Product_Name from Product where Product_Price>= 500;
(ii) SELECT Product_Name from Product where Product_Name Like ‘B%’;
(iii) Select Product_Name, Product_Rating from Product ;
(iv) Update Product set Amount=Amount +200 where Product_Name Like “B%”;
Question 32.
Write the use of following List methods ?
(i) count
(ii) pop
(iii) sorted
OR( For part iii only)
Write the use of del method of a list.
Answer:
(i) count(): This method returns the number of occurrences of an element in a list.
Syntax listName. count (element)
(ii) pop(): This method removes the item at the given index from the list. This method also returns the removed item.
Syntax listName.pop (index)
(iii) sorted(): The sorted() function arranges the elements of a list and stores them to another list.
OR (For Part (iii) only)
The del method deletes elements from a list. It can also be used to remove a range of elements from the list.
Example : del Lst[0:2]
Section E
Section E Consists of 3 questions of 5 marks each
Question 33.
Write SQL commands for the table Garments given below:
Table : Garments
(i) Display details of “Cotton” and “Silk” garments
(ii) Increase price of “Silk” garments by 200, if their price is less than 2000.
(iii) Add a new column Reorder of type integer(4)
(iv) Remove the column Reorder
(v) Delete the records of garments whose Gname has 1st character as “S” and 3rd character as “r”
Answer:
(i) Select * from Garments where Type IN (“Cotton”,”Silk”);
(ii) Update Garments set price=price+200 where price <2000 and type=”Silk”;
(iii) Alter table garments ADD Reorder integer(4);
(iv) Alter table garments DROP COLUMN reorder;
(v) Delete from Garments where Gname like “S_r%”;
OR
Write SQL queries with respect to the table Doctor given below :
Table : Doctor
(i) Display details of all doctors.
(ii) Remove records of doctors whose charges is morethan 1000
(iii) Display name and charges of “ENT” doctors
(iv) Display names of doctors who visit on “Monday”
(v) Increase charges of Ortho doctors by 250
Answer:
(i) Select * from doctor;
(ii) Delete from doctor where charges>1000;
(iii) Select Dname, Charges from Doctor where Dept=”ENT”;
(iv) Select Dname from Doctor whereVisitdays=”Mon”;
(v) Update Doctor set charges = charges + 250 where Dept = ”Ortho”;
Question 34.
Explain data deletion and recovery.
Answer:
One of the biggest threats associated with digital data is its deletion. The storage devices can malfunction or crash down resulting in the deletion of the stored data.
Deleting digitally stored data means changing the details of data at the bit level, which can be very time consuming. Therefore, when any data is simply deleted, its address entry is marked as free and that much space is shown as empty to the user, without actually deleting the data.
In case data gets deleted corrupted or accidentally, there arises a need to recover the data. Recovery of the data is possible only if the contents/memory space marked as deleted has not been over-written by some other data. Data recovery is a process of retrieving deleted corrupted and lost data from secondary storage devices.
Question 35.
Consider the table Teacher given below
Table: Teacher
Based on the table write SQL queries for the following :
(i) To display only names of teachers of “History” department. ’
(ii) To display the name, age and department of teachers whose name has “a” as the 2nd letter.
(iii) To increase the salary of Male teachers by 5% who are in “Computer Sc” department.
(iv) To display details of all teachers.
(v) To display details of those teachers whose age is more than 40.
Answer:
(i) Select Name from Teacher where Department=”History”;
(ii) SELECT Name, Age, Department from Teacher where Name like “_a%”;
(iii) Update Teacher Set Salary= Salary + Salary *0.05 where Gender=”M” and
Department=”Computer Sc”;
(iv) SELECT * FROM TEACHER;
(v) SELECT * FROM TEACHER WHERE Age > 40;
OR
Consider the table Employee given below
Based on the table write SQL queries for the following:
(i) To display the name of employees whose salary not known.
(ii) To display DEPTID from the table EMPLOYEE without repetition.
(iii) To modify the column Desig and change its width to varchar(25).
(iv) To display the all details of employees.
(v) To display emp id and name of employees whose designation starts with A;
Answer:
(i) Select Name,SALARY from EMPLOYEE where Salary IS NULL ;
(ii) SELECT Distinct(DEPTID) from EMPLOYEE;
(iii) Alter table Employee MODIFY DESIG varchar(25);
(iv) SELECT * FROM EMPLOYEE;
(v) SELECT EMPID, NAME FROM EMPLOYEE WHERE DESIG LIKE “A%”;