Practicing the CBSE Sample Papers for Class 12 Informatics Practices Set 11 allows you to get rid of exam fear and be confident to appear for the exam.
CBSE Sample Papers for Class 12 Informatics Practices Set 11 with Solutions
Time: 3 hrs
Max. Marks: 70
General Instructions:
- This question paper contains five sections, Section A to E.
- All questions are compulsory.
- Section A have 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 03 Long Answer type questions carrying 05 marks each.
- Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against part c only.
- All programming questions are to be answered using Python Language only.
Section – A
Question 1.
In which of the following, users share their activities intentionally like social media activities, online chatting? [1]
(a) Passive digital footprint
(b) Active digital footprint
(c) Both (a) and (b)
(d) None of these
Answer:
(b) Active digital footprint
Question 2.
It is an act of copying another person’s idea, words or work and pretend that they are our own. [1]
(a) Copyright
(b) Virus
(c) Plagiarism
(d) IPR
Answer:
(c) Plagiarism
Question 3.
What will be the output of the given code? [1]
import pandas as pd
s = pd.Series([1,2,3,4,5],
index=[‘akram’,‘brijesh’,‘charu’,‘deepika’,‘era’])
print(s[‘charu’])
(a) 1
(b) 2
(c) 3
(d) 4
Answer:
(c) 3
Question 4.
Feasible method(s) to manage e-Waste. [1]
(a) Reducing
(b) Reusing
(c) Recycling
(d) All of these
Answer:
(d) All of these
Question 5.
Which of the following is the correct syntax of LCASE( ) function? [1]
(a) LCASE (row_name)
(b) LCE (column_name)
(c) LCASE (str/col umn_name)
(d) None of these
Answer:
(c) ITCASE (str/col umn_name)
Question 6.
head( ) function is used to return first _____ rows. [l]
(a) n-1
(b) n+1
(c) n2
(d) n
Answer:
(d) n
Question 7.
Abdul deleted all his chats from all his social media accounts and he thinks that all his traces are deleted completely. Is he right in thinking so? [1]
(a) Yes
(b) No
(c) May be
(d) Not sure
Answer:
(b) No
Question 8.
What is a correct syntax to return the values of first row of a Pandas DataFrame? Assuming the name of the DataFrame is dfRent. [1]
(a) dfRent[0]
(b) dfRent.loc[1]
(c) dfRent.loc[0]
(d) dfRent.iloc[1]
Answer:
(c) dfRent.loc[0]
Question 9.
Which type of network is formed, when you connect two mobiles using bluetooth to transfer a picture file? [1]
(a) LAN
(b) MAN
(c) PAN
(d) WAN
Answer:
(c) PAN (Personal Area Network)
Question 10.
The MySQL function returns the specified number of characters from a particular position of a given string. [1]
(a) MID ( )
(b) SUBSTRING ( )
(c) SUBSTR ( )
(d) All of these
Answer:
(d) All of these
Question 11.
Geometric arrangement of devices on the network is called [1]
(a) topology
(b) protocols
(c) media
(d) LAN
Answer:
(a) topology
Question 12.
Which of the following SQL statement will give output as 190.5 after execution? [1]
(a) SELECT ROUND(190.52,0);
(b) SELECT ROUND(190.52,-1);
(c) SELECT R0UND(190.52,2);
(d) SELECT R0UND(190.52,1);
Answer:
(d)SELECT R0UND(190.52,1 );
Question 13.
We should exhibit proper manners and etiquettes while being online. Choose the right netiquette (s). [1]
(a) Avoid cyber bullying
(b) Respect other’s privacy
(c) No copyright violation
(d) All of these
Answer:
(d) All of these
Question 14.
Which one of the following function is used to find the largest value from the given data in MySQL? [1]
(a) MAX( )
(b) MAXIMUM ( )
(c) BIG( )
(d) LARGE( )
Answer:
(a) MAX( )
Question 15.
In SQL, which function is used to display current date and time? [1]
(a) DATE ( )
(b) TIME ( )
(c) CURRENT ( )
(d) NOW ( )
Answer:
(d) NOW ( )
Question 16.
Which aggregate function returns the count of all rows in a specified table? [1]
(a) SUM ( )
(b) DISTINCT ( )
(c) COUNT ( )
(d) None of these
Answer:
(c) COUNT
Question 17.
Assertion (A) Social media are websites or applications that enable their users to participate in social networking but they cannot create and share content with others in the community. [1]
Reason (R) We should not waste precious time in responding to unnecessary emails or comments unless they have some relevance for us.
(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 but R is true.
Answer:
(d) In social networking, we can create and share content with others in the community. We must respect time and be precise. We should not waste precious time in responding to unnecessary emails.
Question 18.
Assertion (A) Boolean indexing is a type of indexing. [1]
Reason (R) Boolean vectors can be used to filter the data.
(a) Both A and R are true and R is the correct explanation of A.
(b) A is true but R is false.
(c) A is false but R is true.
(d) Both A and R are false.
Answer:
(a) Boolean indexing is a type of indexing. In boolean indexing, boolean vectors can be used to filter the data where multiple conditions can be grouped in brackets.
Section – B
Question 19.
Using copyright, software piracy can be stopped. How? [2]
Answer:
The copyright is the work of authorship immediately becomes the property of the author, who created the work. Only the author or those deriving their rights through the author, can rightfully claim copyright.
Or
List some advantages of e-Waste recycling?
Answer:
Some advantages of e-Waste recycling are
(i) Conserves natural resources
(ii) Protects environment
(iii) Create jobs
(iv) Saves landfill space
(v) Save money
Question 20.
Write statement to print elements within a range. [2]
Answer:
DataFrame_Object.i1ocfstartindex : endindex]
Question 21.
Write a Python code to create a DataFrame with appropriate headings from the list given below [2]
[‘S101′, Amy’, 70], [‘S102′, ‘Bandin’, 69], [‘S104’, ‘Cathy’, 75], [‘S105’, ‘Gundaho’, 82]
Answer:
import pandas as pd
data=C[‘SlOl’, ‘Amy’, 70],
[‘S102’, ‘Bandhi’, 69],
[‘S104’, ‘Cathy’, 75],
[‘S105’, ‘Gundaho’, 82]]
df=pd.DataFrame (data, col umns=[‘ID’,‘Name’, ‘Marks’])
print(df)
Question 22.
What will be the output of the following code [2]
>>>import pandas as pd
>>>A=pd.Series(data=[35,45,55,40])
>>>print(A>40)
Answer:
0 False
1 True
2 True
3 False
Question 23.
Kiyaan, a database administrator needs to display house wise total number of records of ‘Blue’ and ‘Green’ house. He is encountering an error while executing the following query:
SELECT HOUSE, COUNT (*) FROM SCHOOL GROUP BY HOUSE WHERE H0USE=‘Blue’ OR H0USE= ‘Green ’ ;
Help him in identifying the reason of the error and write the correct query by suggesting the possible correction (s). [2]
Answer:
The problem with the given SQL query is that WHERE clause should not be used with GROUP BY clause. To correct the error, HAVING clause should be used instead of WHERE.
Correct query is:
SELECT HOUSE, COUNT(*) FROM SCHOOL GROUP BY HOUSE HAVING H0USE= ‘Blue’ OR H0USE=‘Green ’ ;
Question 24.
Which SQL function is used to remove leading and trailing spaces from a character expression X, where X = ‘INFORMATION ###PRACTICE####’ (# denotes a blank space) and also give the output of X. [2]
Answer:
TRIM( ) function is used to remove all leading and trailing spaces from the given character expression.
Syntax
TRIM ([{BOTH/ LEADING/ TRAILING) [remstr] FROM] str)
e.g.mysql>SELEOT TRIM (‘INFORMATION### PRACTICE####’);
Output
INFORMATION###PRACTICE
Spaces between ‘INFORMATION’ and ‘PRACTICE’ cannot be removed.
Question 25.
What is the advantage of using switch over hub? [2]
Answer:
(i) A switch is faster than a hub.
(ii) A switch offers fuil-duplex communication while a hub offers only half-duplex.
Or
List two differences between a website and a web page.
Answer:
Differences between website and web page are as follows
| Website | Web Page |
| It is a group of related web pages addressed to a typical URL. | It is a part of website which comprises links to other web pages. |
| here is no extension used in the URL of a website. e.g. Amazon, Flipkart etc. | The web page URL has an extension. e.g. Contact pages, registration, login etc. |
Section – C
Question 26.
Explain the term plagiarism. Mention any two ways to avoid plagiarism. [3]
Answer:
Plagiarism is the act of using or stealing someone else’s intellectual work, ideas etc. and passing it as your own work. In other words, plagiarism is a failure in giving credit to its source. Plagiarism is a fraud and violation of Intellectual Property Rights. Since, IPR holds a legal entity status, violating its owners right is a legally punishable offence.
Two ways to avoid plagiarism:
(i) Be original
(ii) Cite/acknowledge the source
Or
Smridh has recently changed his school, so he is not aware of the people, but someone is posting negative, demeaning comments on his social media profile. He is also getting repeated mails from unknown people. Everytime he goes online, he finds someone chasing him online.
(i) Smridh is a victim of
(ii) What should Smridh needs to do inorder to protect his personal information’ or data from unintentional and intentional attacks .
(iii) Why are netiquettes important?
Answer:
(i) Cyber stalking
(ii) The incidents should be reported to the parents, school authorities and the cyber crime cell, since this would keep him safe from future troubles. If ignored these can put him into a deeper web of cyber problems.
(iii) Netiquettes are important as they promote communication skills, prevent miscommunications, and help you understand what is socially acceptable when working and collaborating online.
Question 27.
Write the code to create the following DataFrame: [3]
| Name | Marks | Subject | |
| a | Abhi | 75 | Maths |
| b | Chirag | 82 | Science |
| c | Tushar | 69 | English |
| d | Mahi | 70 | Science |
| e | Vanshika | 92 | Computer |
Answer:
import pandas as pd
data = {‘Name’ : [‘Abhi’, ‘Chirag’, ‘Tushar’, ‘Mahi’, ‘Vanshika’],
‘Marks’ : [75, 82, 69, 70, 92],
‘Subject’ : [‘Maths’, ‘Science’, ‘English’, ‘Science’, ‘Computer’]}
df=pd. DataFrame (data, index = [‘a’, ‘b’, ‘c’, ‘d’, ‘e’])
pri nt(df)
Question 28.
Consider the following DataFrame dfn that contain vegetables. [3]
| Color | Quantity | Price | |
| Capsicum | Red | 12 | 60 |
| Capsicum | Green | 22 | 100 |
| Chilli | Red | 22 | 40 |
| Chilli | Green | 65 | 55 |
| Lime | Green | 20 | 35 |
Write the code statement to the following:
(i) Find all rows with the label “Chilli”. Extract all columns.
(ii) List 2nd, 3rd and 4th rows.
(iii) List only the columns Quantity and Price using loc.
Answer:
(i) dfn. loc [‘Chilli’, : ]
(ii) dfn. iloc [0 : 3, : ]
(iii) dfn. loc[:, [‘Quantity’, ‘Price’]]
Question 29.
Write the output of following queries. [3]
(i) mysql >SELECT POWER! 9,3);
(ii) mysql > S E L ECT MIDCSHUCHI GOYAL’, 8,5);
(iii) mysql > S E L ECT RIGHT (‘Dus hy ant’,5);
Answer:
(i) 729
(ii) GOYAL
(iii) hyant
Question 30.
Consider the following table CLUB. [3]
Table:CLUB
| COACHNAME | AGE | SPORTS | Date_of_Joining | PAY |
| Rajesh | 30 | Karate | 1999-08-25 | 1000 |
| Anuj | 35 | Swimming | 2000-01-05 | 750 |
| Shuchi | 25 | Basketball | 2005-01-04 | 1200 |
| Reetika | 28 | Badminton | 2002-08-25 | 1400 |
| Virendra | 32 | Cricket | 1996-05-17 | 1500 |
Write SQL queries for the following:
(i) To display the substring of 4 characters of the name of each coach, starting from second character, with their age.
(ii) To display the day for the Date_of_Joining column.
(iii) To concat the COACHNAME with AGE where age of coach is above 30 years.
Answer:
(i) SELECT SUBSTR(COACHNAME, 2,4),AGE FROM CLUB;
(ii) SELECT DAY(Date_of_Joining) FROM CLUB;
(iii) SELECT CONCAT (COACHNAME, AGE) FROM CLUB WHERE AGE>30;
Or
What is the purpose of GROUP BY clause in MySQL? How is it different from ORDER BY clause?
Answer:
The GROUP BY clause can be used to combine all those records that have identical value in a particular field or a group of fields. Whereas, ORDER BY clause is used to display the records either in ascending or descending order based on a particular field. For ascending order, ASC is used and for descending order DESC is used. The default order is ascending order.
Section – D
Question 31.
Write the code for the following graph which display the different style multiline in same plot. [5]
Answer:
import matplotl ib.pyplot as pit
xl = [10,20,30]
yl = [20,40,10]
x2 = [10,20,30]
y2 = [40,10,30]
plt.xlabel(‘x – axis’)
plt.ylabel(‘y – axis’)
plt.piot(xl,y1, color=‘black’, linewidth = 5, label = ‘ linel-dotted’, linestyle=‘dashed’)
plt.plot(x2,y2, coldr=‘magenta’, linewidth =3, label = ‘line2-dashed’, linestyle=‘dotted’)
plt.title(“Plot with different styles”)
pit.1egend( )
plt.showf( )
Or
Write a Python code to create a line graph for the data given below based on TV SHOWS rated by the users.
Shows=[” The Kapil Sharma Show”,”Friends’’,”India has Got Talent”,”Big Boss”,”Dance India Dance”]
Rating=[4.2,4.8,5.0,3.8,4.1]
Answer:
import matplotlib.pyplot as pit
Shows=[“The Kapil Sharma Show”,”Friends”,”India has Got Talent”,”Big Boss”,”Dance India Dance”]
Ratings[4.2,4.8,5.0,3.8,4.1]
plt. piot(Shows.Rating)
plt.title(“TV SHOWS”)
plt.xlabel(“Shows”)
plt.ylabel(“Rating”)
pit.show( )
Question 32.
Consider the following records in ‘Garment’ table. [5]
Table: Garment
| Gcode | Gname | Size | Color | Price |
| 111 | Tshirt | XL | Red | 1400.00 |
| 112 | Jeans | L | Blue | 1600.00 |
| 113 | Skirt | M | Black | 1100.00 |
| 114 | Jacket | XL | Blue | 4000.00 |
| 115 | Trousers | L | Brown | 1500.00 |
| 116 | LadiesTop | L | Pink | 1200.00 |
Write the commands for the following
(i) To delete the record with Geode as 116.
(ii) Display the Gname and Price with price highest to lowest.
(iii) To change the color of Garment with code as 116 to “Orange”.
(iv) What is the degree and cardinality of ‘Garment’ table?
(v) Identify the primary key of table Garment.
Answer:
(i) DELETE FROM Garment WHERE Gcode=116;
(ii) SELECT Gname, P-rice FROM Garment ORDER BY Price DESC;
(iii) UPDATE Garment SET Color =‘‘0range” WHERE Gcode=116;
(iv) Cardinality is the number of rows and degree is the number of columns in a table, Cardinality = 6, Degree = 5
(v) Geode
Or
Explain the given below functions:
(i) INSTR( )
(ii) DATE( )
(iii) LENGTH( )
(iv) SUM( )
(v) MOD( )
Answer:
(i) INSTR( ) This function takes a string and a substring of it as arguments and returns an integer which indicates the position of the first occurrence of the substring within the string.
Syntax INSTR (ori_str, sub_str)
(ii) DAY( ) This function returns the day of month (from 1 to 31) from a date specified as an argument.
Syntax DAY (date/col umn_name)
(iii) LENGTH( ) This function returns the length of the string in bytes. The length of the string also includes all the blanks.
Syntax LENGTH(string/column_name)
(iv) SUM( ) This function returns the sum of values in the specified column.
Syntax SUM (col umn_name)
(v) MOD( )This function returns the remainder of a number dividing by another number.
Syntax M0D(DIVIDEND,DIVISOR)
Question 33.
Bias Methodologies is planning to expand their network in India, starting with three cities in India to build infrastructure for research and development of their chemical products. The company has planned to set up their main office in Pondicherry at three different locations and have named their offices as Back Office, Research Lab and Development Unit. The company has one more research office namely Corporate Unit in Mumbai. A rough layout of the same is as follows: [5]
Approximate distance between these offices are as follows:
| From | To | Distance |
| Research Lab | Back Office | 110 m |
| Research Lab | Development Unit | 16 km |
| Research Lab | Corporate Unit | 1800 km |
| Back Office | Development Unit | 13 km |
In continuation of the above, the company experts have planned to install the following number of computers in each of their offices
| Research Lab | 158 |
| Back Office | 79 |
| Development Unit | 90 |
| Corporate Unit | 51 |
(i) Suggest the type of network required (out of LAN, MAN, WAN) for connecting each of the following office units.
(a) Research Lab and Back Office
(b) Research Lab and Development Unit.
(ii) Which one of the following device, will you suggest for connecting all the computers with in each of their office units?
(a) Switch/Hub
(b) Modem
(c) Telephone
(iii) Company is planning to get its website designed which will allow students to see their results after registering themselves on its server. Out of the static or dynamic, which type of website will you suggest?
(iv) Suggest a cable/wiring layout for connecting the company’s local office units located in Pondicherry. Also, suggest an effective method/technology for connecting the company’s office unit located in Mumbai.
(v) Which building is suitable to install the server with suitable reason?
Answer:
(i) (a) LAN
(b) MAN
(ii) (a) Switch/Hub
(iii) Dynamic
(iv) 
An effective method/technology for connecting the company’s offices unit located in Mumbai is dial-up or broadband.
(v) Research lab is suitable to install the server because it has maximum number of computers.
Section – E
Question 34.
Zeenat has created the following DataFrame dataframel to keep track of data Rollno, Name, Marksl and Marks2 for various students of her class, where row indexes are taken as the default values: [1+1+2]
| Name | Marks1 | Marks2 |
| Swapnil Sharma | 30 | 50 |
| Raj Batra | 75 | 45 |
| Bhoomi Singh | 82 | 95 |
| Jay Gupta | 90 | 95 |
(a) What will be the output of the following codes?
(i) printfdataframel. size)
(ii) print(dataframel[ ‘ Rol 1 no ’ ]= =2)
(b) Write the code to print the highest marks obtained in Marksl and Marks2.
Or (Option for part (b) only)
Suppose a DataFrame contains information about student having columns : rollno, name, class and section. Write Python code to delete column section of DataFrame.
Answer:
(a) (i) 16
(ii) 2 Raj Batra 75 45
(b) print((dataframe1.Marks1.max( )),(dataframel.Marks2.max( )))
Or
del df[‘section’]
Question 35.
A Gift Gallery has different stores in India. Database Administrator Abhay wants to maintain database of their Salesmen in SQL to store the data. [1+1+2]
Consider the following records in ‘Salesman’ table and answer the given questions.
Table: Salesman
| Scode | Sname | Address | Dtofjoin | Sales | Area |
| 100 | Sushant | Delhi | 2017/09/29 | 5000.90 | East |
| 101 | Sushant | Gurgaon | 2018/01/01 | 7000.75 | East |
| 102 | Priya | Noida | 2018/04/25 | 3450.45 | West |
| 103 | Mohit | Delhi | 2018/11/03 | 6000.50 | North |
| 104 | Priyanshi | Delhi | 2019/12/15 | 8000.62 | North |
(i) Display Sname and Sales of East and West areas.
(ii) Display the total Sales made in East Area.
(iii) The command to display the Name of the Salesman along with the Sales amount rounded off to one decimal point.
Or (Option for part (iii) only)
The command to display the length of salesman najne.
Answer:
(i) SELECT Sname, Sales FROM Salesman WHERE Area=‘‘East” OR Area=“West”;
(ii) SELECT SUM(Sales) FROM Salesman WHERE Area=”East”;
(iii) SELECT Sname, R0UND( Sal es , 1) FROM Salesman;
Or
SELECT LENGTH (Sname) FROM Salesman;